On 23 December 2015 at 10:05, Charles Clavadetscher < clavadetsc...@swisspug.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-ow...@postgresql.org [mailto: > pgsql-general-ow...@postgresql.org] *On Behalf Of *Killian Driscoll > *Sent:* Mittwoch, 23. Dezember 2015 09:58 > *To:* pgsql-general <pgsql-general@postgresql.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 >