Re: transfer database from Linux to Windows

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