Tom, No. Restarting the postmaster does not resolve the problem. I am going to put the debug build in place and see if I can still reproduce.
--Barry Tom Lane wrote: >Barry Lind <[EMAIL PROTECTED]> writes: > > >>The only postgres processes running are: >> >> > > > >>[root@cvs root]# ps -ef | grep post >>postgres 1004 1 0 Jul03 ? 00:00:00 >>/usr/local/pgsql/bin/postmaster >>postgres 1069 1004 0 Jul03 ? 00:00:00 postgres: stats buffer >>process >>postgres 1070 1069 0 Jul03 ? 00:00:00 postgres: stats >>collector proces >> >> > > > >>I then reconnected via psql and reran the vacuum full getting the same >>error. >> >> > >Really!? Well, does restarting the postmaster fix it? > > regards, tom lane > >---------------------------(end of broadcast)--------------------------- >TIP 5: Have you checked our extensive FAQ? > >http://www.postgresql.org/users-lounge/docs/faq.html > > > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
