Re: [GENERAL] Transfer db from one port to another

2015-12-30 Thread Adrian Klaver
On 12/29/2015 11:38 PM, Killian Driscoll wrote: On 24 December 2015 at 18:33, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: It worked - thank you very much for your time. Regarding the file format used: I had used the pg_dump with .sql, but you suggested .out. Is there a particul

Re: [GENERAL] Transfer db from one port to another

2015-12-30 Thread Andreas Kretschmer
Killian Driscoll wrote: > It worked - thank you very much for your time. Great! > Regarding the file format used: I had used the pg_dump with .sql, but you > suggested .out. Is there a particular reason to use .out instead of .sql when > backing up? No, doesn't matter. Andreas -- Really,

Re: [GENERAL] Transfer db from one port to another

2015-12-29 Thread Killian Driscoll
On 24 December 2015 at 18:33, Adrian Klaver wrote: > On 12/24/2015 12:03 AM, Killian Driscoll wrote: > > >> >> yeah, this one from Adrian, at 7:02am PST (Z-0800) this >> morning >> >> Per previous posts you want, whenever possible, to us a >> newer version >>

Re: [GENERAL] Transfer db from one port to another

2015-12-24 Thread Adrian Klaver
On 12/24/2015 12:03 AM, Killian Driscoll wrote: yeah, this one from Adrian, at 7:02am PST (Z-0800) this morning Per previous posts you want, whenever possible, to us a newer version of pg_dump to move a database from an older version(9.3) to

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Tom Lane
John R Pierce writes: >> FYI, you can go here: >> http://www.postgresql.org/mailpref/pgsql-general >> and set eliminatecc to have the listserver do that for you. > except, its the one from the list that I want to keep in my archive. > my filter isn't sophisticated enough to separate them (I'm

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread John R Pierce
On 12/23/2015 12:37 PM, Adrian Klaver wrote: p.s. please don't CC me answers, I get every email sent to the list, with the CC's I end up getting two of every one.\ FYI, you can go here: http://www.postgresql.org/mailpref/pgsql-general and set eliminatecc to have the listserver do that for y

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Adrian Klaver
On 12/23/2015 12:12 PM, John R Pierce wrote: I was half awake early this AM and perused my email, and noted a fubar in one of the command sets shown to you but too sleepy to try and reply at the time, and now this thread is WAY too silly long to find it again, but I think someone neglected to put

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Melvin Davidson
> *ERROR: syntax error at or near "1" at character 1* *That indicates a problem restoring data, but since it's probably from a previous restore attempt, and there is no time stamp, you might be able to ignore it.* *Do you have PgAdmin installed so you can look at the current contents of the res

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread John R Pierce
I was half awake early this AM and perused my email, and noted a fubar in one of the command sets shown to you but too sleepy to try and reply at the time, and now this thread is WAY too silly long to find it again, but I think someone neglected to put the database name on a pg_restore command.

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Killian Driscoll
On 23 December 2015 at 21:06, Killian Driscoll wrote: > On 23 December 2015 at 20:59, Melvin Davidson > wrote: > >> >OK - I see the logs there - the last log was almost 12 hrs ago, so no >> recent one. >> >> That's not very helpful. Depending on how you've configured the logging, >> PostgreSQL m

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Killian Driscoll
On 23 December 2015 at 20:59, Melvin Davidson wrote: > >OK - I see the logs there - the last log was almost 12 hrs ago, so no > recent one. > > That's not very helpful. Depending on how you've configured the logging, > PostgreSQL may only create one log file a day. > I didn't change a configurati

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Melvin Davidson
>OK - I see the logs there - the last log was almost 12 hrs ago, so no recent one. That's not very helpful. Depending on how you've configured the logging, PostgreSQL may only create one log file a day. Conventional thinking is It's what is IN the log file that is important. On Wed, Dec 23, 2015

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Killian Driscoll
On 23 December 2015 at 20:38, Melvin Davidson wrote: > You can rREDIRECT the output to a file! EG: psql -U postgres -p 5532 > > your_output.txt > then use notepad to see the result. > > But from your last reply, it looks like Postgres is finishing the restore > by VACUUMing the database. That me

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Melvin Davidson
You can rREDIRECT the output to a file! EG: psql -U postgres -p 5532 > your_output.txt then use notepad to see the result. But from your last reply, it looks like Postgres is finishing the restore by VACUUMing the database. That means it has to vacuum every table. Since you never told us the info

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Adrian Klaver
On 12/23/2015 11:27 AM, Killian Driscoll wrote: On 23 December 2015 at 20:24, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 12/23/2015 11:17 AM, Killian Driscoll wrote: On 23 December 2015 at 20:14, Adrian Klaver mailto:adrian.kla...@aklaver.com>

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Killian Driscoll
On 23 December 2015 at 20:26, Melvin Davidson wrote: > Do not stop the active restore. > Just run psql from the command shell in the Bitnami binary directory and > use -U postgres and -p 5532 flags. > > > On Wed, Dec 23, 2015 at 2:22 PM, Killian Driscoll < > killiandrisc...@gmail.com> wrote: > >>

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Killian Driscoll
On 23 December 2015 at 20:24, Adrian Klaver wrote: > On 12/23/2015 11:17 AM, Killian Driscoll wrote: > >> On 23 December 2015 at 20:14, Adrian Klaver > > wrote: >> > > > >> >> So how are you determining it is running and that it is not doing >> anything?

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Melvin Davidson
Do not stop the active restore. Just run psql from the command shell in the Bitnami binary directory and use -U postgres and -p 5532 flags. On Wed, Dec 23, 2015 at 2:22 PM, Killian Driscoll wrote: > On 23 December 2015 at 20:19, Melvin Davidson > wrote: > >> It's possible the restore is still

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Adrian Klaver
On 12/23/2015 11:17 AM, Killian Driscoll wrote: On 23 December 2015 at 20:14, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: So how are you determining it is running and that it is not doing anything? Since I ran the restore the windows shell has been 'active' with codes l

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Killian Driscoll
On 23 December 2015 at 20:19, Melvin Davidson wrote: > It's possible the restore is still building indexes. > > What does it show when you run this query? > Where do I run this query? Do I stop the restore that is 'active'? > > SELECT datname, >pid as pid, >client_addr, >

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Melvin Davidson
It's possible the restore is still building indexes. What does it show when you run this query? SELECT datname, pid as pid, client_addr, usename as user, query, CASE WHEN waiting = TRUE THEN 'BLOCKED' ELSE 'no' END as waiting,

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Killian Driscoll
On 23 December 2015 at 20:14, Adrian Klaver wrote: > On 12/23/2015 11:09 AM, Killian Driscoll wrote: > >> On 23 December 2015 at 20:07, Adrian Klaver > > wrote: >> >> On 12/23/2015 11:03 AM, Killian Driscoll wrote: >> >> On 23 December 2015 at 16:02,

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Adrian Klaver
On 12/23/2015 11:09 AM, Killian Driscoll wrote: On 23 December 2015 at 20:07, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 12/23/2015 11:03 AM, Killian Driscoll wrote: On 23 December 2015 at 16:02, Adrian Klaver mailto:adrian.kla...@aklaver.com>

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Killian Driscoll
On 23 December 2015 at 20:07, Adrian Klaver wrote: > On 12/23/2015 11:03 AM, Killian Driscoll wrote: > >> On 23 December 2015 at 16:02, Adrian Klaver > > wrote: >> >> On 12/23/2015 06:50 AM, Killian Driscoll wrote: >> >> On 23 December 2015 at 15:47,

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Adrian Klaver
On 12/23/2015 11:03 AM, Killian Driscoll wrote: On 23 December 2015 at 16:02, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 12/23/2015 06:50 AM, Killian Driscoll wrote: On 23 December 2015 at 15:47, Adrian Klaver mailto:adrian.kla...@aklaver.com>

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Killian Driscoll
On 23 December 2015 at 16:02, Adrian Klaver wrote: > On 12/23/2015 06:50 AM, Killian Driscoll wrote: > >> On 23 December 2015 at 15:47, Adrian Klaver > > > >> So cd into: >> >> C:\Program Files\PostgreSQL\9.3\bin >> >> and try: >> >> pg_dump --h

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Adrian Klaver
On 12/23/2015 06:50 AM, Killian Driscoll wrote: On 23 December 2015 at 15:47, Adrian Klaver So cd into: C:\Program Files\PostgreSQL\9.3\bin and try: pg_dump --help that will at least establish that the command is being found

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Killian Driscoll
On 23 December 2015 at 15:47, Adrian Klaver wrote: > On 12/23/2015 06:35 AM, Killian Driscoll wrote: > >> On 23 December 2015 at 15:30, Adrian Klaver > > wrote: >> >> On 12/23/2015 06:13 AM, Killian Driscoll wrote: >> >> On 23 December 2015 at 14:56,

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Adrian Klaver
On 12/23/2015 06:35 AM, Killian Driscoll wrote: On 23 December 2015 at 15:30, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 12/23/2015 06:13 AM, Killian Driscoll wrote: On 23 December 2015 at 14:56, Adrian Klaver mailto:adrian.kla...@aklaver.com>

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Killian Driscoll
On 23 December 2015 at 15:30, Adrian Klaver wrote: > On 12/23/2015 06:13 AM, Killian Driscoll wrote: > >> On 23 December 2015 at 14:56, Adrian Klaver > > wrote: >> >> On 12/23/2015 03:43 AM, Killian Driscoll wrote: >> >> On 23 December 2015 at 11:36,

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Adrian Klaver
On 12/23/2015 06:13 AM, Killian Driscoll wrote: On 23 December 2015 at 14:56, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 12/23/2015 03:43 AM, Killian Driscoll wrote: On 23 December 2015 at 11:36, John R Pierce mailto:pie...@hogranch.com>

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Charles Clavadetscher
Klaver Cc: John R Pierce ; pgsql-general Subject: Re: [GENERAL] Transfer db from one port to another On 23 December 2015 at 14:56, Adrian Klaver mailto:adrian.kla...@aklaver.com> > wrote: On 12/23/2015 03:43 AM, Killian Driscoll wrote: On 23 December 2015 at 11:36, John R Pierce mail

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Alban Hertroys
> On 23 Dec 2015, at 12:43, Killian Driscoll wrote: > > OK - I did the dir and it shows that the dump and restore.exe are there, but > running the above gives the below errors > > 09/06/2014 08:35 381,952 pg_dump.exe > > 09/06/2014 08:35 180,224 pg_restore.exe > > C:\Us

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Killian Driscoll
On 23 December 2015 at 14:56, Adrian Klaver wrote: > On 12/23/2015 03:43 AM, Killian Driscoll wrote: > >> On 23 December 2015 at 11:36, John R Pierce > > wrote: >> >> On 12/23/2015 2:25 AM, Killian Driscoll wrote: >> >>> Sorry, forgot to add: once I get the war

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Adrian Klaver
On 12/23/2015 03:43 AM, Killian Driscoll wrote: On 23 December 2015 at 11:36, John R Pierce mailto:pie...@hogranch.com>> wrote: On 12/23/2015 2:25 AM, Killian Driscoll wrote: Sorry, forgot to add: once I get the warning that the Pg_dump can't be found there is then a password prompt

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Killian Driscoll
On 23 December 2015 at 11:36, John R Pierce wrote: > On 12/23/2015 2:25 AM, Killian Driscoll wrote: > > Sorry, forgot to add: once I get the warning that the Pg_dump can't be > found there is then a password prompt; I tried the db password and the pc > password but both fail: > > Password: > pg_d

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread John R Pierce
On 12/23/2015 2:25 AM, Killian Driscoll wrote: Sorry, forgot to add: once I get the warning that the Pg_dump can't be found there is then a password prompt; I tried the db password and the pc password but both fail: Password: pg_dump: [archiver (db)] connection to database "irll_project" faile

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Charles Clavadetscher
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Killian Driscoll Sent: Mittwoch, 23. Dezember 2015 11:26 To: John R Pierce Cc: pgsql-general Subject: Re: [GENERAL] Transfer db from one port to another On 23 December 2015 at 11:19, Killian

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread John R Pierce
On 12/23/2015 2:19 AM, Killian Driscoll wrote: (or, click on an 'Command Prompt' shortcut). C:\Users\YourName>***path "c:\Program Files\PostgreSQL\9.4\bin";%path%* C:\Users\YourName>*pg_dump -Fc -p 5432 *//*| pg_restore -p 5532* Thanks. When I do this I get an error

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Killian Driscoll
On 23 December 2015 at 11:19, Killian Driscoll wrote: > On 23 December 2015 at 11:07, John R Pierce wrote: > >> On 12/23/2015 1:40 AM, Killian Driscoll wrote: >> >> Try it with plain pg_dump. >>> >>> pg_dump -h localhost -p 5432 -Fc > dump.sql >>> >>> pg_restore -h localhost -p 5532 dump.sql >>

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Charles Clavadetscher
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Killian Driscoll Sent: Mittwoch, 23. Dezember 2015 11:19 To: John R Pierce Cc: pgsql-general Subject: Re: [GENERAL] Transfer db from one port to another On 23 December 2015 at 11:07, John R

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Killian Driscoll
On 23 December 2015 at 11:07, John R Pierce wrote: > On 12/23/2015 1:40 AM, Killian Driscoll wrote: > > Try it with plain pg_dump. >> >> pg_dump -h localhost -p 5432 -Fc > dump.sql >> >> pg_restore -h localhost -p 5532 dump.sql >> > > I tried this, but nothing appears to happen when entering the

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread John R Pierce
On 12/23/2015 1:40 AM, Killian Driscoll wrote: Try it with plain pg_dump. pg_dump -h localhost -p 5432 -Fc > dump.sql pg_restore -h localhost -p 5532 dump.sql I tried this, but nothing appears to happen when entering the commands. Attached is a screenshot of the shell window -

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Charles Clavadetscher
From: Killian Driscoll [mailto:killiandrisc...@gmail.com] Sent: Mittwoch, 23. Dezember 2015 11:02 To: Charles Clavadetscher Cc: Andreas Kretschmer ; pgsql-general Subject: Re: [GENERAL] Transfer db from one port to another On 23 December 2015 at 10:58, Charles Clavadetscher

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Killian Driscoll
On 23 December 2015 at 10:58, Charles Clavadetscher < clavadetsc...@swisspug.org> wrote: > Hello Killian > > >> 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 t

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Charles Clavadetscher
Hello Killian >> 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 > >Try it with plain pg_dump. > >pg_dump

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Killian Driscoll
On 23 December 2015 at 10:29, Andreas Kretschmer wrote: > Killian Driscoll wrote: > > > 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. > > > >

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Andreas Kretschmer
Charles Clavadetscher wrote: > Hello > > > > Why don’t you simply change the port in postgresql.conf and restart the > server? i think, he wants the data from the one database within the other, because of that he can't change the port. Andreas -- Really, I'm not out to destroy Microsoft.

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Andreas Kretschmer
Killian Driscoll wrote: > 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 t

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Killian Driscoll
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-gener

Re: [GENERAL] Transfer db from one port to another

2015-12-23 Thread Charles Clavadetscher
: [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

[GENERAL] Transfer db from one port to another

2015-12-23 Thread Killian Driscoll
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 ha