On Mon, Sep 9, 2013 at 6:16 PM, Hager, Paul CIV NAVSEA Crane, NAVSEA
<paul.hager@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
anda large data file, which is what I expected. They are located c:documents and settings\phager\my documents or
somethingsimilar.
>
> 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
toc:\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