automating remote pg_dump
От
Dick Davies
Тема
automating remote pg_dump
Дата
Msg-id
20050210220000.GE35853@eris.tenfour
Список
Дерево обсуждения
automating remote pg_dump Dick Davies <rasputnik@hellooperator.net>
Re: automating remote pg_dump Tom Lane <tgl@sss.pgh.pa.us>
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' :D -- '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
В списке pgsql-admin по дате отправления