Hi, surely you are right. I´m still using 7.2.3 as production database, so I have no experience with .pgpass. Where to put .pgpass if you use pg_dump from a PHP script and the database user is not a system user?
Greetings, Frank Finner On Fri, 25 Jul 2003 17:17:26 -0400 Andrew Sullivan <[EMAIL PROTECTED]> sat down, thought long and then wrote: > On Fri, Jul 25, 2003 at 10:20:38PM +0200, Frank Finner wrote: > > Hi, > > > > with PostgreSQL you can do it using the environment variables PGUSER > > and PGPASSWORD for example in a shellscript like this (bash-syntax): > ^^^^^^^^^^ > > But note that that isn't safe. If you're using >= 7.3, you can use > .pgpass instead, which is much safer. > > A ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])