Hello there...
I've compile postgreSQL 7.0.2 but I got an error message...Below is the
error...
gcc: Internal compiler error: program cc1 got fatal signal 11
gmake[3]: *** [hio.o] Error 1
gmake[3]: Leaving directory
`/tmp/postgresql-7.0.2/src/backend/access/heap'
gmake[2]: *** [submake] Error 2
s to use.
Next, you should create a line in your /etc/crontab or /var/spool/cron/root file
to execute the redundancy script with root level permissions:
0-59/5 * * * * /root/redundancy.pl
You should install the redundancy.pl and rederhandler.pl scripts in the same
directory.
You will, of cours
Be sure to stop postgres, rotate your log (or move it out of the /var/log
directory and then rotate it), and restart postgresql. That will solve your
problem. Hopefully you don't need a 24x7 available database as this might take
a few seconds for your server to complete.
On Wed, 07 Mar 2001, Wi
Check the file permissions on pg_hba.conf, I beat my head against the wall with
a similar situation.
Rodney Hampton
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
This is a little odd, and I can't quite figure out how to do it.
I have a postgres 7.2.2 database, without the DB_VERSION file, so I'm assuming
this is an "alternate location" - as you can tell, I'm not a DBA. Anyway,
the machine it was on got hacked, and I backed off the things I thought were
im
I can't start postgres using a modified form of the startup script
supplied in the contrib directory. I keep getting an error from su
saying that "D is an invalid option."
Below is the entire script:
> #! /bin/sh
>
> # This is an example of a start/stop script for SysV-style init, such
> # as i
I downloaded postgresql 7.2.1 - rpm version, installed it to my Linux machine
and inputted some of my data in postgresql. Now I would like to re-configure
my postgresql server by increasing --enable-local and
--enable-multibyte=UNICODE options. How should I do?
I found all document talking ab
Hello!
I've got a problem with converting my old database from version 6.3.1 to
6.4. I tried pg_dumpall, but in the 6.4 psql cannot import it. It crashes
with error. Maybe someone knows any other conversion utility? I've got a
big database (pg_dumpall result is about 50MB), I am running linux 2.0.
