Re: [ADMIN] viewing results in terminal on RedHat 6.1

2011-06-03 Thread Brett Parker
it for you, the issue is that the termcap init/deinit for your terminal clears the output. Cheers, -- Brett Parker -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Why pg_dump 'trust' authentication fails under root and works under another user?

2011-03-24 Thread Brett Parker
. root, per default, does not have a user in postgres. Run your script as the postgres user if you *really* want super user access. Thanks, -- Brett Parker http://www.sommitrealweird.co.uk/ PGP Fingerprint 1A9E C066 EDEE 6746 36CB BD7F 479E C24F 95C7 1D61 -- Sent via pgsql

Re: [ADMIN] Table space grow big - PostgreSQL

2010-05-05 Thread Brett Parker
possible usage of lots of space is indexes on the database tables, these are not included in the dump, and so the size of the dump doesn't accurately reflect the size of the on disc data. Hope that gives you somewhere to start from. Thanks, -- Brett Parker -- Sent via pgsql-admin mailing list