I recently built a test server running 8.4/FreeBSD 7.2/amd64, built from
the ports.
I am seeing the following message in the logs:
"autovacuum: found orphan table "pg_temp_1""."pga_tmp_zombies" in
database "postgres"
"autovacuum: found orphan table "pg_temp_2""."pga_tmp_zombies" in
databas
Alvaro Herrera writes:
> BTW I notice that this does not work unless the client supplies the
> password the first time around; psql does not retry. It only works if I
> do "psql -W".
Huh, that sounds like a bug someplace. Care to trace through it?
regards, tom lane
--
Tom Lane wrote:
> Alvaro Herrera writes:
> > You can authenticate users with PAM, which amounts more or less to the
> > same thing.
>
> I believe though that using PAM against /etc/shadow would require the
> postmaster to run as root. You need some external authentication
> server; PAM by itself
Alvaro Herrera writes:
> You can authenticate users with PAM, which amounts more or less to the
> same thing.
I believe though that using PAM against /etc/shadow would require the
postmaster to run as root. You need some external authentication
server; PAM by itself isn't going to solve it. May
Eamonn Martin wrote:
>
> Hi,
>
> Could someone confirm that the ability to share the Linux system
> /etc/passwd (or shadow) file with PostgreSQL is definitely defunct?
>
> I've searched the archives and, as far as I can tell, this
> functionality was removed after version 7.2 as "few were using
On Fri, Aug 7, 2009 at 8:08 AM, Eamonn Martin wrote:
>
> Hi,
>
> Could someone confirm that the ability to share the Linux system /etc/passwd
> (or shadow) file with PostgreSQL is definitely defunct?
>
> I've searched the archives and, as far as I can tell, this functionality was
> removed after ve
Hi,
Could someone confirm that the ability to share the Linux system
/etc/passwd (or shadow) file with PostgreSQL is definitely defunct?
I've searched the archives and, as far as I can tell, this functionality
was removed after version 7.2 as "few were using it". Well we were using
it and
Frank Broniewski wrote:
> when I do "netstat -an" I get the following lines:
>
> tcp0 0 127.0.0.1:5432 0.0.0.0:*
> LISTEN
> tcp0 0 127.0.0.1:5432 127.0.0.1:57647
> ESTABLISHED
> tcp0 0 127.0.0.1:41572 127.0
Hello all,
when I do "netstat -an" I get the following lines:
tcp0 0 127.0.0.1:5432 0.0.0.0:* LISTEN
tcp0 0 127.0.0.1:5432 127.0.0.1:57647
ESTABLISHED
tcp0 0 127.0.0.1:41572 127.0.0.1:5432
ESTABLISH
