Re: [ADMIN] Vacuum explained -> Dangerous ?

"Tom Lane" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Robert Treat <[EMAIL PROTECTED]> writes: > > Tup = # of "rows" in your table > > Right. This is the number of rows remaining after the vacuum, to be > precise. > > > Keep = # of tuples that the db did no

[ADMIN] User Management

What user management applications are available to work with PostgreSQL. I'd like to have users and and groups for my PostgreSQL based application. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (se

[ADMIN] sanity error with pg_dump on postgresql 7.0.2

I am forwarding this on behalf of [EMAIL PROTECTED] who is at a client site and cannot email. He's found a solution to the problem but wants to know if there are any other issues. Hopefully, this will document the problem/solution in one tidy place. Please cc any replies to both him and me.

[ADMIN] Weird behaviour on Solaris: recv() returns ENOENT

Hi, I'm having a customer running PostgreSQL 7.2.3 on Solaris 9 with PHP 4.3.0, and he's getting this error: could not receive data from server: No such file or directory grepping through the libpq source, it appears that the only way this message could happen is if recv() returns -1 wit

Re: [ADMIN] sanity error with pg_dump on postgresql 7.0.2

"Dan Langille" <[EMAIL PROTECTED]> writes: > I am forwarding this on behalf of [EMAIL PROTECTED] who is at a client > site and cannot email. > I did a search and found a mail stating that its possibly related to > a deleted user having ownership of the table. > "http://www.geocrawler.com/mail/m

[ADMIN] Postgresql 7.3 and startup

Title: Gareth Stationery 'ello all.   I've just compiled postgresql from source. It's running fine - but now I want to quickly add it to the Redhat /etc/rc.d/init.d services. I can't find the postgresql file that is normally installed there from rpm installation anywhere - is there still one,

Re: [ADMIN] sanity error with pg_dump on postgresql 7.0.2

On 7 Jan 2003 at 10:29, Tom Lane wrote: > "Dan Langille" <[EMAIL PROTECTED]> writes: > > I am forwarding this on behalf of [EMAIL PROTECTED] who is at a client > > site and cannot email. > > > I did a search and found a mail stating that its possibly related to > > a deleted user having ownership

Re: [ADMIN] repair table? database? how ? neccessary?

[Sorry to all for the large amount of quoted text] Now I have been religiously running Vacuumdb --analyze (nightly) at 130am, and the Postgresql database is currently 5 times the size of the level when I began to have m$ft problems (i know that by the number of records that are being stored) {

Re: [ADMIN] sanity error with pg_dump on postgresql 7.0.2

Hello, I am just wondering why Postgresql allow to drop a user without checking if he has any created tables/objects with him? Is it going to be optimized in the future release? Regards. Helen L.  Dan Langille <[EMAIL PROTECTED]> wrote: On 7 Jan 2003 at 10:29, Tom Lane wrote:> "Dan Langille" <[EMAI

Re: [ADMIN] Postgresql 7.3 and startup

There is a file called "linux" in the "/usr/local/src/postgresql-7.3/contrib/start-scripts" directory (or whereever your postgres source is located).  Just copy this file into "/etc/rc.d/init.d/postgresql"  and it should work. regards, Devinder Rajput Stores Division Corporate Offices Chicago, I

Re: [ADMIN] Postgresql 7.3 and startup

That'd be the one :-) Cheers -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Devinder K RajputSent: 07 January 2003 17:57To: [EMAIL PROTECTED]; [EMAIL PROTECTED]Subject: Re: [ADMIN] Postgresql 7.3 and startupThere is a file called "linux

Re: [ADMIN] Vacuum explained

Tom Lane writes: > > Unused = # of tuples awaiting being reused > > These are not actually tuples, but tuple slots (page item pointers) > that are open for re-use. Maybe this is a good place to ask this: How do you actually reuse a tuple (or the space the tuple needed on disk) if the number of b

Re: [ADMIN] [BUGS] pgdb.py is still wrong [not just] in Postgres 7.3.1

I have CC'ed D'Arcy asking for info. --- Tom Lane wrote: > Lamar Owen <[EMAIL PROTECTED]> writes: > > Tom, Bruce: who has the python interface these days? > > D'Arcy still is the lead guy on it, I think. Looking at the CVS

Re: [ADMIN] Vacuum explained

Tilo Schwarz <[EMAIL PROTECTED]> writes: > Do you try to reuse tuples with a similar storage size (or something like > that) No. If we try to put a tuple on a page, and there's room there, we'll store it. There is no intra-page fragmentation problem because we can always reshuffle the tuples on

[ADMIN] where is the database physically

Hi. Thank you all for your thoughful comments, Philo and Jeremy. One question wasn't addressed (mixed in with the mess of comments, my fault...). Where is the database located physically - i guess /var/lib/pgsql but how is it broken into files. For instance in mysql, i find the directory /var/

Re: [ADMIN] Vacuum explained -> Dangerous ?

"Gaetano Mendola" <[EMAIL PROTECTED]> writes: > This mean that if a process do a "begin transaction" and stay there one > month without > activity all row delete or updated after that "begin transaction" remain > there for ever ? Actually not, because the transaction does not start internally (MyP