Problem generating database using pgAdmin III - PostgreSQL version is 9.1

From: "Hager, Paul CIV NAVSEA Crane, NAVSEA" <paul(dot)hager(at)navy(dot)mil>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Problem generating database using pgAdmin III - PostgreSQL version is 9.1
Date: 2013-08-29 16:37:28
Message-ID: 80BEA9C0F981324E996C49694D18E3500CF12078@naeacranez03v.nadsusea.nads.navy.mil
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

This is going to be complicated so I'll try to be as succinct as possible.

I am trying to port two PostgreSQL databases from a Linux system to Windows. After I do that, I will use a tool to convert the two databases to Access. I know this can be done - another person already did it. The problem is that it will be necessary to periodically repeat this process to keep the Access databases up to date. The person who did the original transfer is on extended medical leave and no one here has a clue how to do it. To describe the directions/recipe to accomplish this process as "sketchy" is a gross understatement.

Here's where I am at this point. I dumped the schema and insert table files on Linux and ported them to Windows. I edited them per the instructions. I'm now ready to use the two files to create the first database. In the pgAdmin tool, the database name exists - it has what appears to be some placeholder information. The directions say, and I quote:
"Select the [database name], then select SQ and open file." [there is no "SQ"] I think that is a typo and refers to the SQL icon on the toolbar which is mentioned later in the directions. I ended up choosing that. To continue...
"Select the xsYYYYMMDD file (s is for schema and x is for [either of the two databases]). Run the program but make sure you select the run pgsql file option or it will just execute 1 command at a time. This will load your schema files (make the tables). Check the database schema tables to make sure the tables have loaded."

Here is how I proceeded. When I selected the SQL icon a window appeared. I decided to try to load the schema. That appeared to work in that the SQL commands appeared in the window. There was no "run pqsql" command anywhere. I went to the drop-down and selected something like run pg script - I think the keystroke was F7 (I'm away from the lab, which has no network access). There was a log window that seemed to show all of the commands in the file being executed. I got a message that everything was complete. Then I repeated the same process with xALLYYYMMDD, which is all of the table inserts. Got a similar completion message.

Here's the problem. I don't think anything happened. I'm not sure how to proceed at this point. If I'm able to verify that the database is actually populated, what steps do I follow to save to disk?

My experience with databases is strictly limited to running a few queries. If I can get the PostgreSQL databases converted to Access, they will be used as inputs to a C++ program I developed. My only interest in this has been the program - the database was, until recently, someone else's responsibility. It is imperative that the directions, which I am rewriting so that they are comprehensible, can be used by someone like me - that is, someone with essentially NO database knowledge whatsoever.

Thanks in advance.

Paul Hager

Computer Scientist
Crane Division, Naval Surface Warfare Center (NSWC Crane)
Harnessing the Power of Technology for the Warfighter
Code WXMP, Bldg 3330W
300 Highway 361
Crane, IN 47522-5001
Ph: 812-854-1985
DSN: 482-1985
Fax: 812-854-1109
Email: paul(dot)hager(at)navy(dot)mil
SIPR: paul(dot)hager(at)navy(dot)smil(dot)mil
http://www.navsea.navy.mil/nswc/crane/Lists/customerfeedback/NewForm.aspx

Browse pgadmin-support by date

  From Date Subject
Next Message Dinesh Kumar 2013-08-29 17:07:57 Re: Password setting having somewhat bizarre results.
Previous Message Dave Page 2013-08-29 15:32:25 Re: Password setting having somewhat bizarre results.