Mailinglist Archive: opensuse (4288 mails)

[Alexander Klayman <aklayman@xxxxxxxxxxxxxx>]

Ok, pgaccess is using unix socket directories.
edit /var/lib/postgresql/data/postgresql.conf as root and uncomment/set these 
parameters:

unix_socket_directory = '/tmp'
unix_socket_group = ''
unix_socket_permissions = 0777



On Thursday 16 May 2002 22:46, Alexander Klayman wrote:
> I have been batteling with the same problem.  I got psql working, but
> pgaccess still can't connect.  Making changes to postgresql.conf to allow
> postmaster to listen on tcpip and setting the port to 5432 does not seem to
> have the desired effect.  If someone did get it to work or knows what the
> problem is, please let us know.
>
> On Thursday 16 May 2002 19:57, Tor Sigurdsson wrote:
> > On Thu, 2002-05-16 at 16:26, Alberto García Fumero wrote:
> > > Hi y'all!
> > > I have just installed PostgreSQL on this SuSE 7.3. But I can not use
> > > it. As I installed insung YAST2, I assume that the right variables are
> > > set correctly. At least that was what YAST2 said ;-))
> > > I  admit I know almost nothing of it.
> > > I tried to launch pgaccess as a simple user to begin with, but the
> > > error (horror) message I get when I try to create a database is:
> > > "Error TCL en la ejecutando pg_exec create database nameofdatabase
> > > Is not a valid postgresql connection"
> > > Trying to understand (I hope) the instruction from some papers I got, I
> > > logged as user postgres and launched:
> > > initdb --pglib=/usr/lib/pgsql --pgdata=/var/lib/pgsql
> > >
> > > and this time the error message was:
> > >
> > > initdb: invalid option: --pglib=/usr/lib/pgsql
> > > Try 'initdb --help' for more information.
> > >
> > > So I forgot all about pglib and tried:
> > >
> > > postgres@fumero:/home/alberto> initdb  --pgdata=/var/lib/pgsql
> > > This database system will be initialized with username "postgres".
> > > This user will own all the data files and must also own the server
> > > process.
> > >
> > > initdb: The directory /var/lib/pgsql exists but is not empty.
> > > If you want to create a new database system, either remove or empty
> > > the directory /var/lib/pgsql or run initdb with
> > > an argument other than /var/lib/pgsql.
> >
> > You used the correct parameters. As the pgdata directory is aleady
> > populated, I assume that the base is already installed.
> >
> > Check for the postgresql status with:
> >
> > 	/etc/init.d/postgresql status
> >
> > If you get "running", then you are already running the database.
> >
> > The next step is to create users and databases for the users to use:
> >
> > 	postgres@fumero:/ > createuser alberto
> > 	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
> > 	CREATE USER
> > 	postgres@fumero:/ > exit
> > 	alberto@fumero:~ > createdb alberto
> > 	CREATE DATABASE
> > 	alberto@fumero:~ > psql
> > 	Welcome to psql, the PostgreSQL interactive terminal.
> >
> > 	Type:  \copyright for distribution terms
> > 	       \h for help with SQL commands
> > 	       \? for help on internal slash commands
> > 	       \g or terminate with semicolon to execute query
> > 	       \q to quit
> >
> > 	alberto=>
> >
> > Now your'e connected to the database 'alberto' as user 'alberto'.
> >
> > Further documentation on how to create tables, access your data,
> > datatypes and query design etc can be found in Bruce Momjians excellent
> > book 'PostgreSQL', which can be read at http://www.postgresql.org in the
> > documentation section, and can be bought in dead-tree form, ISBN
> > 0-201-70331-9
> >
> > -tosi
> >
> > > How should I interpret this?
> > > TIA,
> > > --
> > > MSc. Alberto García Fumero
> > > Centro de Información para la Educación
> > > Ministerio de Educación
> > > Usuario Linux No. 97 138
> > > ¿Windows? No, gracias!
> > >
> > > --
> > > To unsubscribe send e-mail to suse-linux-e-unsubscribe@xxxxxxxx
> > > For additional commands send e-mail to suse-linux-e-help@xxxxxxxx
> > > Also check the archives at http://lists.suse.com