[pgadmin-support]
unsubscribe ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[pgadmin-support] migration problem
I know this is not strictly a pgadmin issue, but I don't know where else to turn. At worst, perhaps someone can steer me in the right direction. :)) Dave seems terribly knowlegable on pgsql, so I thought I'd risk the question: I am trying to restore a database from a gzipped file: I believe that backups were done as complete files (not partial) under Postgresql 7.0.3. Pg_restore does not recognize the ungzipped file "filename.psql". The command, psql -d database -f filename.psql, restores it partially, but with numerous errors and the database is mostly empty. As I understand, this command restores the file to an existing database, so I had to create one with the original filename. But I don't know if the newly created database must have the exact same permissions, ownership, etc. as the original. I am told to install the earlier version of Postgresql to restore, but that does not work - cannot configure it. Even if that works, how can the restored database be migrated to a newer version of Postgresql? Does anybody out there know about this kind of thing? Thanks for any help. P. Jourdan ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[pgadmin-support] Migration from Oracle
Hello, I can't make the migration wizard work. I'm trying to migrate an Oracle database from a network server, to Postgres. I installed the Oracle client on my Windows client box, and can connect successfully to the Oracle server. I created a system odbc data source on my box, a system DSN, using the Oracle ODBC driver. When I try to migrate with the pgadmin wizard, I am able to connect to the Oracle database as an ODBC source. I select to migrate all tables and all data. Then I get this warning: 'foreign keys are not supported with this provider. When the migration starts ( "Creating table CUSTOMER" ), it fails right away, with this error message: -2147217887: ODBC driver does not support the requested properties. What should I do? Please help me, I'm almost there! :) Miguel Juteau Yellowasp ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-support] migration problem
> -Original Message- > From: PJourdan [mailto:[EMAIL PROTECTED]] > Sent: 11 April 2002 17:24 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] migration problem > > > I know this is not strictly a pgadmin issue, but I don't know > where else to > turn. > At worst, perhaps someone can steer me in the right > direction. :)) Dave seems terribly knowlegable on pgsql, so I > thought I'd risk the question: Thanks for the vote of confidence, but this is not really within my field of knowledge. I've CC'd this to [EMAIL PROTECTED] - you are more likely to get good help from there. Regards, Dave. > I am trying to restore a > database from a gzipped file: I believe that > backups were done as complete files (not partial) under > Postgresql 7.0.3. > Pg_restore does not recognize the ungzipped file "filename.psql". The > command, psql -d database -f filename.psql, restores it > partially, but with > numerous errors and the database is mostly empty. As I > understand, this > command restores the file to an existing database, so I had > to create one > with the original filename. But I don't know if the newly > created database > must have the exact same permissions, ownership, etc. as the > original. I am told to install the earlier version of > Postgresql to restore, but that > does not work - cannot configure it. Even if that works, how can the > restored database be migrated to a newer version of > Postgresql? Does anybody out there know about this kind of > thing? Thanks for any help. P. Jourdan > > > ---(end of > broadcast)--- > TIP 1: subscribe and unsubscribe commands go to > [EMAIL PROTECTED] > ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
