On 06/21/2013 04:29 PM, Stephen Rasku wrote:
On Fri, Jun 21, 2013 at 3:41 PM, Adrian Klaver <adrian.klaver@xxxxxxxxx> wrote:
First are you running the script from the location with .pgpass?
I wasn't but I copied the .pgpass into the local directory and I get
the same results. The correct location is actually in the home
directory.
Second you are doing a createdb, not sure how Postgres handles using .pgpass
with database that does not exist yet? Might want to try a '*' in the database name
field or since it looks like it is trying to connect to the postgres database, use that
as the database name.
The database actually exists, so createdb should fail with a "database
exists" error. However, it didn't get there.
Well the issue is that createdb needs to connect to another database
first in order to create the new database. The default order is shown
below, though it can be overriden:
http://www.postgresql.org/docs/9.2/interactive/app-createdb.html
--maintenance-db=dbname
Specifies the name of the database to connect to when creating the new
database. If not specified, the postgres database will be used; if that
does not exist (or if it is the name of the new database being created),
template1 will be used.
I took your advice anyways and it fixes the problem. Thanks!
...Stephen
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
