Re: [ADMIN] a pretty way to view group members?

2004-09-03 Thread Bruce Momjian
Andrew Hammond wrote: [ PGP not available, raw data follows ] > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Does anyone have a pretty way view the members of a group? > How about a list of groups which a user is in? > > Or do I need to re-invent this wheel? 8.0 will have \dg and \du will

Re: [ADMIN] Dump/Restore vs Vacuum Full

2004-09-03 Thread Adi Alurkar
Any comments ? knock knock!! is this thing ON? On Sep 1, 2004, at 5:59 PM, Adi Alurkar wrote: Greetings, Are there any differences, advantages of running a dump/restore vs running the following:1)REINDEX all the tables in all the databases, 2)VACUUM FULL ANALYZE on all the databases Assuming the

Re: [ADMIN] Create Linux Script for PostgreSQL database backup

2004-09-03 Thread Sanjay Arora
On Thu, 2004-09-02 at 12:26, Kaolin Fire wrote: > > echo "1 3 * * * postgres /usr/local/bin/pg_dumpall > > ~/backup.sql" >> /etc/crontab > > note to remember the two >>'s so you don't obliterate your crontab like > I just did. > Would someone tell of a modification to this script

[ADMIN] Selecting HW RAID controller

2004-09-03 Thread pginfo
Hi all, I am searching for good working HW RAID controller. I will use linux as OS. Also I will use SCSI. I readet the docs about adaptec AHA2120S, but do not find any comments about the driver supprt and how stable is for linux. Any ideas? Of course I will use it for pg. many thanks, ivan. -

Re: [ADMIN] Create Linux Script for PostgreSQL database backup

2004-09-03 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Naomi Walker) would write: > Anything would plain text would be a problem.  Isnt .pgpass plain > text? Yes, it's plain text. How do you propose to improve on that? At _some_ point, there has GOT to be a password in plain text form that

Re: [ADMIN] repeat Q: pg_attribute - Index

2004-09-03 Thread kris pal
Hi,   So can anyone suggest an easy way to REINDEX "pg_attribute_relid_attnam_index" (belongs to System Catalog). I am running 7.4.1 on Red Hat Linux 2.4.21-15.ELsmp kernel. Frequest data loads / deletes is causing this to grow at a fast rate.    This is becoming a concern. I don't want to drop