Re: [ADMIN] Creating users in a second postgres server.

2003-11-05 Thread Oli Sennhauser
Hello Stephen I am actually working on a concept for this problems: Many clusters with different versions on a server: It consists off 3 docs and some skripts: * Optimal Flexible Architecture (OFA) for PostgreSQL * Flexible Environment for PostgreSQL in a Multi-Cluster-Multi-Database (MCMD) syste

Re: [ADMIN] Creating users in a second postgres server.

2003-11-05 Thread skennedy
Bang on Tom. As you can see from the snippet of my mail below, I had it pg_port. Oh well, make distclean again I suppose Thanks. Tom Lane wrote: "skennedy" <[EMAIL PROTECTED]> writes: If I configured the server to user 5433 before building (using --with-pg_port=5433 in configure) shouldn't

Re: [ADMIN] Creating users in a second postgres server.

2003-11-05 Thread Tom Lane
"skennedy" <[EMAIL PROTECTED]> writes: > If I configured the server to user 5433 before building (using > --with-pg_port=5433 in configure) shouldn't the clients, etc > automatically look for port 5433? They should, and they do for me (I routinely run several different versions of PG on different

Re: [ADMIN] Creating users in a second postgres server.

2003-11-05 Thread skennedy
Thanks Tom, PGPORT was unset in the environment. I set it to 5433 and things started to work. If I configured the server to user 5433 before building (using --with-pg_port=5433 in configure) shouldn't the clients, etc automatically look for port 5433? The executables ARE the ones I compiled

Re: [ADMIN] Creating users in a second postgres server.

2003-11-05 Thread Tom Lane
"skennedy" <[EMAIL PROTECTED]> writes: > however, when I try and create a user I get > bash-2.03$ createuser idip_734 > Shall the new user be allowed to create databases? (y/n) y > Shall the new user be allowed to create more new users? (y/n) n > psql: FATAL 1: user "p_sql734" does not exist Loo

[ADMIN] Creating users in a second postgres server.

2003-11-05 Thread skennedy
Hi.. I have a Solaris 2.8 machine on which I have Postgresql 7.2.4 postgres listening on port 5432. This works fine. I have a user who needs a newer version and has asked specifically for 7.3. I have compiled and installed a 7.3.4 successfully, using ./configure --prefix=/usr/local/p_sql734 -

[ADMIN] CREATING USERS

2002-04-23 Thread Aaron Spiteri
I am having some trouble with a PL/SQL script I have been trying to write. The idea is that a table is created called user_table, This stores extra information about each user on the system. There is a link in the user_table called usename which links up to pg_shadow.username. I want to be

RE: [ADMIN] Creating Users

2001-08-21 Thread Peter Eisentraut
Miguel Gonzalez writes: > Could you be a bit more specific? Time to upgrade to what? PostgreSQL -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, pleas

Re: [ADMIN] Creating Users

2001-08-20 Thread Peter Eisentraut
Miguel Gonzalez writes: > I am developing a client application with C++ Builder 3 to access a > Database designed with PostgreSQL 7.0.4 using a BDE alias through the ODBC > driver. Time to upgrade. -- Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter -

[ADMIN] Creating Users

2001-08-20 Thread Miguel Gonzalez
dear all, I am developing a client application with C++ Builder 3 to access a Database designed with PostgreSQL 7.0.4 using a BDE alias through the ODBC driver. I would like to have a form where I can add users to my users table of my database and also create the corresponding entry to the pos

[ADMIN] Creating Users

2001-08-14 Thread iafmgc
dear all, I am developing a client application with C++ Builder 3 to access a Database designed with PostgreSQL 7.0.4 using a BDE alias through the ODBC driver. I would like to have a form where I can add users to my users table of my database and also create the corresponding entry to the pos