2006. November 8. 02.34 dátummal Michael McCloskey ezt írta:
> Postgres is starting automatically for me at startup.
> When I boot up my machine and then check the running processes I
> see postmaster.exe and 4 postgres processes.
> How can I stop this?
PGBIN="/usr/local/pgsql/bin";
PGDATA="/srv/po
Will Cameron <[EMAIL PROTECTED]> writes:
> We are using (PostgreSQL) 8.0.1 for Solaris. Apparently our
> postgres users were wiped out somehow, for I cannot even log in as
> superuser "postgres". Our pg_hba.conf settings are as loose as possible
> ("trust"). This problem started mid session
Hi, the new guy is back with another
question.
Regarding partitioning – I set up a
testing table – parent table and 4 partitioning children’s tables
inheriting the
Attributes of the parent. I inserted
1800 rows in all – 450 equitably in each partition. The CHECK constraints
work great
Hello, We are using (PostgreSQL) 8.0.1 for Solaris. Apparently ourpostgres users were wiped out somehow, for I cannot even log in assuperuser "postgres". Our pg_hba.conf settings are as loose as possible("trust"). This problem started mid session after we ran a .sql scriptto upgrade a DSpace
Excellent addition. I suggest in 24.1 - Shared Disk Failover something
about the risk of having two postmasters come up on the same data
directory, which is entirely possible if the old master doesn't release
the disk in time.
On Tue, 2006-11-14 at 15:11 -0500, Bruce Momjian wrote:
> I wrote th
Yup that sounds useful - would this be another column added to the
pg_stop_backup called "wal_filename" or similar?
My script uses this name to find the date/time of the current ".backup"
file and remove any files earlier than it (except obviously the one
listed in the START WAL LOCATION).
I've
