Обсуждение: two or more pg installations running as the same user

hey folks,

I am thinking about testing enviroment here, and gotta setup temporary instalation of postgres for that. More than one, because software operates on few different connections, to different databases.
I know I can do it under same user, just by changing PGDATA/PGPORT before initdb gets to run. But will it be safe otherwise ?


--
GJ

Hello,

I've defined the following function and get an syntac error whle compiling.
Whats the fault?

CREATE FUNCTION "myscheme"."authenticate" () RETURNS
"pg_catalog"."refcursor" AS
$body$
DECLARE
    curAccessRights refcursor;

BEGIN
    OPEN curAccessRights FOR
        SELECT * from myscheme."tblUsers";

    RETURN curAccessRights;
END;
$body$
LANGUAGE 'sql'

Regards Timo

am  Tue, dem 25.11.2008, um 12:41:32 +0100 mailte Timo Erbach folgendes:
> Hello,
>
> I've defined the following function and get an syntac error whle compiling.
> Whats the fault?
>
> CREATE FUNCTION "myscheme"."authenticate" () RETURNS
> "pg_catalog"."refcursor" AS
> $body$
> DECLARE
>    curAccessRights refcursor;
> ...
> $body$
> LANGUAGE 'sql'

You can't use declare in this language, use plpgsql instead.


Regards, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

Hi Andreas,

thank you!
I did install plpsql and now everything is fine.

Regards Timo

A. Kretschmer schrieb:
> am  Tue, dem 25.11.2008, um 12:41:32 +0100 mailte Timo Erbach folgendes:
>
>> Hello,
>>
>> I've defined the following function and get an syntac error whle compiling.
>> Whats the fault?
>>
>> CREATE FUNCTION "myscheme"."authenticate" () RETURNS
>> "pg_catalog"."refcursor" AS
>> $body$
>> DECLARE
>>    curAccessRights refcursor;
>> ...
>> $body$
>> LANGUAGE 'sql'
>>
>
> You can't use declare in this language, use plpgsql instead.
>
>
> Regards, Andreas
>

--
Filip Rembiałkowski

Filip Rembiałkowski wrote:
>
>
> 2008/11/25 Grzegorz Jaśkiewicz <gryzman@gmail.com
> <mailto:gryzman@gmail.com>>
>
>     hey folks,
>
>     I am thinking about testing enviroment here, and gotta setup
>     temporary instalation of postgres for that. More than one, because
>     software operates on few different connections, to different databases.
>     I know I can do it under same user, just by changing PGDATA/PGPORT
>     before initdb gets to run. But will it be safe otherwise ?
>
>
> yes, no problem with that. for me it was just:
>

Hello

Another method we use to run multiple postgresql clusters and multiple
versions on the same server is to install extra IPs on the server using
the same (default) port.

If you use this method, it is very important that you define the right
listen_addresses values and different unix_socket_directory values for
each cluster running on the same server.

We connect mostly via tcp/ip and not via sockets, this way the clients
do not have to remember the port running their databases.

Of course the initdb and start steps are the same as Filip has commented.

regards,
--
 Rafael Martinez, <r.m.guerrero@usit.uio.no>
 Center for Information Technology Services
 University of Oslo, Norway

 PGP Public Key: http://folk.uio.no/rafael/

Grzegorz Jas'kiewicz wrote:
> hey folks,
>
> I am thinking about testing enviroment here, and gotta setup temporary
> instalation of postgres for that. More than one, because software
> operates on few different connections, to different databases.
> I know I can do it under same user, just by changing PGDATA/PGPORT
> before initdb gets to run. But will it be safe otherwise ?

Yep.

If they are different versions of postgres (eg 8.2/8.3), make sure you
initdb with the right one :)

--
Postgresql & php tutorials
http://www.designmagick.com/

--
GJ

You know you don't need separate clusters (ie. installations) to have multiple databases?

Regards

Mikko

--
GJ