[ADMIN] pg_toast_xxxxxx_index is not a btree error

Title: pg_toast_xx_index is not a btree error Hi, We are in process of upgrading one of our postgres database from 7.2.1 to 8.0.1. The dump was taken in copy format from 721 and imported the same into 801, but for some reason it fails in the middle of import with below error. ERROR: i

Re: [ADMIN] pg_toast_xxxxxx_index is not a btree error

"Subbiah, Stalin" <[EMAIL PROTECTED]> writes: > We are in process of upgrading one of our postgres database from 7.2.1 > to 8.0.1. The dump was taken in copy format from 721 and imported the > same into 801, but for some reason it fails in the middle of import with > below error.=20 > ERROR: index

[ADMIN] Many idle processes?

I just went live yesterday and I can see many idle processes on my redhat AS4 running postgres 8.0.2 Is this something I should be worried about? Being a newb to Linux and somewhat to postgres I need to add the vacuum and backup scenario. Josh from Commandpromt gave me some syntax, so I

[ADMIN] Irrevocable privileges

Title: Irrevocable privileges I think it's silly that any privileges that an owner grants to himself are essentially irrevocable.  It's silly because it makes changing the object owner pointless.  Consider: User joe creates table foo User joe grants permission rw to himself on foo User

Re: [ADMIN] Irrevocable privileges

"Dave Held" <[EMAIL PROTECTED]> writes: > I think it's silly that any privileges that an owner grants to himself = > are essentially irrevocable. Say again? An owner can certainly revoke his own ordinary privileges. > Consider: > User joe creates table foo > User joe grants permission rw to him

[ADMIN] when to modify..

Either Im tired or the documentation is confusing, when do I need to modify pg_hba.conf vs just doing a createuser thanks lori ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmail

Re: [ADMIN] when to modify..

Lori wrote: Either Im tired or the documentation is confusing, when do I need to modify pg_hba.conf vs just doing a createuser thanks Well that entirely depends but in general if the user is connecting to the same database from the same network or machine that others users already use you only nee

[ADMIN] Problem with SSL - Server went 100% Busy

Hi, This is my first PostgreSQL post so hopefully I've chosen the right list for my problem. I've relatively new to PostgreSQL but have had quite a bit of admin experience with Informix 7/9 over the years. I have PostgreSQL 8.0 installed on a Windows2003 server (SP1) and configured to use SSL on

Re: [ADMIN] when to modify..

Lori wrote: Either Im tired or the documentation is confusing, when do I need to modify pg_hba.conf vs just doing a createuser thanks create user creates a database user account. pg_hba.conf provides a set of access permissions regarding where and how users and/or computers can connect to the data