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 disc
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 been
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 a
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
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: pgsql-admin@postgresql.o
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
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 mes
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=" at the start of your
> > crontab file, so that you can receive a report of the problem?
>
> Note: check that your cron accepts
On Thu, Nov 22, 2007 at 02:28:08PM +0100, Marco Bizzarri wrote:
>
> why don't you add a "MAILTO=" 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 that,
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
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: Th
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.o
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 /home/swkm/services/test
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
intallin
14 matches
Mail list logo
