Re: [ADMIN] postgres 8.2.9 can't drop database in single user mode

2009-04-21 Thread Tom Lane
"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

Re: [ADMIN] postgres 8.2.9 can't drop database in single user mode

2009-04-21 Thread Maria L. Wilson
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 [

[ADMIN] postgres 8.2.9 can't drop database in single user mode

2009-04-21 Thread Maria L. Wilson
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:

Re: [ADMIN] postgres 8.2.9 transaction id wraparound failure

2009-04-21 Thread Maria L. Wilson
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

Re: [ADMIN] License Issue

2009-04-21 Thread Bruce Momjian
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

Re: [ADMIN] License Issue

2009-04-21 Thread Bruce Momjian
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

Re: [ADMIN] License Issue

2009-04-21 Thread Joshua D. Drake
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

[ADMIN] License Issue

2009-04-21 Thread May, Randy
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

[ADMIN] slpd restart restarted postgres

2009-04-21 Thread dx k9
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