Re: [ADMIN] REVOKE from all tables ...

2005-08-08 Thread Marc G. Fournier
On Mon, 8 Aug 2005, Joshua D. Drake wrote: Marc G. Fournier wrote: Is there a way of REVOKEing privileges on all tables in a database? I've checked the REVOKE man page, and there doesn't appear to be, but I figured I'd double check to make sure ... No. This has actually been a requested

Re: [ADMIN] REVOKE from all tables ...

2005-08-08 Thread Joshua D. Drake
Marc G. Fournier wrote: Is there a way of REVOKEing privileges on all tables in a database? I've checked the REVOKE man page, and there doesn't appear to be, but I figured I'd double check to make sure ... No. This has actually been a requested feature on the grant side as well... Nothing

[ADMIN] REVOKE from all tables ...

2005-08-08 Thread Marc G. Fournier
Is there a way of REVOKEing privileges on all tables in a database? I've checked the REVOKE man page, and there doesn't appear to be, but I figured I'd double check to make sure ... ---(end of broadcast)--- TIP 9: In versions below 8.0, the pla

Re: [ADMIN] [GENERAL] postgresql Secure Mode

2005-08-08 Thread Alvaro Herrera
On Mon, Aug 08, 2005 at 12:40:24PM -0400, Alvaro Herrera wrote: > On Mon, Aug 08, 2005 at 12:24:14PM -0400, Mario Soto Cordones - Venezuela > wrote: > > 2005/8/8, Alvaro Herrera <[EMAIL PROTECTED]>: > > > > > Yeah, the server thinks it's active, but the client doesn't know it. > > > Did you try co

Re: [ADMIN] Trouble Getting Database Server Started

2005-08-08 Thread Karim Mardhani
Hi Dirk: I have been seeing similar problems if PC pwered down rather than using the Windows shut down facility. In my case the user which suppose to start the service loses "Logon as service" right therefore service can not be started. On your computer A, check to see if the database serv

[ADMIN] Trouble Getting Database Server Started

2005-08-08 Thread Dirk Kalp
Trouble Getting Database Server Started   I'm no longer able to connect to the database with psql. PostgreSQL 8.0.0 was included as part of a software package I'm using to collect environmental data. It is a very simple logging application - mostly a single simple table with timestamp and 6

Re: [ADMIN] Restore from pg_dumpall

2005-08-08 Thread Jeff Frost
On Mon, 8 Aug 2005, Buorn, Yoway wrote: Unfortunately, I don't have the dump and restore in my buffer, but I ran "pg_dumpall > backup.dump" and then I tried to upgrade Gforge and I got errors, so I freaked out and decided to restore before trying again. I then ran "pg_restore -c backup.dump" an

Re: [ADMIN] Restore from pg_dumpall

2005-08-08 Thread Buorn, Yoway
>From: Jeff Frost [mailto:[EMAIL PROTECTED] >What are you upgrading from/to? Can you share your dump and restore command line as well? I am upgrading from Gforge 3.0b1 to Gforge 4.5.0.1. Unfortunately, I don't have the dump and restore in my buffer, but I ran "pg_dumpall > backup.dump" and then

Re: [ADMIN] [GENERAL] postgresql Secure Mode

2005-08-08 Thread Alvaro Herrera
On Mon, Aug 08, 2005 at 01:03:03PM -0400, Mario Soto Cordones - Venezuela wrote: > from the server I connect with psql and makes it > > bash-3.00$ psql -U vasa -h 192.168.0.2 vasa > Contraseña: > Bienvenido a psql 8.0.3, el terminal interactivo de PostgreSQL. > > Digite: \copyright para ver

Re: [ADMIN] [GENERAL] postgresql Secure Mode

2005-08-08 Thread Alvaro Herrera
On Mon, Aug 08, 2005 at 12:24:14PM -0400, Mario Soto Cordones - Venezuela wrote: > 2005/8/8, Alvaro Herrera <[EMAIL PROTECTED]>: > > On Mon, Aug 08, 2005 at 11:41:24AM -0400, Mario Soto Cordones - Venezuela > > wrote: > > > LOG Say: > > > > > > LOG: conexión recibida: host=192.168.0.100 port=117

Re: [ADMIN] [GENERAL] postgresql Secure Mode

2005-08-08 Thread Mario Soto Cordones - Venezuela
2005/8/8, Alvaro Herrera <[EMAIL PROTECTED]>: > On Mon, Aug 08, 2005 at 11:41:24AM -0400, Mario Soto Cordones - Venezuela > wrote: > > LOG Say: > > > > LOG: conexión recibida: host=192.168.0.100 port=1175 > > FATAL: no hay una línea en pg_hba.conf para «192.168.0.100», > > usuario «vasa»,

Re: [ADMIN] [GENERAL] postgresql Secure Mode

2005-08-08 Thread Alvaro Herrera
On Mon, Aug 08, 2005 at 11:41:24AM -0400, Mario Soto Cordones - Venezuela wrote: > LOG Say: > > LOG: conexión recibida: host=192.168.0.100 port=1175 > FATAL: no hay una línea en pg_hba.conf para «192.168.0.100», > usuario «vasa», base de datos «vasa», SSL inactivo > LOG: conexión recib

Re: [ADMIN] [GENERAL] postgresql Secure Mode

2005-08-08 Thread Tom Lane
Mario Soto Cordones - Venezuela <[EMAIL PROTECTED]> writes: > LOG Say: > LOG: conexión recibida: host=192.168.0.100 port=1175 > FATAL: no hay una línea en pg_hba.conf para «192.168.0.100», > usuario «vasa», base de datos «vasa», SSL inactivo > LOG: conexión recibida: host=192.168.0.100

Re: [ADMIN] [GENERAL] postgresql Secure Mode

2005-08-08 Thread Mario Soto Cordones - Venezuela
LOG Say: LOG: conexión recibida: host=192.168.0.100 port=1175 FATAL: no hay una línea en pg_hba.conf para «192.168.0.100», usuario «vasa», base de datos «vasa», SSL inactivo LOG: conexión recibida: host=192.168.0.100 port=1226 FATAL: no hay una línea en pg_hba.conf para «192.168.0.1