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:
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 .
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
>>>
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"
>
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
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
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
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
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
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
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
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:
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
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
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.
15 matches
Mail list logo
