Re: transfer database from Linux to Windows - Mailing list pgsql-novice
| From | Oleg |
|---|---|
| Subject | Re: transfer database from Linux to Windows |
| Date | |
| Msg-id | 43A96F9A.5030904@iwk.uka.de Whole thread Raw |
| In response to | transfer database from Linux to Windows (Oleg <evdakov@iwk.uka.de>) |
| List | pgsql-novice |
Jaime I was trying to redirect errors from the screen to log file I tried: psql -d mydb -U postgres -f dumpfile.sql > output.txt This gives only successful commands see attached psql_output.txt psql -d mydb -U postgres -f dumpfile.sql > output.txt 2>&1 Does not allow me to enter password What should I do? Thanks a lot in advance Oleg Jaime Casanova schrieb: >On 12/20/05, Jaime Casanova <systemguards@gmail.com> wrote: > > >>On 12/20/05, Oleg <evdakov@iwk.uka.de> wrote: >> >> >>>Tom, Jaime >>>Thank you very much for your help. >>>It works like this: >>>1. Under Linux: pg_dump fgm_gis_2 > fgm_gis_2_dump >>>2. Under Windows: >>> a) Create database >>> b) check whether plpgsql is enabled. if not then: createlang plpgsql fgm_gis_02 >>> c) psql -f (lw)postgis.sql -d fgm_gis_02 >>> d) psql -f fgm_gis_2_dump -d fgm_gis_02 -U postgres >>> >>>I am getting lots of Errors like >>>Duplicating primary key is no allowed >>>etc. >>>Can I ignore them? >>>Best regards >>>Oleg >>> >>> >>> >>Can you us the exact errors, please? >> >> >> > >Can you show us the exact errors, please? > >PS: i couldn't stop the buggy message :( > > > >>-- >>regards, >>Jaime Casanova >>(DBA: DataBase Aniquilator ;) >> >> >> > > >-- >Atentamente, >Jaime Casanova >(DBA: DataBase Aniquilator ;) > > > SET SET SET SET SET REVOKE REVOKE GRANT CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE SET SET SET CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE VIEW SET CREATE VIEW CREATE TABLE CREATE TABLE CREATE VIEW CREATE VIEW CREATE VIEW CREATE TABLE CREATE TABLE CREATE TABLE CREATE VIEW CREATE VIEW CREATE VIEW CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE CREATE VIEW CREATE VIEW CREATE VIEW ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE CREATE RULE SET COMMENT COMMENT COMMENT COMMENT COMMENT COMMENT COMMENT COMMENT COMMENT COMMENT
pgsql-novice by date: