Re: [ADMIN] Help understanding locale

2004-09-02 Thread Peter Eisentraut
Am Mittwoch, 1. September 2004 23:03 schrieb Chris Hoover: > Would you please be so kind to provide a bit more explanation? How will > the sort differ? C sorts by byte value, which ends up being AB...Zab...z. en_US sorts using "dictionary order", which means aAbB...zZ, accented characters appea

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

2004-09-02 Thread Geoffrey
Kaolin Fire wrote: For that matter: 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. Unless things have changed, and they might have, you have to tell cron to reread

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

2004-09-02 Thread Sandro Garoffolo
Geoffrey wrote: Kaolin Fire wrote: For that matter: 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. Unless things have changed, and they might have, you have to te

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

2004-09-02 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Sandro Garoffolo) wrote: > One question , if you set access to server with password in > pg_hba.conf how can you pass the apssword in the script? You don't have to if you put it in $HOME/.pgpass; see the documentation for the format o

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

2004-09-02 Thread Naomi Walker
-- CONFIDENTIALITY NOTICE -- This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized t

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

2004-09-02 Thread Tom Lane
Naomi Walker <[EMAIL PROTECTED]> writes: > Christopher Browne wrote: >>> One question , if you set access to server with password in >>> pg_hba.conf how can you pass the apssword in the script? >> >> You don't have to if you put it in $HOME/.pgpass; see the >> documentation for the format of that

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

2004-09-02 Thread Naomi Walker
-- CONFIDENTIALITY NOTICE -- This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized t

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

2004-09-02 Thread Tom Lane
Naomi Walker <[EMAIL PROTECTED]> writes: > Anything would plain text would be a problem. Isnt .pgpass plain text? Plain text is irrelevant. Securing the file properly is what's relevant (and libpq will not read a .pgpass file with insecure permissions...) regards, tom la

[ADMIN] a pretty way to view group members?

2004-09-02 Thread Andrew Hammond
-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? - -- Andrew Hammond416-673-4138[EMAIL PROTECTED] Database Administrator, Afilias Canada Corp. CB83 28