SEO

#1 (**permalink**) 04-10-2008, 12:22 AM

I notice pg_dump does'nt have a '-P' flag to provide a password, so I assume
you generally use it to pull data through a socket.

I need to run it remotely (to dump a live db and clone its structure to a test
db for unit testing), has anyone got a way to do this?

I've tried 'echo pass | pg_dump -h host -U user dbname' , but she doesnae like it....

extra points for answers that don't include the word 'expect'

--
'Ugh, it's like there's a party in my mouth and everyone's throwing up.'
-- Fry
Rasputin :: Jack of All Trades - Master of Nuns

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

#2 (**permalink**) 04-10-2008, 12:23 AM

Dick Davies <rasputnik@hellooperator.net> writes:
> I notice pg_dump does'nt have a '-P' flag to provide a password,

~/.pgpass is the preferred solution.
http://www.postgresql.org/docs/8.0/s...pq-pgpass.html

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

automating remote pg_dump