Transfer db from one port to another

From: Killian Driscoll <killiandriscoll(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Transfer db from one port to another
Date: 2015-12-23 08:57:48
Message-ID: CAL64pZOziUGzc2q2j8VnU=fAt9TXjSR=guD2JkN7fwPFwr++Gw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
<http://ca.linkedin.com/in/killiandriscoll>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Charles Clavadetscher 2015-12-23 09:05:58 Re: Transfer db from one port to another
Previous Message George Neuner 2015-12-23 08:13:06 Re: Shared system resources