Second message: "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: Second message: "Problem generating database using pgAdmin III - PostgreSQL version is 9.1"
Date: 2013-09-03 18:14:51
Message-ID: 80BEA9C0F981324E996C49694D18E3500CF12BD6@naeacranez03v.nadsusea.nads.navy.mil
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

I sent message with this title once and got nothing indicating it was received. I have, however, gotten exchanges dealing with other rather arcane problems. At a minimum, could I get some acknowledgment that my message has been received?

I'll provide a brief recap:
I'm trying to port two PostgreSQL databases to Windows XP. Once I do that, I will run those through a tool in the Windows machine that will convert them to Access. Someone else managed this but is on extended medical leave, leaving sketchy directions behind that no one here has been able to decipher. Note: none of this is part of my job description - I'm filling in because no one else seems to know anything about how to do this. I'll focus on only ONE database, since the process is the same for both.

In brief. Do
pg_dump -s dfile-pgs -f dsYYYYMMDD
pg_dump -s dfile-pgs -f dALLYYYYMMDD

The above worked (for me) Take these files and move to Windows XP. That's now done.
Now edit the files as follows: comment out "\connect" and all of the "GRANT INSERT" commands. Save the result as *.sql
Edit all the files containing tables and data. Remove the "CREATE TABLE" commands so just the "INSERT" commands are left. Save again. (NOTE: this applied to both files - both had "create table" commands.)

I did all of the above, apparently successfully.

This is just a recipe - none of it makes sense to me. However, these steps were followed by the person now on extended medical leave to provide input to the pgAdmin program. The next set of instructions involve pgAdmin:

Select SQL from the toolbar and open file, selecting the "s" file (supposedly the schema file). This is supposed to make the tables. I don't know how this can happen if all of the "CREATE TABLES" have been edited out, but that's what the directions say. Supposedly one is to run "pgsql" file option. It doesn't exist anywhere. There is an option to run a macro, which I selected and it seemed to run. However, nothing was created. There was nothing I could see anywhere and nothing to save. The next step is to load the files that have the "insert" commands in them. I assume this would be the ALL files.

I never saw any "insert table" commands. There were other insert commands but it wasn't clear what they did, and the files seemed awfully small to produce the databases. Needless to say, none of this worked for me.

Here's all I want. I want to move some hypothetical PostgreSQL database on Linux to Windows. Surely someone on this list has had to do that. I don't work with databases - I just need a simple cookbook/recipe. Once I have a procedure, I'll be turning it over to other people.

Help please.

Thanks,

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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Chris Campbell 2013-09-03 19:51:34 Re: Second message: "Problem generating database using pgAdmin III - PostgreSQL version is 9.1"
Previous Message arthur.tomica 2013-09-02 08:55:39 PgAdmin Guru Hints on Windows blank