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

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@postgresql.org [mailto:pgadmin-support-
> owner@postgresql.org] On Behalf Of Hager, Paul CIV NAVSEA Crane, NAVSEA
> Sent: Tuesday, September 03, 2013 11:15 AM
> To: pgadmin-support@postgresql.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.hager@navy.mil
> SIPR:  paul.hager@navy.smil.mil
> http://www.navsea.navy.mil/nswc/crane/Lists/customerfeedback/NewForm.as
> px
>