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
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
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
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 be
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
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
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
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.
Hi,
try doing it this way and work from there:
select sp_items('850001');
regards
Iain
- Original Message -
From: Chari Clark [EMAIL PROTECTED]
To: pgsql-admin@postgresql.org; [EMAIL PROTECTED]
Sent: Friday, February 18, 2005 5:25 AM
Subject: [ADMIN] PostgreSQL Errors...
I