This a first time foray in PostgreSQL backups (db dumps) and I've been researching the different pgdump formats, other pgdump options, and pgdumpall. For a Postgres beginner looking at taking an ho...

I'm working on the same databse schema on different machines (PostgreSQL). I would like to know, how to merge data from one machine to another. Schema has many tables (around 10). What I want to ac...

I have a Postgres database "rafiu" with many schemas namely test1, test2, test3. In this I want to dump the test2 schema and its data. I tried with the following query pg_dump -U postgres -n test...

I had Postgres 9.0.x installed with homebrew, but because of lack of some modules I removed it using: brew uninstall postgres and installed Postgres 9.1.3 from http://www.enterprisedb.com/downlo...

If I run pg_dump to dump a table into a SQL file, does it take a snapshot of the last row in the table, and dump all the rows up to this row? Or does it keep dumping all the rows, even those that w...

I'm trying to restore a pg_dump taken with this command from another server. sudo -u postgres pg_dump --verbose --format=custom --file=pg-backup.sql -U postgres salesDB After I copied over the p...

Hello everyone i am try to create backup in postgres through dump. when i run the command through command line it wants password when i give the password it will give some error pg_dump: [archiver...

Is there any way to dump a postgres db using psql only ( without pg_dump )? Thanks.

I know PostgresQL pg_dump guarantees consistency even if DB is modified while dump is going on, but I want to know if the final dump contains any data modified/inserted after the dump started. To ...

In short, my question is "why doesn't $libdir work on my PSQL installation." CREATE FUNCTION st_box2d_in(cstring) RETURNS box2d AS '$libdir/liblwgeom', 'BOX2DFLOAT4_in' LANGUAGE c IMMUTABLE STR...

I have been playing around with PostgreSQL lately, and am having trouble understanding how to backup and restore a single table. I used pgadmin3 to backup a single table in my database, in order t...

As subjects, what will happen to the backup file while there is still many active transaction in the database. Does it export realtime or just partially backups ? thanks in advance.

Can I programatically(or whichever way works fine) create the backup of a database, with only the tables I want? I have around 100 tables in my database and I want only 10 tables backup(ofcourse al...