user name and password woes

From: "Charles Mortell" <cmortell(at)apt-cafm(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: user name and password woes
Date: 2007-12-14 16:25:47
Message-ID: OBEBKAHJIDHDLCIIMKHKCEAJCLAA.cmortell@apt-cafm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The dawg that originally set up postgres 8.0 on one of our Windows 2003
servers has left the company, and I have taken it over.
I need to use pg_dump on that server. When I try to, I get ‘user
"Administrator" does not exist.’
Next I try ‘createuser –U postgres –W administrator –P’. The response is
‘ERROR: user "administrator" already exists.’
I know PG requires a user with the same name as the Windows user and that
should be ‘administrator’ on this server.
Oddly I can connect to PG on this server through PGAdmin (through
postgres user?). Ultimately I want to create a database with a new name from
an existing database; I’ve done this from the command line on other servers.
Can’t, or don’t know how to, do it through PGAdmin.
I’ve also tried to delete and recreate the administrator user from PGAdmin
but I still can’t use pg_dump.
Tried all the passwords my colleagues can think of. I’ve searched the
forums and tried various things like setting pg_hba.conf to trust
temporarily and restarting.
Any suggestions greatly appreciated! Thanks in advance.

Charles Mortell
Advanced Planning Technologies, Inc.
Mississippi River port of La Crosse, WI
cmortell at apt-cafm dot com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Enrico Sirola 2007-12-14 16:27:48 Re: pgsql constraints and temporal tables
Previous Message Tom Lane 2007-12-14 16:06:54 Re: pgsql constraints and temporal tables