Re: [ADMIN] [pgsql-admin] JCR (Apache Jackrabbit) locking when using Postgres, not with MySQL

2012-09-03 Thread Gary Webster
On Wed, Aug 29, 2012 at 10:17 PM, Craig Ringer ring...@ringerc.id.auwrote: On 08/30/2012 03:37 AM, Gary Webster wrote: Hello. The subject says most of what I know at this point. We are still not getting along with Apache Jackrabbit. After a few hours of using Postgres as the Persistence

Re: [ADMIN] [pgsql-admin] JCR (Apache Jackrabbit) locking when using Postgres, not with MySQL

2012-09-03 Thread Gary Webster
On Thu, Aug 30, 2012 at 3:33 AM, Albe Laurenz laurenz.a...@wien.gv.atwrote: Gary Webster wrote: The subject says most of what I know at this point. We are still not getting along with Apache Jackrabbit. After a few hours of using Postgres as the Persistence Manager, the JCR gets stuck,

[ADMIN] [pgsql-admin] JCR (Apache Jackrabbit) locking when using Postgres, not with MySQL

2012-08-29 Thread Gary Webster
Hello. The subject says most of what I know at this point. We are still not getting along with Apache Jackrabbit. After a few hours of using Postgres as the Persistence Manager, the JCR gets stuck, apparently on a simple DB update statement. This problem does not occur at all if we substitute

Re: [ADMIN] [pgsql-admin] Daily digest v1.3327 (2 messages)

2010-09-25 Thread Justin Pitts
-- Forwarded message -- So, you have everything running and working in aprox. 10 seconds. All of the Windows Server stuff via Microsoft Cluster Services I'm aware of does its shared storage node fencing via sending specific SCSI calls (PERSISTENT RESERVE) to the storage. 

Re: [ADMIN] [pgsql-admin] Daily digest v1.3217 (11 messages)

2010-05-12 Thread Christophe Dore
Hi A hint : do you have any long running SQL requests, while there is some network-control devices like firewalls between the client and the server ? Using Oracle, we faced the same situation where a firewall in the middle broke the connection after a period of network inactivity between the

[ADMIN] [pgsql-admin] Simple question about security in 8.1.1

2006-01-22 Thread Dan Bikle
People, I just installed postgreSQL 8.1.1 on my free-bsd box: Creation of a database is easy: bash-2.05b$ id uid=70(pgsql) gid=70(pgsql) groups=70(pgsql) bash-2.05b$ createdb -O pgsql db10 CREATE DATABASE bash-2.05b$ I took a peek at help: bash-2.05b$ psql --help This is psql 8.1.1, the

Re: [ADMIN] [pgsql-admin] Simple question about security in 8.1.1

2006-01-22 Thread Stephan Szabo
On Sun, 22 Jan 2006, Dan Bikle wrote: I'm allowed to connect to the db10 database without authentication!: bash-2.05b$ psql db10 scott Welcome to psql 8.1.1, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for

[ADMIN] pgsql-admin

2004-01-08 Thread kandiah ratnavale
please forward 2004-01:[by date] [by thread] 2003-12:[by date] [by thread] many thanks ratnavale ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send

[ADMIN] pgsql-admin list should now be working ...

2000-10-29 Thread The Hermit Hacker
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org

[ADMIN] pgsql-admin: disallowing CREATE TABLE

2000-03-23 Thread Keith Dreibelbis
Hello, I want to make a user that has read-only access to a database. I've read the man pages on grant and revoke for table-level permissions, but I don't see anything for database-level permissions on, say, creating tables or views. Suppose I want to deny CREATE to some user. How does

Re: [ADMIN] pgsql-admin: disallowing CREATE TABLE

2000-03-23 Thread Thomas Dean
If I understand your question correctly, createuser will do this. 'man createuser' ... -D Does not allow the user to create databases.