Page History

...

Where the subdirectory bin holds the commandline command-line tools and other binaries and the subdirectory data holds the database cluster. Also PostgreSQL will be running by under the system user postgres and the data directory is only accesible by that user. All this is for security.

...

postgres_db\bin\pg_dump -U dba -Fc servoy_repository > servoy_repository.dump

...

postgres_db\bin\pg_restore -U dba -d new_servoy_repository  servoy_repository.dump

...

postgres_db\bin\pg_dumpall > -U dba -f db.out

Reload all database dump

postgres_db\bin\psql -U dba -f db.out postgres

Note that the examples above are very minimalistic. The utilities provided by PostgreSQL offer many options. Check the PostgreSQL documentation on pg_dump, pg_dumpall, pg_restore and pg_sql for detailed information.

Also all the PostgreSQL command-line tools have an extensive help build in. You can access it by using the --help argument.

The samples above assume execution from the ../application_server/ directory.

...