Re: [ADMIN] unable to GRANT on sequence

On Fri, Jun 03, 2005 at 11:26:29AM -0500, woody wrote: > > I'm having trouble GRANTing access on sequences. I created a database > called 'asterisk' using the 'postgres' user. I then created 2 users > called 'asterisk' and 'asterisk_owner'. I created a schema called > 'asterisk' and GRANTed CREATE

Re: [ADMIN] Upgrade Data from 7.x.x to 8.x.x

"Patrick Brennan" <[EMAIL PROTECTED]> writes: > Hopefully a simple question. I have a copy of the data from an old > PostgreSQL installation (it's not a dump, it's a copy of the PGDATA > directory). I have two questions, is there a simple way for me to > determine the version of PostgreSQL tha

Re: [ADMIN] unable to GRANT on sequence

woody <[EMAIL PROTECTED]> writes: > ... When I log in as > 'asterisk', I can insert rows but I can't use the implied nextval(). It > says the relation does not exist. I'd bet this isn't a permissions problem at all, but a schema search path problem. Do you have different search paths for asteris

[ADMIN] dbmirror modifies pg_proc nextval/setval functions

Title: dbmirror modifies pg_proc nextval/setval functions Hi all, I'm trying out dbmirror  for postgres 8.0.3 and I ran into some problems that I traced back to the setup sql script the MirrorSetup.sql, the standard nextval and setval get renamed using the following: UPDATE pg_proc SET pron

[ADMIN] Upgrade Data from 7.x.x to 8.x.x

Hi there, Hopefully a simple question. I have a copy of the data from an old PostgreSQL installation (it's not a dump, it's a copy of the PGDATA directory). I have two questions, is there a simple way for me to determine the version of PostgreSQL that this data belongs to? Secondly, is ther

[ADMIN] Putting Transaction Logs and Data in separate directories

Hi all, We are in the process of upgrading our 7.4.6 instance of PG to 8.0.3 which includes putting the new instance on new hardware. The new hardware has two Raid 5 disks and one system disk and we were going to play around with putting the data directory and the transaction logs on separate dis

[ADMIN] RAID0 vs RAID1 vs RAID?

Hello all. I have a production postgresql 7.4.5 database on a HP Proliant ML330 G3 server, OS: SUSE SLES8, two SCSI disks in RAID1. I just cloned the same database (same data) on another server. It's another HP Proliant ML330 G3 with SUSE SLES8 on but it has the latest 7.4.x release (7.4.8)

Re: [ADMIN] unable to GRANT on sequence

I'm having trouble GRANTing access on sequences. I created a database called 'asterisk' using the 'postgres' user. I then created 2 users called 'asterisk' and 'asterisk_owner'. I created a schema called 'asterisk' and GRANTed CREATE, DROP, INSERT, UPDATE, DELETE on this schema to 'asterisk_owner'

[ADMIN] incompatible with server

hello everybody i'm a newbie in postgresql when i do this: # su - postgre $ /usr/local/pgsql/bin/postmaster -i -D /home/postgre/database i've got this: FATAL: database files are incompatible with server DETAIL: The data directory was initialized by postgresql version 7.3, which is not compatible

[ADMIN] Can you help me

Hi, I have older version for postgresql 7.2,I want upgread the version how to upgread postegresql 7.2 to postgresql 8.0 Can ypou help me, Please. regards Talal ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an approp