Re: Transfer db from one port to another

On 23 December 2015 at 10:05, Charles Clavadetscher <
clavadetscher(at)swisspug(dot)org> wrote:

> Hello
>
>
>
> Why don’t you simply change the port in postgresql.conf and restart the
> server?
>
I am attempting to learn to use the dump and restore, so would like to
figure out how to do it via an export and import.

>
>
> 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
>