Thread: postgresql standby using pg_archivecleanup don't work
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.
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.
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.
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?
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/ >> Am I going to regret doing this? > >If you want to keep using Postgres, yes. Search the web Suspicion...... *Confirmed*..... Thanks!
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