I have no idea how it's done on Warp, but you need to enable semaphores so
that PostgreSQL can create one for its use. I know on Solaris you edit the
/etc/system file, and I think it's automatic on Windows (I never tried
PostgreSQL on that platform so I don't know for sure), but have no clue on
h
Loïc TREGOUËT writes:
> The following is ok :
> $ psql -h localhost -U postgres
> $ psql -h 127.0.0.1 -U postgres
>
> but this don't work :
> $ psql -U postgres
> psql: connectDBStart() -- connect() failed: Connection refused
> Is the postmaster running at 'localhost'
> and
David Huttleston Jr writes:
> The file tbl_voters_full.1 is new to me, and it does contain data.
> Is this a temporary table? Is it safely deletable?
>
> ** snipped from a ls of /home/postgres/data/base/pacwebdev
> -rw---1 postgres postgres 1073741824 Oct 4 23:53 tbl_voters_full
> -rw
Hi,
I'm using Warp V3 for windows (german edition), fixpack is 40 (revision
level 8.264). For TCP/IP access, I installed the Internet Access Kit (V
2.0) running with local loop (loopback done by running "ifconfig.exe lo
127.0.0.1 up"). The EMX level is 0.9d. Hardware is 486DX80, 36MB RAM.
After
Thank you for your reply. Pretty nice script actually.
Thanks also to the pg_dumplo-0.0.5 of [EMAIL PROTECTED]
I kinda like experimenting on perl script and I encountered problems using
pg_dumplo-0.0.5 in exporting. So I decided to make my own perl script for
exporting
all large object of all Pg
On Fri, Oct 06, 2000 at 07:48:03PM +0800, pgsql-admin wrote:
> you can also try this:
or:
#!/bin/bash
PREFIX=/directory
DATABASE=db
rm -f $PREFIX.last
pg_dump -d $DATABASE -f $PREFIX.last
ln -f $PREFIX.last $PREFIX.hour.`date +%H`
ln -f $PREFIX.last $PREFIX.day.`date +%d`
ln -f $PREFIX.last $PRE
you can also try this:
#!/bin/sh
# Backing up each database...
pg_dumpall -o | bzip2 > /var/lib/pgsql/backups/pgdumpall_`date
"+%Y%m%d"`.bz2
# Removing backups of last seven days...
find /var/lib/pgsql/backups -mtime +7 -exec rm -f {} \;
Sherwin
[EMAIL PROTECTED] writes:
>>I use PostgreSQL ve
Hello ,
The following is ok :
$ psql -h localhost -U postgres
$ psql -h 127.0.0.1 -U postgres
but this don't work :
$ psql -U postgres
psql: connectDBStart() -- connect() failed: Connection refused
Is the postmaster running at 'localhost'
and
