On Mon, Sep 9, 2013 at 6:16 PM, Hager, Paul CIV NAVSEA Crane, NAVSEA <paul.ha...@navy.mil> wrote: > I was only able to get to this today. > > I created the two files - schema and data per your suggestion below. Ended > up with a relatively small schema file and a large data file, which is what I > expected. They are located c:documents and settings\phager\my documents or > something similar. > > Then I hit a snag. I assume on Windows XP I'm supposed to go to the command > line. "psql" is not recognized. I went to c:\program files\9.1\bin\ and > found psql.exe. I set my directory in "My Documents" and then did the > following: > > "c:\program files\9.1\bin\psql" -h localhost development-pgs < dsYYYYMMDD > > That generated the following error: FATAL: role "phager" does not exist > > I haven't a clue what the problem is. What's a "role" and why is it treating > part of the pathname as a "role"?
A role is both a user account and a user group in the database server. It'll be defaulting to your operating system username. Try using: "c:\program files\9.1\bin\psql" -h localhost -U postgres development-pgs < dsYYYYMMDD To tell it to use the postgres role (the default superuser). If that's not the correct role, then you'll have to find out what is from your end as that's specific to your installation and the way it's been setup. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
