Skip site navigation (1)
Skip section navigation (2)
Achilleas informed You very good. But if Your SQL file comes from other DBMS, like MySQL, You have to a little bit to edit this file, becouse sometimes in those files are used "slangs" characteristical for specific DBMS. If You have SQL file genarated with "pg_dump", You have to be sure, that all needed roles (users, groups) are defined in Your destination database, when in SQL file You have GRANT or REVOKE.
Peripheral Links
Header And Logo
|
Site Navigation
Re: postgres import
- From: Adam Radlowski <adamr(at)informatyka(dot)gdansk(dot)pl>
- To: Antonios Katsikadamos <antonioskatsikadamos(at)yahoo(dot)com>
- Cc: pgsql-admin(at)postgresql(dot)org
- Subject: Re: postgres import
- Date: Tue, 31 Oct 2006 11:49:50 +0100
Achilleas informed You very good. But if Your SQL file comes from other DBMS, like MySQL, You have to a little bit to edit this file, becouse sometimes in those files are used "slangs" characteristical for specific DBMS. If You have SQL file genarated with "pg_dump", You have to be sure, that all needed roles (users, groups) are defined in Your destination database, when in SQL file You have GRANT or REVOKE.
Greetings Adam Antonios Katsikadamos wrote:
Hi all,sorry again for the trouble. I have a small problem in postgres, I have a .sql file ( db dump ) and i want to import it in postgres on linux. does anyone know how to do it? Thnx a lot for your timeGet your email and more, right on the new Yahoo.com <http://us.rd.yahoo.com/evt=42973/*http://www.yahoo.com/preview>
- References:
- postgres import
- From: Antonios Katsikadamos
- postgres import
- Prev by Date: Re: 100% failover + replication solution
- Next by Date: Re: [FIXED] Re: can not restart posgresql after dist-upgrade - debian
- Previous by thread: Re: postgres import
- Next by thread: Uninstalling on Mac OS X 10.4
- Indexes: