[GENERAL] How to automate password requests?

2007-11-28 Thread Marten Lehmann
Hello, I'm trying to automate some postgresql scripts, but I cannot find a way to pass a password directly to commands like pg_dump psql and so on. Even a echo "password" | psql doesn't work, the password prompt of psql is still waiting. mysql has the -p option. What would be the postgresql

Re: [GENERAL] How to automate password requests?

2008-01-10 Thread Marten Lehmann
Hello, TIP 5: don't forget to increase your free space map settings Read about something called the .pgpass file. There's a way to set a file that contains the password (pgAdmin will create one autmoatically) that pgsql will look for before it asks for your password. It's stored in ~/ The s