"Maria L. Wilson" writes:
> i'm getting the following error. any ideas why this would be in
> single user mode??
Maybe you've got some prepared transactions laying about?
Check pg_prepared_xacts ...
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-adm
this is the command that i used to start the backend
postgres --single -D /data/pg_devices ange
Maria L. Wilson wrote:
i'm getting the following error. any ideas why this would be in
single user mode??
backend> drop database "scoogan_userprofile_1.2"
2009-04-21 18:18:23.032 EDT [
i'm getting the following error. any ideas why this would be in
single user mode??
backend> drop database "scoogan_userprofile_1.2"
2009-04-21 18:18:23.032 EDT [11767] [] WARNING: database "ange" must
be vacuumed within 976081 transactions
2009-04-21 18:18:23.032 EDT [11767] [] HINT:
ok - i am still having the same errors after removing the majority of
the databases on this server - leaving only 46 left. I have gone into
single user mode and vacuumed the rest.
any other ideas would be greatly appreciated!!!
log file.
2009-04-21 16:14:36.688 EDT [10757] [] LOG: databa
Admin folks, please don't reply to this email; the discussion will
continue on hackers; thanks.
---
bruce wrote:
> May, Randy wrote:
> > PostGresQL Admin,
> >
> >
> >
> > I am part of an organization that is beginning
May, Randy wrote:
> PostGresQL Admin,
>
>
>
> I am part of an organization that is beginning to write commercial
> applications for various Portals (Liferay, etc.). We would like to be
> able to deploy PostGresQL as the lightweight database for the Portal to
> connect to. Our request for appr
On Tue, 2009-04-21 at 11:13 -0400, May, Randy wrote:
> PostGresQL Admin,
>
This is more of a hackers discussion. I am forwarding there.
-Hackers,
Do we have a history on this file?
Joshua D. Drake
>
>
> I am part of an organization that is beginning to write commercial
> applications for
PostGresQL Admin,
I am part of an organization that is beginning to write commercial
applications for various Portals (Liferay, etc.). We would like to be
able to deploy PostGresQL as the lightweight database for the Portal to
connect to. Our request for approval to our Legal Department has
s
Hi,
I wanted to report a new way to shut down a postgres instance. I was
troubleshooting a PAM-warning message in syslog and decided to restart slpd
/etc/init.d/slpd, since I made a small change in ldap.conf, the OpenSLP
daemon for the Service Location Protocol. It caused both instances o