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
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
(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
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
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
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
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
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
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:/
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
10 matches
Mail list logo