Thread: postgresql standby using pg_archivecleanup don't work

postgresql standby using pg_archivecleanup don't work

From
leo xu
Date:
i have one parimary ,two standby. one standby using stream replication
connect to primary.another standby using basebackup,then recovery database
--cp archivelog from primary using crontab.i want to delete old archivelog
from standby.but configure pg_archivecleanup don't work,meantime no error in
postgresql log.postgresql version is 9.1.2.
   the following is my recovery.conf :
   This is my recovery.conf:

standby_mode = 'on'
restore_command = 'cp /attend_pg_backup/u02/pg9.1/archivelog/%f %p'
archive_cleanup_command ='pg_archivecleanup
/attend_pg_backup/u02/pg9.1/archivelog %r'



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/postgresql-standby-using-pg-archivecleanup-don-t-work-tp5669340p5669340.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Re: postgresql standby using pg_archivecleanup don't work

From
raghu ram
Date:


On Fri, Apr 27, 2012 at 11:44 AM, leo xu <leoxu8703@gmail.com> wrote:
i have one parimary ,two standby. one standby using stream replication
connect to primary.another standby using basebackup,then recovery database
--cp archivelog from primary using crontab.i want to delete old archivelog
from standby.but configure pg_archivecleanup don't work,meantime no error in
postgresql log.postgresql version is 9.1.2.
  the following is my recovery.conf :
  This is my recovery.conf:

standby_mode = 'on'
restore_command = 'cp /attend_pg_backup/u02/pg9.1/archivelog/%f %p'
archive_cleanup_command ='pg_archivecleanup
/attend_pg_backup/u02/pg9.1/archivelog %r'




Replace archive_cleanup_command in recovery.conf file as follows:

archive_cleanup_command ='pg_archivecleanup /attend_pg_backup/u02/pg9.1/archivelog %r'

           [to]

archive_cleanup_command = '/opt/PostgreSQL/9.1/bin/pg_archivecleanup -d /attend_pg_backup/u02/pg9.1/archivelog  %r 2>>/tmp/cleanup.log'


and then restart the Standby PostgreSQL cluster.

--

Thanks & Regards,

Raghu Ram

EnterpriseDB: http://www.enterprisedb.com

Re: postgresql standby using pg_archivecleanup don't work

From
leo xu
Date:
hello:
    i try it,but it nothing in pg_log.it still don't work!

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/postgresql-standby-using-pg-archivecleanup-don-t-work-tp5669340p5672191.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Deleting PostGres ID Under Windows XP?

From
PostGres@FatBelly.com
Date:
Somewhere along the line the install of one of my apps created a
userid named "PostGres", I assume in connection with installing
the PostGres database manager.

Now I no longer have the option of having the system just boot up
into my own ID: I have to select my ID from a login screen that
displays my own ID and "PostGres".

Googling, I get the impression that PostGres's password is not
really intended tb known to the user.

I'd like to drive a stake through this thing's heart.   I know I
can do it via Control Panel | User Accounts | Delete the account.

The Question:

Am I going to regret doing this?

Re: Deleting PostGres ID Under Windows XP?

From
Chris Angelico
Date:
On Sun, Apr 29, 2012 at 9:43 AM,  <PostGres@fatbelly.com> wrote:
> I'd like to drive a stake through this thing's heart.   I know I
> can do it via Control Panel | User Accounts | Delete the account.
>
> The Question:
>
> Am I going to regret doing this?

If you want to keep using Postgres, yes. Search the web for
information on hiding accounts from your login screen (be sure to
mention your Windows version as the method will differ) - the account
wouldn't bother you then.

ChrisA

Re: Deleting PostGres ID Under Windows XP?

From
PostGres@FatBelly.com
Date:
RE/
>> Am I going to regret doing this?
>
>If you want to keep using Postgres, yes. Search the web

Suspicion...... *Confirmed*.....

Thanks!

Re: postgresql standby using pg_archivecleanup don't work

From
Simon Riggs
Date:
On Fri, Apr 27, 2012 at 7:14 AM, leo xu <leoxu8703@gmail.com> wrote:

> i have one parimary ,two standby. one standby using stream replication

pg_archivecleanup doesn't work with more than one standby feeding from
a single archive

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services