[ADMIN] How to install Postgresql 8.3.x on windows XP

2007-11-22 Thread porntipa
I have been trying to find out how to install PostgreSQL in a Windows XP . When i have been install PostgreSQL with postgresql-8.3-dev1.zip in safe mode it show message The system administrator has set policies to prevent this installation. Can somebody please guide me on how to go about intalling

[ADMIN] backup of postgres scheduled with cron

2007-11-22 Thread Sorin N. Ciolofan
Hello all! I've a small bash script backup.sh for creating dumps on my Postgre db: #!/bin/bash time=`date '+%d'-'%m'-'%y'` cd /home/swkm/services/test pg_dump mydb mydb_dump_$time.out I've edited crontab and added a line: 00 4 * * * swkm

Re: [ADMIN] backup of postgres scheduled with cron

2007-11-22 Thread Marco Bizzarri
On Nov 22, 2007 2:19 PM, Sorin N. Ciolofan [EMAIL PROTECTED] wrote: Hello all! I've a small bash script backup.sh for creating dumps on my Postgre db: #!/bin/bash time=`date '+%d'-'%m'-'%y'` cd /home/swkm/services/test pg_dump mydb mydb_dump_$time.out I've

Re: [ADMIN] backup of postgres scheduled with cron

2007-11-22 Thread Sorin N. Ciolofan
Hi Marco! Thank you for the advice. I got: /home/swkm/services/test/backup.sh: line 4: pg_dump: command not found updating: mydb_dump_22-11-07.out (stored 0%) which seems strange -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco Bizzarri Sent:

Re: [ADMIN] backup of postgres scheduled with cron

2007-11-22 Thread Marco Bizzarri
On Nov 22, 2007 2:46 PM, Sorin N. Ciolofan [EMAIL PROTECTED] wrote: Hi Marco! Thank you for the advice. I got: /home/swkm/services/test/backup.sh: line 4: pg_dump: command not found updating: mydb_dump_22-11-07.out (stored 0%) which seems strange Try putting the full path of the

Re: [ADMIN] backup of postgres scheduled with cron

2007-11-22 Thread Andrew Sullivan
On Thu, Nov 22, 2007 at 02:28:08PM +0100, Marco Bizzarri wrote: why don't you add a MAILTO=youraddress at the start of your crontab file, so that you can receive a report of the problem? Note: check that your cron accepts such an addition. Many systems now use Vixie's cron, which does accept

Re: [ADMIN] backup of postgres scheduled with cron

2007-11-22 Thread Marco Bizzarri
On Nov 22, 2007 2:53 PM, Andrew Sullivan [EMAIL PROTECTED] wrote: On Thu, Nov 22, 2007 at 02:28:08PM +0100, Marco Bizzarri wrote: why don't you add a MAILTO=youraddress at the start of your crontab file, so that you can receive a report of the problem? Note: check that your cron accepts

Re: [ADMIN] [GENERAL] backup of postgres scheduled with cron

2007-11-22 Thread Frank Wittig
Hello Sorin! Sorin N. Ciolofan wrote: #!/bin/bash time=`date '+%d'-'%m'-'%y'` cd /home/swkm/services/test pg_dump mydb mydb_dump_$time.out You should output STDERR to some error logfile or set MAILTO in your crontab. I guess you then would have seen an error message

Re: [ADMIN] backup of postgres scheduled with cron

2007-11-22 Thread Andrew Sullivan
On Thu, Nov 22, 2007 at 02:59:33PM +0100, Marco Bizzarri wrote: Andrew, can you confirm the previous statement? I'm checking on a Debian Linux, at it seems to be a Vixie Cron, and that feature is described in the man page... If the feature's in your man page, then it works on your system :)

Re: [ADMIN] [GENERAL] backup of postgres scheduled with cron

2007-11-22 Thread Sorin N. Ciolofan
Thank you all, Yes, I used the absolute path in my script and now works ok :-) Thank you again Sorin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Frank Wittig Sent: Thursday, November 22, 2007 4:01 PM To: Sorin N. Ciolofan Cc:

Re: [GENERAL] [ADMIN] backup of postgres scheduled with cron

2007-11-22 Thread Andrew Sullivan
On Thu, Nov 22, 2007 at 09:14:13AM -0500, Martin Gainty wrote: Good Morning AndrewI noticed the Vixie cron responds to SIGHUP signalsDo you have any suggestions or tutorials on how Postgres would feed these event signals to Vixie cron? Why would Postgres have to tell crond to restart? A

Re: [GENERAL] [ADMIN] backup of postgres scheduled with cron

2007-11-22 Thread Martin Gainty
Good Morning AndrewI noticed the Vixie cron responds to SIGHUP signalsDo you have any suggestions or tutorials on how Postgres would feed these event signals to Vixie cron? Thanks/Martin __Disclaimer and confidentiality noteEverything in this e-mail

Re: [ADMIN] Row Lock

2007-11-22 Thread Scott Marlowe
On Nov 22, 2007 12:31 PM, PostgreSQL [EMAIL PROTECTED] wrote: I'm having a problem with some row locks where one user does the lock and another user try to do the same, but of course, the second one will be waiting the first user unlock it. I would like to know if there is a way to discover

[ADMIN] Row Lock

2007-11-22 Thread PostgreSQL
I'm having a problem with some row locks where one user does the lock and another user try to do the same, but of course, the second one will be waiting the first user unlock it. I would like to know if there is a way to discover if that row is locked before I try to do the lock. I have