Re: Second message: "Problem generating database using pgAdmin III - PostgreSQL version is 9.1"

Hi Paul.

Your question is undoubtedly beyond the scope of this forum, which would explain the mute response.

I can't say for certain I know what you are trying to accomplish but I think I have a pretty good idea.

I would be happy to try and assist you but I recommend that we take our conversation off-line. Please respond to me only (Don't reply to all)

Thanks,

Chris

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org [mailto:pgadmin-support-
> owner(at)postgresql(dot)org] On Behalf Of Hager, Paul CIV NAVSEA Crane, NAVSEA
> Sent: Tuesday, September 03, 2013 11:15 AM
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Second message: "Problem generating database
> using pgAdmin III - PostgreSQL version is 9.1"
>
> 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.as
> px
>