Re: [ADMIN] Permissions

2006-04-04 Thread Milen Dzhumerov
Tom Lane wrote: Milen Dzhumerov [EMAIL PROTECTED] writes: I've been trying to figure a few things lately but I could not so I'm asking on the list. I need to programmatically (through JDBC): 1. Figure out if the currently logged in user can create a schema 2. Figure out if a role

[ADMIN] log connections to database

2006-04-04 Thread Ben K.
Sorry if these are basic questions. It's postgres 8.1 on unix. 1. logging to database I'd like to log connection authentication info into one of the databases, (it's ok to be on the same server as production server), but the logging configuration in postgresql.conf doesn't seem to cover this

Re: [ADMIN] pg_stat_activity showing non-existent processes

2006-04-04 Thread Tom Lane
Lane Van Ingen [EMAIL PROTECTED] writes: Don't understand the 'target machine' message, either; in this case, we are running the application and the database server on the same box. 2006-04-04 03:12:05 FATAL: could not read from statistics collector pipe: No error 2006-04-04 03:12:06 FATAL:

Re: [ADMIN] log connections to database

2006-04-04 Thread Alvaro Herrera
Ben K. wrote: 3. dropping a role If the user is not the owner of the object, is the following an intended behavior, or could it be some misconfiguration on my side? (In fact this seems to give me the list of objects the user has acl on.) create group ddd; grant all on atable to ddd;

Re: [ADMIN] pg_stat_activity showing non-existent processes

2006-04-04 Thread Lane Van Ingen
Perhaps I might be able to help you track this problem down, but I could use some help. The limited amount of discussion on this I Googled up didn't help. We have never seen these messages before; we are assuming that their appearance now (we have been running OK since last August) is related to

[ADMIN] PITR Based replication ...

2006-04-04 Thread Marc G. Fournier
I know ppl are using it to do replication, but has anyone documented what is involved in doing so? thanks ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664

Re: [ADMIN] PITR Based replication ...

2006-04-04 Thread Thomas F. O'Connell
On Apr 4, 2006, at 4:05 PM, Marc G. Fournier wrote: I know ppl are using it to do replication, but has anyone documented what is involved in doing so? thanks ... I'll be curious to hear stories of people using it for replication. The way I interpret replication, there's an available

Re: [ADMIN] PITR Based replication ...

2006-04-04 Thread Jeff Frost
On Tue, 4 Apr 2006, Thomas F. O'Connell wrote: On Apr 4, 2006, at 4:05 PM, Marc G. Fournier wrote: I'll be curious to hear stories of people using it for replication. The way I interpret replication, there's an available database (even if read-only) on both ends. With PITR/on-line backups,