Re: [GENERAL] Need Database Backup

2015-08-30 Thread Scott Marlowe
OK we're gonna need to keep this on the list, as other folks may be a much better choice to help you than me (I'm not a Windows guy.) OK so we need more info to help. I don't know how to fix the NTLDR problem, etc, because it's windows. However, the folks who might be able to help need more info.

Re: [GENERAL] Need Database Backup

2015-08-30 Thread Charles Clavadetscher
Hi I agree with all upthreads mentioning that the amount of information you (Murali) deliver is much too little to help. Nevertheless my thoughts. - NTLDR Missing is obviously a Windows problem and I don't think that it has to do with PostgreSQL. You may find better help on a Windows forum or m

Re: [GENERAL] Need Database Backup

2015-08-30 Thread Adrian Klaver
On 08/30/2015 06:36 AM, Scott Marlowe wrote: OK we're gonna need to keep this on the list, as other folks may be a much better choice to help you than me (I'm not a Windows guy.) OK so we need more info to help. I don't know how to fix the NTLDR problem, etc, because it's windows. However, the f

Re: [GENERAL] Need Database Backup

2015-08-30 Thread Melvin Davidson
You need to recreate the database to reload the data into so from the windows command line: C:\PostgresDB\bin\createdb.exe -U postgres ; Then to restore the data from the sql backup C:\PostgresDB\bin\pg_restore.exe -U postgres On Sun, Aug 30, 2015 at 10:06 AM, Adrian Klaver wrote:

Re: [GENERAL] Need Database Backup

2015-08-30 Thread Adrian Klaver
On 08/30/2015 07:13 AM, Melvin Davidson wrote: You need to recreate the database to reload the data into so from the windows command line: C:\PostgresDB\bin\createdb.exe -U postgres ; That assumes Postgres is running, which at this point seems not to be the case or at least is unprove

Re: [GENERAL] Need Database Backup

2015-08-30 Thread Melvin Davidson
Adrian >From Murali N Rao 5:43 AM (4 hours ago) >now i have installed new os and installed PGSQL again it working now but no data On Sun, Aug 30, 2015 at 10:21 AM, Adrian Klaver wrote: > On 08/30/2015 07:13 AM, Melvin Davidson wrote: > >> You need to recreate the database to reload the data in

Re: [GENERAL] Need Database Backup

2015-08-30 Thread Charles Clavadetscher
Well the rest should be easy. psql -U ... -h ... -p ... -d ... -f sql_file.sql http://www.postgresql.org/docs/9.4/static/app-psql.html option "f" From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Melvin Davidson Sent: Sonntag, 30. August 2015 16:2

Re: [GENERAL] Need Database Backup

2015-08-30 Thread Adrian Klaver
On 08/30/2015 07:27 AM, Melvin Davidson wrote: Adrian From Murali N Rao 5:43 AM (4 hours ago) >now i have installed new os and installed PGSQL again it working now but no data Aaah, missed that, so Postgres is running, thanks. -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql

Re: [GENERAL] Need Database Backup

2015-08-30 Thread Adrian Klaver
On 08/30/2015 07:27 AM, Melvin Davidson wrote: Adrian From Murali N Rao 5:43 AM (4 hours ago) >now i have installed new os and installed PGSQL again it working now but no data I plead lack of coffee, but where is that message and was there more in it? On Sun, Aug 30, 2015 at 10:21 AM, Ad

Re: [GENERAL] Need Database Backup

2015-08-30 Thread Melvin Davidson
Good catch Adrian, Murali, Please change the restore command to C:\PostgresDB\bin\psql.exe -U postgres -d -f On Sun, Aug 30, 2015 at 10:40 AM, Adrian Klaver wrote: > On 08/30/2015 07:27 AM, Melvin Davidson wrote: > >> Adrian >> From Murali N Rao 5:43 AM (4 hours ago) >> >> >now i have ins

Re: [GENERAL] wal files stay in the pg_xlog dir

2015-08-30 Thread kingl
Hi Adrian Thank you for your explanation, I did read the wal document that you mentioned and every settings look ok. I will keep an eye on the situation and I really appreciate your help. -- View this message in context: http://postgresql.nabble.com/wal-files-stay-in-the-pg-xlog-dir-tp586378

Re: [GENERAL] AIX 7.1 compile and initdb startup error TRAP: FailedAssertion

2015-08-30 Thread Martín Marqués
Hi, I suggest you file a bug report: http://www.postgresql.org/support/submitbug/ Regards, El 23/08/15 a las 15:32, Pande, Nitin escribió: > Hello, > I am trying to compile and run PostgreSQL 9.4.0 on AIX 7.1. I was able to > compile with following settings: > CC="xlc_r -q64 -qnoansialias" >

Re: [GENERAL] master/master replication with load balancer in front

2015-08-30 Thread Martín Marqués
El 24/08/15 a las 15:41, Florin Andrei escribió: > On 2015-08-23 06:56, Martín Marqués wrote: >> El 21/08/15 a las 20:45, Florin Andrei escribió: >>> >>> The single instance scheme is not very reliable. I need to build a new >>> DB backend. I'll set up Postgres 9.4. Ideally, I'd like to setup 2 >>>

Re: [GENERAL] BDR setup - bdr_node_join_wait_for_ready()

2015-08-30 Thread Martín Marqués
El 27/08/15 a las 13:35, cchee-ob escribió: > What exactly does bdr_node_wait_for_ready() do? I've been trying to setup > BDR on an existing database and once I run the select > bdr.bdr_node_wait_for_ready(); command on the 2nd node after running the > bdr.bdr_group_join() command it just hangs .

[GENERAL] Slave promotion problem...

2015-08-30 Thread marin
Last week we had some problems on the master server which caused a failover on the slave (the master was completely unresponsive due to reasons still unknown). The slave received the promote signal (pg_ctl promote) and logged that in the logs: 2015-08-28 23:05:10 UTC [6]: [50-1] user=,db= LOG: