[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

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 Looks to me

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: 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 ports

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)

[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,

[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

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-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