Re: [ADMIN] Password protected databases and automated backups

1999-08-02 Thread Peter Eisentraut
On Tue, 3 Aug 1999, Dmitry Morozovsky wrote: > On Mon, 2 Aug 1999, Peter Eisentraut wrote: > > PE> > How can I organize automated database dumping for passord protected > PE> > database? > PE> If you're implying something like "How do I get around entering a > PE> password?", that won't be solva

Re: [ADMIN] Password protected databases and automated backups

1999-08-02 Thread Dmitry Morozovsky
DM> PE> A different solution would be to backup the $PGDATA/base directory using DM> PE> regular file backup methods. That wouldn't be a dump, so it depends on DM> PE> your particular needs. DM> DM> This may not have the desired effect, as the database may be not in DM> consistent state. Of co

Re: [ADMIN] Password protected databases and automated backups

1999-08-02 Thread Dmitry Morozovsky
On Mon, 2 Aug 1999, Peter Eisentraut wrote: PE> > How can I organize automated database dumping for passord protected PE> > database? PE> If you're implying something like "How do I get around entering a PE> password?", that won't be solvable so easily. Possibly you want to use PE> ident authenti

Re: [ADMIN] Password protected databases and automated backups

1999-08-02 Thread Peter Eisentraut
On Mon, 2 Aug 1999, Dmitry Morozovsky wrote: > How can I organize automated database dumping for passord protected > database? If you're implying something like "How do I get around entering a password?", that won't be solvable so easily. Possibly you want to use ident authentication for that pa

[ADMIN] Password protected databases and automated backups

1999-08-02 Thread Dmitry Morozovsky
Hi there, How can I organize automated database dumping for passord protected database? Any suggestions are welcome. Thank you in advance. Sincerely, D.Marck [DM5020, DM268-RIPE, DM3-RIPN]

Re: [ADMIN] Problem with triggers and functions

1999-08-02 Thread Callum Downie
I've had exactly same problem with PostgreSQL 6.4.x and 6.5.0 on Solaris 2.5.1 and 7 (latest GNU compilers and tools). Since I didn't have time to delve into code to find out why and not a priority, I installed RedHat 5.2 (then 6) on my Sun Sparc and PostgreSQL worked ok, compiling 6.4.2 and 6.5 f

Re: [ADMIN] Problem with triggers and functions

1999-08-02 Thread David Ouellet
It is a new install on Solaris 7. There is no file /etc/ld.so so following the instructions, I added /usr/local/pgsql/lib to my LD_LIBRARY_PATH. Terry Mackintosh wrote: > Hi David > > Is this a new install? on a Linux box? if so did you add > /usr/local/pgsql/lib to /etc/ld.so.conf and then run