Re: [ADMIN] pgdump and large objects

1999-12-04 Thread Peter Eisentraut
On 1999-12-01, Alf Lewerken mentioned: > How can I backup large objects of my database. > > I use pg_dump > > This dumps the databasetables and indices properly but how do I > dump large objects? > > Because I use the oid´s of the large objects as a reference in the tuples in > some tables, t

[ADMIN] CPU Load Help

1999-12-04 Thread Chris Jester
A problem for you Postgres gurus: I'm running Postgres via perl DBI::DBD interface and for some reason whenever I run any SQL actions to the postgres daemon postgres takes up ALL available CPU % while its running the process, then drops back down to nothing when it quits. I am starting postgres