[ADMIN] could not truncate directory "pg_subtrans": apparent wraparound

2010-05-18 Thread Mikko Partio
Hi got the following line at postgresql log: May 16 01:17:35 xxx postgres[25550]: [1-1] LOG: could not truncate directory "pg_subtrans": apparent wraparound I assume this does not refer to xid wraparound? Should I be worried? Database has only a few users and probably noone accessed it during

Re: [ADMIN] troubled by pg_dump and pg_restore

2010-05-18 Thread Tena Sakai
Many thanks, Rosser, Sam, and Scott. Regards, Tena Sakai tsa...@gallo.ucsf.edu On 5/18/10 4:26 PM, "Scott Marlowe" wrote: > (Please stick to plain text posts, as many readers can't read html or > the formatting gets screwy. This is a plain text mailing list in > general. Attachments are ok

Re: [ADMIN] troubled by pg_dump and pg_restore

2010-05-18 Thread Scott Marlowe
(Please stick to plain text posts, as many readers can't read html or the formatting gets screwy. This is a plain text mailing list in general. Attachments are ok tho) On Tue, May 18, 2010 at 5:14 PM, Tena Sakai wrote: > > Hi Everybody, > > I am a bit troubled by pg_dump and pg_restore.  My pla

Re: [ADMIN] troubled by pg_dump and pg_restore

2010-05-18 Thread Samuel Stearns
Try this: pg_dump -n tsakai canon | psql musket Sam From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Tena Sakai Sent: Wednesday, 19 May 2010 8:45 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] troubled by pg_dump

Re: [ADMIN] troubled by pg_dump and pg_restore

2010-05-18 Thread Rosser Schwarz
On Tue, May 18, 2010 at 5:14 PM, Tena Sakai wrote: > > Can someone please tell me (1) if there is anything wrong with my > invocation > of pd_dump? (I want to generate a file pd_restore can use to feed to > musket database.) (2) Why pg_restore wouldn't give me listing? And (3) > why the second

[ADMIN] troubled by pg_dump and pg_restore

2010-05-18 Thread Tena Sakai
Hi Everybody, I am a bit troubled by pg_dump and pg_restore.  My platform is redhat linux, Del 64 bit hardware, running postgres 8.3.7. I have a database named canon and I want to move a schema full of tables from canon to a new database named musket.  The schema I am interested in is called tsaka

Re: [ADMIN] Clarification Needed: When does autovacuum daemon run?

2010-05-18 Thread Alvaro Herrera
Excerpts from Narasimha Murthy-VRFX87's message of mar may 18 05:56:26 -0400 2010: > Hello, > > Postgresql-8.2 manual has mentioned following points. > * The autovacuum daemon, when enabled, runs every autovacuum_naptime > seconds. > * autovacuum_naptime (integer): Specifies the delay between "a

Re: [ADMIN] Clarification Needed: When does autovacuum daemon run?

2010-05-18 Thread Narasimha Murthy-VRFX87
Thanks Devrim and Ian, for a quick response. I need some more clarification. autovacuum_naptime takes one minute by default. In this case, which second of each minute the autovacuum daemon runs (provided it is enabled)? What is the "activity rounds" mentioned in the manual? Regards, Narasimha

Re: [ADMIN] Clarification Needed: When does autovacuum daemon run?

2010-05-18 Thread Devrim GÜNDÜZ
On Tue, 2010-05-18 at 17:56 +0800, Narasimha Murthy-VRFX87 wrote: > My Query: I want to run autovacuum daemon everyday at 5 am. That is not "auto"vacuum. What you want is manual vacuum. -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer PostgreSQL RPM Repository: http:/

[ADMIN] Clarification Needed: When does autovacuum daemon run?

2010-05-18 Thread Narasimha Murthy-VRFX87
Hello, Postgresql-8.2 manual has mentioned following points. * The autovacuum daemon, when enabled, runs every autovacuum_naptime seconds. * autovacuum_naptime (integer): Specifies the delay between "activity rounds" for the autovacuum daemonThe delay is measured in seconds, and the default i