Re: [ADMIN] Help understanding locale
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 appear at their correct place, whitespace is ignored. The latter in principle applies to all other language-specific locales as well, except that the particular relative order of the letters may be different. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [ADMIN] Create Linux Script for PostgreSQL database backup
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 the crontab file for it to process your addition. Your better solution is to use the tools designed for editing crontab, such as 'crontab -e.' If you use this tool, crontab will automagically reread the file. -- Until later, Geoffrey Registered Linux User #108567 AT&T Certified UNIX System Programmer - 1995 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [ADMIN] Create Linux Script for PostgreSQL database backup
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 tell cron to reread the crontab file for it to process your addition. Your better solution is to use the tools designed for editing crontab, such as 'crontab -e.' If you use this tool, crontab will automagically reread the file. One question , if you set access to server with password in pg_hba.conf how can you pass the apssword in the script? _ For your security, this mail has been scanned and protected by Inflex ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] Create Linux Script for PostgreSQL database backup
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 of that file... -- (format nil "[EMAIL PROTECTED]" "cbbrowne" "cbbrowne.com") http://cbbrowne.com/info/sap.html What would the world be like with no hypothetical situations? ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [ADMIN] Create Linux Script for PostgreSQL database backup
-- 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 to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email, and delete the message. Thank you.
Re: [ADMIN] Create Linux Script for PostgreSQL database backup
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 file... >> > True, but I see that as a *big* security hole. As opposed to putting it in the script file? Surely you jest. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [ADMIN] Create Linux Script for PostgreSQL database backup
-- 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 to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email, and delete the message. Thank you.
Re: [ADMIN] Create Linux Script for PostgreSQL database backup
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 lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[ADMIN] a pretty way to view group members?
-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 2838 4B67 D40F D086 3568 81FC E7E5 27AF 4A9A -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFBN2PVgfzn5SevSpoRAoBkAKCPfBdcGCtnGBU2WtZVptiv/83YRgCgl13k BaT2O2ot3Moow5l/ht11EUA= =NvV3 -END PGP SIGNATURE- ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
