Re: [ADMIN] real and effective user ids must match

Did you get a copy of chkrootkit and/or rkhunter and run them on this machine? If so, let us know if it find a rootkit. If so, that's your problem. I think you may have to ask on one of the linux system administration lists. Which linux distribution and version did you indicate this is again?

Re: [ADMIN] Instructions For Building On Windows?

I should also tell you that I'm wanting to build version 8.1.4 of Postgres. Thanks for your help!! -Jeanna - Original Message - From: "Jeanna Geier" <[EMAIL PROTECTED]> To: Sent: Friday, September 15, 2006 2:47 PM Subject: [ADMIN] Instructions For Building On Windows? Hi All- Newb

[ADMIN] Instructions For Building On Windows?

Hi All- Newbie question that hopefully someone will be able to quickly help me with: I'm looking for instructions for building Postgres on Windows using Visual C++ (I'm using 2005 Express Edition). Is there anything available out there or can anyone provide me with some instructions? The ins

Re: [ADMIN] Auto Vacuum not starting unless postgres is restarted

Nick Howden <[EMAIL PROTECTED]> writes: > The firewall rules I have are : > # Postgres Statistics Collector > iptables -A INPUT -p udp \ > -i lo --sport 32779 --dport 32779 \ > -j ACCEPT > iptables -A OUTPUT -p udp \ > -o lo --sport 32779 --dport 32779 \ > -j AC

Re: [ADMIN] Auto Vacuum not starting unless postgres is restarted

>> Hi, >> >> On startup we get an error in the postgres log that the Autovacuum process has >> failed to start -- "autovacuum not started because of misconfiguration". >> However, if we do a restart (/etc/init/d/postgresql8.1 restart) then the >> autovacuum starts fine. >> >> Does anybody h

Re: [ADMIN] real and effective user ids must match

On Fri, 15 Sep 2006, Michael Fuhr wrote: On Thu, Sep 14, 2006 at 10:24:29PM -0700, Jeff Frost wrote: On Thu, 14 Sep 2006, Michael Fuhr wrote: Can anybody else with a Linux box test the above command? On my FC4 machine running 2.6.16-1.2111_FC4: uid=26(postgres) gid=26(postgres) groups=26(po

Re: [ADMIN] Postgresql 7.4 migration to (partially) new disks

Achilleas Mantzios <[EMAIL PROTECTED]> writes: > What considerations should someone take if he is about to just > cp -r /data . > .i.e. creating the PGDATA dir *not* following the standard initdb procedure If you copy the *entire* data tree (data, xlog, clog, any outside tablespaces), and use exac

Re: [ADMIN] real and effective user ids must match

On Thu, Sep 14, 2006 at 10:24:29PM -0700, Jeff Frost wrote: > On Thu, 14 Sep 2006, Michael Fuhr wrote: > >Can anybody else with a Linux box test the above command? > > On my FC4 machine running 2.6.16-1.2111_FC4: > > uid=26(postgres) gid=26(postgres) groups=26(postgres) > context=user_u:system_r

Re: [ADMIN] Postgresql 7.4 migration to (partially) new disks

Στις Παρασκευή 15 Σεπτέμβριος 2006 13:44, ο/η Achilleas Mantzios έγραψε: > Hi, > > Our main postgresql/jboss/lotus notes server is configured as follows. > > OS : Debian GNU linux 3.0 > PgSQL: 7.4.13 > > The FS structure of the system has as follows: > > > Filesystem 1k-blocks Used A

Re: [ADMIN] Odd behaviour with WAL and pg_stop_backup

"Donald Fraser" <[EMAIL PROTECTED]> writes: > We have been testing the on-line backup of PostgreSQL and after issuing a > pg_stop_backup() PostgreSQL is still using the archive command, as set in > postgresql.conf, for every new WAL block generated. Um ... why would that surprise you? That faci

Re: [ADMIN] Auto Vacuum not starting unless postgres is restarted

Nick Howden wrote: > Hi, > > On startup we get an error in the postgres log that the Autovacuum process > has > failed to start -- "autovacuum not started because of misconfiguration". > However, if we do a restart (/etc/init/d/postgresql8.1 restart) then the > autovacuum starts fine. > > D

Re: [ADMIN] install postgres8.1 on debian

"Iuri Sampaio" <[EMAIL PROTECTED]> writes: > mkdir: cannot create directory `/usr/local/pgsql/include': File exists Perhaps there is a plain file (not a directory) at that location? You will generally need to do the "make install" step as root if you're installing into a standard location such as

[ADMIN] Auto Vacuum not starting unless postgres is restarted

Hi, On startup we get an error in the postgres log that the Autovacuum process has failed to start -- "autovacuum not started because of misconfiguration". However, if we do a restart (/etc/init/d/postgresql8.1 restart) then the autovacuum starts fine. Does anybody have any idea what the pro

[ADMIN] Auto Vacuum not starting unless postgres is restarted

Hi, On startup we get an error in the postgres log that the Autovacuum process has failed to start -- "autovacuum not started because of misconfiguration". However, if we do a restart (/etc/init/d/postgresql8.1 restart) then the autovacuum starts fine. Does anybody have any idea what the pro

[ADMIN] Odd behaviour with WAL and pg_stop_backup

PostgreSQL 8.0.7 OS: Linux Red Hat 4.0 We have been testing the on-line backup of PostgreSQL and after issuing a pg_stop_backup() PostgreSQL is still using the archive command, as set in postgresql.conf, for every new WAL block generated. It appears the only way to truly stop it from using t

[ADMIN] Postgresql 7.4 migration to (partially) new disks

Hi, Our main postgresql/jboss/lotus notes server is configured as follows. OS : Debian GNU linux 3.0 PgSQL: 7.4.13 The FS structure of the system has as follows: Filesystem 1k-blocks Used Available Use% Mounted on /dev/sda1 9614116 6528132 2597612 72% / /dev/sd

Re: [ADMIN] install postgres8.1 on debian

Hi,   After configure   Use  gmake gmake install    (as a root) user.   Thanks & RegardsDilipkumar - Original Message - From: Iuri Sampaio To: pgsql-admin@postgresql.org Sent: Friday, September 15, 2006 12:57 PM Subject: [ADMIN] install postgres8.1 on debian

[ADMIN] install postgres8.1 on debian

I’m trying to install postgresql 8.1, from source but I get stuck at the 3 step:   1-   ./configure --without-zlib 2-   make all 3-   make install   (many lines omitted) make[3]: Leaving directory `/usr/local/src/postgresql-8.1.4/src/backend/utils/mb/conversion_procs/utf8