From: | "Charles Clavadetscher" <clavadetscher(at)swisspug(dot)org> |
---|---|
To: | "'Killian Driscoll'" <killiandriscoll(at)gmail(dot)com>, "'pgsql-general'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Transfer db from one port to another |
Date: | 2015-12-23 09:05:58 |
Message-ID: | 01de01d13d61$295121c0$7bf36540$@swisspug.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello
Why don’t you simply change the port in postgresql.conf and restart the server?
Bye
Charles
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Killian Driscoll
Sent: Mittwoch, 23. Dezember 2015 09:58
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: [GENERAL] Transfer db from one port to another
I am using Windows 8 64 bit, with postgreSQL 9.3 on port 5432 and postgreSQL 9.4 on port 5532 with the latter set up to use with Bitnami stack to test php files I am generating from my db.
I want to transfer my db with three schemas from port 5432 to port 5532 to use within the bitnami stack. I have used pgAdmin to create a backup.sql and when using pgAdmin to restore the .sql to port 5532 I get the following error
ERROR: syntax error at or near "\"
LINE 26: \connect irll_project
with the lines in the .sql file created being
ALTER DATABASE irll_project OWNER TO postgres;
\connect irll_project
I have tried to use the Windows psql shell command to import using
\i 'C:/all.sql'
on pressing enter I see multiple occurrences saying invalid command, and then it ends with
error: out of memory detail: failed on request of size 268435456
What is the correct command line?
Killian DriscoIl
From | Date | Subject | |
---|---|---|---|
Next Message | Killian Driscoll | 2015-12-23 09:12:40 | Re: Transfer db from one port to another |
Previous Message | Killian Driscoll | 2015-12-23 08:57:48 | Transfer db from one port to another |