On Sat, Jun 22, 2013 at 12:19 AM, Stephen Rasku <srasku@xxxxxxxxx> wrote: > I am trying to write a script that will create and populate a > database. I don't want to enter a password every time so I want to > use a .pgpass file. It has the correct permissions: > > $ ls -l $PGPASSFILE > -rw------- 1 Stephen staff 43 21 Jun 14:48 /Users/Stephen/.pgpass > > However, when I call createdb, it fails: > > $ createdb -h 192.168.1.4 -U postgres --no-password JobSearch > createdb: could not connect to database postgres: fe_sendauth: no > password supplied > > This is the contents of my .pgpass file: > > 192.168.1.4:5432:DatabaseName:postgres:thisIsTheCorrectPassword > > If I omit the --no-password option it will prompt me for a password > and the command will succeed. I am using 9.0.10 from MacPorts. > > What am I doing wrong? >From the error message, the failure is to connect to the database "postgres". Your .pgpass only has an entry for database "DatabaseName". createdb will connect to "postgres" and issue the CREATE DATABASE command there. You can change tihs with the parameter --maintenance-db, but tat was added in 9.2 only. But even so, createdb must connect to an *existing* database in order to issue the CREATE DATABASE command, so you need a line in .pgpass for whichever maintenance db you're using. (also, you should really upgrade to 9.0.13, though that won't change this specific case) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
