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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq