Hello,
I've been looking for a procedure (step by step) on how to remove Standby
(SLAVE) from Primary (MASTER) for Postgres9.1 in google and the archived
postings, but no luck. Can someone please shed some light on how to implement
this? Here's the assumption / expectation :
1. The rep
t again from a new base backup.
restore_command = 'cp /opt/postgres/9.1/archive/%f %p'
trigger_file='/opt/postgres/9.1/data/trigger'
Thanks,
Joanna Xu
Senior Oracle DBA
Data Experience Solution BU
+1 613 595 5234
AMDOCS | EMBRACE CHALLENGE EXPERIENCE SUCCESS
POLICY CONTROL IN TH
om: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Wednesday, October 26, 2016 7:50 PM
To: Michael Paquier ; Joanna Xu
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Remove Standby (SLAVE) from Primary (MASTER) -
Postgres9.1
On 10/26/2016 04:43 PM, Michael Paquier wrote:
> O
from Primary (MASTER) -
Postgres9.1
On Thu, Oct 27, 2016 at 10:27 AM, Scott Mead
mailto:sco...@openscg.com>> wrote:
On 10/27/16 10:12 AM, Joanna Xu wrote:
> We need to keep the data as it is so remving data fold is not feasible.
> If I run "pg_ctl promote" on the slave to
ostgres 9041 9035 0 18:57 ?00:00:00 postgres: archiver process
last was 00010003.0020.backup
ps -ef|grep sender |grep -v grep
postgres 9264 9035 0 19:00 ?00:00:00 postgres: wal sender process
postgres 192.168.154.106(64182) streaming 0/4000380
Cheers,
Jo
Jim Nasby [mailto:jim.na...@bluetreble.com] wrote:
>On 11/2/16 2:49 PM, Joanna Xu wrote:
>> The replication is verified and works. My questions are what's the
>> reason causing "cp: cannot stat
>> `/opt/postgres/9.1/archive/00010003'
Hi All,
We plan to use ora2pg tool to migrate Oracle to PostgreSQL. During the
testing, while importing content of the output.sql into PostgrSQL database, it
terminated with the following error "ERROR: type "aq$_jms_text_message" does
not exist" for "user_data" column with "AQ$_JMS_TEXT_MESSA
"aq$_jms_text_message". So the key question would be : does Postgres database
support "aq$_jms_text_message" type? If postgres does not support this type,
it will error out. I would need confirmation on this please.
Thanks,
Joanna
On Fri, Dec 09, 2016 at 05:22:
