It depends on whether or not you on the local host as postgres or not, some
of the parameters.
This is what I use when logged on the the local postgres server:
For everything in the cluster:
pg_dumpall -h 127.0.0.1 -p ${DEST_PORT} -f /backup/pgdump.sql
For just a pg_dump:
pg_dump -c -f /backup/pgdump.sql ${PGDATABASENAME}
There are myriad ways to do pg_dump<all> - local host, server to server
...etc..
IF you can tell me exactly what you are trying to do, I can help ...
Ben Duncan
DBA / Chief Software Architect
Ms State Supreme Court
On Sun, Nov 4, 2018 at 7:25 PM Alex Glaros <[email protected]> wrote:
> Alexandra, I have not used it recently and only have my notes below:
>
> pg_dump --host=
> yourPythonAnywhereDbName.postgres.pythonanywhere-services.com
> --dbname=postgres_myDbName --(note: I don't know how to handle password)
> --port=10097 --username=yourPythonAnywhereRole --format=c
> --file=pg_alex_backup`date +%F-%H%M`.dump
>
> --
> Resources:
> - http://web2py.com
> - http://web2py.com/book (Documentation)
> - http://github.com/web2py/web2py (Source code)
> - https://code.google.com/p/web2py/issues/list (Report Issues)
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/d/optout.
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
