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; Ive done this from the command line on other servers.
Cant, or dont know how to, do it through PGAdmin.
Ive also tried to delete and recreate the administrator user from PGAdmin
but I still cant use pg_dump.
Tried all the passwords my colleagues can think of. Ive 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