Re: [ADMIN] pg_dump from crontab

Try (do not use ">" output stream redirection, but "-f" switch): 0 20 * * 5 /usr/pgsql/bin/pg_dump -F c database -f /usr/backup/friDATE4.pgdump 0 20 * * 4 pg_dump -F c database -f /usr/backup/thurDATE06-3.pgdump Or instead (if it will not work): 1. Put those commands into root crontab file (/var

Re: [ADMIN] data for 64bits on 32

Christoph Simon <[EMAIL PROTECTED]> writes: > Until january of this year I had a 64bit AMD system maintaining a > database with about 8gb of data. Since then I had not accessed those > data and also went back to a 32bit System. Now, I would like to access > those data again, and thought it would be

Re: [ADMIN] Find out foreign key

> Hi people, > > I would like to know what's the system view that has information about > parent table and child table associated by Foreign Key!! > > Is it possible to find out that information? > > Thank you. Here you go (tested on 8.1) :) SELECT c.relname as table, r.conname as contraint,

Re: [ADMIN] pg_dump from crontab

Nirav Parikh wrote: > Hi, > > I am having problem backing up database from crontab, I got following > lines in crontab file > > > 0 20 * * 5 /usr/pgsql/bin/pg_dump -F c database > > /usr/backup/friDATE4.pgdump > 0 20 * * 4 pg_dump -F c database > /usr/backup/thurDATE06-3.pgdump > > none of

Re: [ADMIN] pg_dump from crontab

On Fri, 2006-08-04 at 02:20, Nirav Parikh wrote: > Hi, > > I am having problem backing up database from crontab, I got following > lines in crontab file > > > 0 20 * * 5 /usr/pgsql/bin/pg_dump -F c database > > /usr/backup/friDATE4.pgdump > 0 20 * * 4 pg_dump -F c database > /usr/backup/thurD

Re: [ADMIN] pg_dump from crontab

Am Freitag, 4. August 2006 09.20 schrieb Nirav Parikh: > Hi, > > I am having problem backing up database from crontab, I got following > lines in crontab file > > > 0 20 * * 5 /usr/pgsql/bin/pg_dump -F c database > > /usr/backup/friDATE4.pgdump > 0 20 * * 4 pg_dump -F c database > /usr/backup/thurD

[ADMIN] Find out foreign key

Hi people, I would like to know what's the system view that has information about parent table and child table associated by Foreign Key!! Is it possible to find out that information? Thank you. ---(end of broadcast)--- TIP 9: In versions below

[ADMIN] pg_dump from crontab

Hi,   I am having problem backing up database from crontab, I got following lines in crontab file     0 20 * * 5 /usr/pgsql/bin/pg_dump -F c database > /usr/backup/friDATE4.pgdump0 20 * * 4 pg_dump -F c database > /usr/backup/thurDATE06-3.pgdump   none of them works, I have given full per

[ADMIN] data for 64bits on 32

Until january of this year I had a 64bit AMD system maintaining a database with about 8gb of data. Since then I had not accessed those data and also went back to a 32bit System. Now, I would like to access those data again, and thought it would be enough to plug in the last year's drive. But unfort

Re: [ADMIN] Postgres Max JDBC Connection Allowed

On 8/10/06, Chris Mair <[EMAIL PROTECTED]> wrote: > Hi,> I am using Postgres 7.3 can any body tell me the max no of JDBC> connections allowed by postgres .The maximum number of connections is a configuration variable in thefile postgresql.conf in your PGDATA dir.Whether they origin from a JDBC

Re: [ADMIN] Postgres Max JDBC Connection Allowed

> Hi, > I am using Postgres 7.3 can any body tell me the max no of JDBC > connections allowed by postgres . The maximum number of connections is a configuration variable in the file postgresql.conf in your PGDATA dir. Whether they origin from a JDBC driver or not is not relevant. > I als

Re: [ADMIN] Tempdb

On Thu, 2006-08-10 at 10:52, Sharma;G.S. wrote: > Hi, > can anybody tell me the How temporary tablespace management is done by > postgres . > where the temdb is located , how to find out the space taken by tempdb Slowly step away from the Oracle and everything will be OK. :) Seriously though, Po

[ADMIN] Tempdb

Hi, can anybody tell me the How temporary tablespace management is done by postgres . where the temdb is located , how to find out the space taken by tempdb . Thanks     Disclaimer :- This e-mail message including any attachment may contain confidential, proprietary or legally privileged i

[ADMIN] Postgres Max JDBC Connection Allowed

Hi,     I am using Postgres 7.3 can any body tell me the max no of JDBC connections allowed by postgres .     I also want to know how to find out that howmuch memory and CPU , my postgres is taking .   Thanks in advance           Disclaimer :- This e-mail message including any attachment

Re: [ADMIN] vacuumdb exclude tables option?

On Thu, 2006-08-10 at 09:44, Joel Stevenson wrote: > Thanks for the reply. I'm still playing around a bit with my > autovacuum settings and the manual vaccum runs I'm making are part of > an effort to better understand the just what sort of settings I need > - I'm running vacuumdb with verbose

Re: [ADMIN] vacuumdb exclude tables option?

Thanks for the reply. I'm still playing around a bit with my autovacuum settings and the manual vaccum runs I'm making are part of an effort to better understand the just what sort of settings I need - I'm running vacuumdb with verbose output, etc. Since I know that these archive tables are a

Re: [ADMIN] vacuumdb exclude tables option?

On Wed, 2006-08-09 at 23:01, adey wrote: > Does autovacuum replace the need for a FULL vacuum please (to recover > free space, etc)? In most cases, yes. The idea is that autovacuum should put the database into a "steady state" where there is some % of each table that is free space and being recyc

[ADMIN] unsubscribe

Regards, Sun Do you Yahoo!? Next-gen email? Have it all with the all-new Yahoo! Mail Beta.