Re: Second message: "Problem generating database using pgAdmin III - PostgreSQL version is 9.1"
От | Chris Campbell |
---|---|
Тема | Re: Second message: "Problem generating database using pgAdmin III - PostgreSQL version is 9.1" |
Дата | |
Msg-id | 453A24085F801842AEA8D0B6B269065D03B5A10D0C1A@HDMC.cds.local обсуждение исходный текст |
Ответ на | Second message: "Problem generating database using pgAdmin III - PostgreSQL version is 9.1" ("Hager, Paul CIV NAVSEA Crane, NAVSEA" <paul.hager@navy.mil>) |
Список | 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 >
В списке pgadmin-support по дате отправления:
Предыдущее
От: "Hager, Paul CIV NAVSEA Crane, NAVSEA"Дата:
Сообщение: Second message: "Problem generating database using pgAdmin III - PostgreSQL version is 9.1"
Следующее
От: Dave PageДата:
Сообщение: Re: Second message: "Problem generating database using pgAdmin III - PostgreSQL version is 9.1"