Re: [ADMIN] postgres functions(.so)

2000-10-07 Thread Bruce Momjian
You can read a brief introduction in chapter 19 of my book at: http://www.postgresql.org/docs/awbook.html Sounds like you want to use the SPI interface. See the PostgreSQL manuals for more information. [ Charset KOI8-R unsupported, converting... ] > Hello > > Can anybody help me? >

Re: Re(2): [ADMIN] Crontab and PostgreSQL Backup

2000-10-07 Thread Jeff MacDonald
here's a backup script we use #!/bin/sh cd /pgsql/backups if [ ! -d $1 ] then mkdir $1 fi cd $1 for i in `ls $2 | egrep -v "template1|udmsearch"` do /usr/local/bin/rotate_files.pl $i 7 /pgsql/bin/pg_dump -p $1 -h localhost $i > $i.0 gzip -f $i.0 & done On Fri, 6