[ADMIN] Having problem with postgresql configuration (template1 doesn't exist)?

2005-02-20 Thread Vinicius
Hello, I'm having problem with the configuration of postgresql. Can anybody help me, please? I did do the followings steps as explained in the section "16.2. Creating a Database Cluster" of the "PostgreSQL 7.4.7 Documentation": "root# mkdir /usr/local/pgsql/data root# chown postgres /usr/local/

Re: [ADMIN] Having problem with postgresql configuration (template1 doesn't exist)?

2005-02-20 Thread Tom Lane
Vinicius <[EMAIL PROTECTED]> writes: > postgres$ initdb -D /usr/local/pgsql/data" > the file /var/log/messages shows: > "Feb 20 02:01:38 ronin kernel: audit(1108875698.227:0): avc: denied { > write } for pid=8229 exe=/usr/bin/postgres name=data > dev=dm-0 ino=1687533 scontext=user_u:system_r:p

Re: [ADMIN] Having problem with postgresql configuration (template1 doesn't

2005-02-20 Thread Vinicius
Tom Lane escreveu: Vinicius <[EMAIL PROTECTED]> writes: postgres$ initdb -D /usr/local/pgsql/data" the file /var/log/messages shows: "Feb 20 02:01:38 ronin kernel: audit(1108875698.227:0): avc: denied { write } for pid=8229 exe=/usr/bin/postgres name=data dev=dm-0 ino=1687533 scontext=user_u:s

Re: [ADMIN] Having problem with postgresql configuration (template1 doesn't

2005-02-20 Thread Tom Lane
Vinicius <[EMAIL PROTECTED]> writes: > I tryed to create another data dir because I don't have the template1 > database. I think you got bit by one of the early-FC3 selinux policy bugs; see https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=142607 https://bugzilla.redhat.com/bugzilla/show_bug.c

Re: [ADMIN] Postgres crashed on invalid IP entry in pg_hba.conf

2005-02-20 Thread Bruce Momjian
Pallav Kalva wrote: > I am using 7.4.2 on Redhat 9 Linux 2.4. I know iam on old version, we > are actually planning to move to 8.0.1 soon, I just wanted to know if > this is bug if so if it is 7.4.2 related . You just need to stop your server, install 7.4.7 and restart. There is no reason to b

Re: [ADMIN] [SQL] Trigger

2005-02-20 Thread Eugen Gass
Hi, Thank you ALL for the fast help it works fine with following code: CREATE OR REPLACE FUNCTION synchronize () RETURNS trigger AS 'BEGIN NEW.objectid := NEW.gid; RETURN NEW; END;' LANGUAGE plpgsql; CREATE TRIGGER syncl_holz_lager AFTER INSERT ON holz_lagerplatz FOR EACH ROW EXECUTE PROCEDURE

[ADMIN] Access Permissions to Users

2005-02-20 Thread ganapatiram
Hi Experts,     I am using Postgresql 8.0 windows version. I am using this in the server as well as clients with the same access permissions to users as i am not aware how to set-up the access permissions for other users seperating super user.               If i want to give only vie

[ADMIN] PostgreSQL Errors...

2005-02-20 Thread Chari Clark
I created the following statement: CREATE TYPE get_item_info_type AS (full_name varchar(300),dob varchar(300)); CREATE OR REPLACE FUNCTION sp_items(int8) RETURNS get_item_info_type AS ' DECLARE in_id items.item_no%TYPE; BEGIN select coalesce(full_name, '') as f

[ADMIN] ODBC driver version

2005-02-20 Thread Insyde
Hello.   I'm using PostgreSQL 7.4 in one server. But recently I installed version 8.0 in my machine for testing. The ODBC driver installed was the version 8.0 too, and now, some applications using ODBC to create tables in server (7.4) version doesn't work.   Questions:   - Can 8.0 version of

Re: [ADMIN] Access Permissions to Users

2005-02-20 Thread John DeSoi
On Feb 17, 2005, at 6:15 AM, ganapatiram wrote:   I am using Postgresql 8.0 windows version. I am using this in the server as well as clients with the same access permissions to users as i am not aware how to set-up the access permissions for other users seperating super user.          

Re: [ADMIN] PostgreSQL Errors...

2005-02-20 Thread Iain
Hi, try doing it this way and work from there: select sp_items('850001'); regards Iain - Original Message - From: "Chari Clark" <[EMAIL PROTECTED]> To: ; <[EMAIL PROTECTED]> Sent: Friday, February 18, 2005 5:25 AM Subject: [ADMIN] PostgreSQL Errors... I created the following stat