Take the dump of Postgresql database from Linux console
February 20, 2008 at 12:28 pm 1 comment
*To dump data or structure in the database from a dump file
$psql -u DBUserName datbaseName < databaseName_dump.sql
*To take the dump from the database
$pg_dump -u databaseName > filename.sql // data + structure
It will ask the username and password of database
$pg_dump -u databaseName -a > filename.sql // only data
$pg_dump -u databaseName -s > filename.sql // only structure
$pg_dump –username=sql-ledger -W databaseName > filename.sql
It will ask the password of database
Entry filed under: Technical. Tags: database, dbdump, linux, postgres, sql.
1.
Sanjay | February 22, 2008 at 8:23 pm
The exact command should be:
$pg_dump –-username=sql-ledger -W databaseName > filename.sql
or
$pg_dump –U -W databaseName > filename.sql