postgres dump needed help.

vickr1z · 11-09-2004, 01:07 AM

good day to all. can anybody help me on postgres? i want to dump a specific table and its data only from the postgres server to local pc in a data.sql??

im only using this command at this time:

Code:

pg_dump -h 192.12.0.100 -U alf -d polmap > dbdump.sql

with this im dumping a large database and it consumed me alot of time before its finished.
i really dont know how to only choose an specific table to dump?
any suggestion will appreciated very much and thanks in advance.

-chris-

rjlee · 11-09-2004, 04:25 AM

Code:

pg_dump -t tablename

You may also need --schema schemaname if you have different tables with the same name in different schemas.

Note that this will not dump any dependant data.

Also, if you're running an older version of Postgresql, please note that newer versions can do data-consistant dumps without using an exclusive lock (so you can still use the database while the dump is being generated).

vickr1z · 11-09-2004, 11:15 PM

Quote:

Originally posted by rjlee

Code:

pg_dump -t tablename

You may also need --schema schemaname if you have different tables with the same name in different schemas.

Note that this will not dump any dependant data.

Also, if you're running an older version of Postgresql, please note that newer versions can do data-consistant dumps without using an exclusive lock (so you can still use the database while the dump is being generated).

thanks for the help rjlee..

now im progressing..

BYW may i ask if you know php programming? just incase, id like to ask if how can i make a php script to connect on remote postgres server.
let say my localhost was 192.19.0.100 and the remote postgres server host was 192.19.0.101.

any idea? thanks again in advance, and more power!

chris

rjlee · 11-10-2004, 03:22 AM

Quote:

Originally posted by vickr1z
BYW may i ask if you know php programming? just incase, id like to ask if how can i make a php script to connect on remote postgres server.
let say my localhost was 192.19.0.100 and the remote postgres server host was 192.19.0.101.

You're better off asking that as a seperate question/thread. I think you just pass the servername of the remote server when making the connection (and a suitable username and password). But I haven't used PHP in a while, and never with postgres myself.