![](https://seccdn.libravatar.org/avatar/bfbfb6ec18c46d7c5deb8753d4dd5ee7.jpg?s=120&d=mm&r=g)
Having a hell of a time finding readable documentation for postgresql install from SuSE 8.0 cdrom. Got it installed and started, but that is it. Can someone point me in the direction of the adminstrators guide so I can setup a user etc. so that I can use it? Art
![](https://seccdn.libravatar.org/avatar/0724cd2fec38c7b6f662bb7fda14c68c.jpg?s=120&d=mm&r=g)
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On January 26, 2003 02:47 am, Art Fore wrote:
Having a hell of a time finding readable documentation for postgresql install from SuSE 8.0 cdrom.
Documentation is installed with the package, take a look at /usr/share/doc/packages/postgresql/html Charles -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+M5e53epPyyKbwPYRAu3UAJ9B/Vv3psCRGvTENHBX93oXIuQdXQCgzQP9 oPeusprzaHzAWGGbSjbdLQI= =6ceo -----END PGP SIGNATURE-----
![](https://seccdn.libravatar.org/avatar/bfbfb6ec18c46d7c5deb8753d4dd5ee7.jpg?s=120&d=mm&r=g)
On Sun, 2003-01-26 at 00:09, Charles Philip Chan wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On January 26, 2003 02:47 am, Art Fore wrote:
Having a hell of a time finding readable documentation for postgresql install from SuSE 8.0 cdrom.
Documentation is installed with the package, take a look at /usr/share/doc/packages/postgresql/html
Charles
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE+M5e53epPyyKbwPYRAu3UAJ9B/Vv3psCRGvTENHBX93oXIuQdXQCgzQP9 oPeusprzaHzAWGGbSjbdLQI= =6ceo -----END PGP SIGNATURE-----
Found the documentation, went through it, created a database, started postmaster, but cannot get access to the database as user, I get permission denied. Supposedly the user should have access, but no such luck. Also, files are not where the documentation says they should be. If anyone has gotten postgresql to working on SuSE 8.0, I would appreciate some help. Art
![](https://seccdn.libravatar.org/avatar/eb285856d0e2555b263c3583d0abf430.jpg?s=120&d=mm&r=g)
Art Fore wrote:
Found the documentation, went through it, created a database, started postmaster, but cannot get access to the database as user, I get permission denied. Supposedly the user should have access, but no such luck. Also, files are not where the documentation says they should be.
First of all you need to make yourself a Postgres user. You have to be user "postgres" to do this, which is best done in a roundabout way: 1) log in as root 2) type "su - postgres" (you now become user "postgres") 3) Start the SQL monitor with the command "psql template1" (template1 is the test database supplied when you install) 4) Now you can create a user. Type "\h create user" to see the help for creating a new user. Pay special attention to the options "CREATEDB" and "CREATEUSER". You can get general help on the "backslash" commands by typing "\?". 5) If you want to have remote access to the database using the C libraries or the Java JDBC driver over TCP/IP, make sure you are starting postmaster with the "-i" option. In SuSE 8.1, this is done by setting POSTGRES_OPTIONS="-i" in /etc/sysconfig/postgresql. You will also want to have a look at /var/lib/pgsql/data/pg_hba.conf. HTH, if you need more information you can always schlep yourself over to: http://www.postgresql.org/ Their mailing lists are especially helpful. -- ============================================================== Glenn Holmer (Linux registered user #16682) -------------------------------------------------------------- If you make a small change to a program, it can result in an enormous change in what the program does. If nature worked that way, the universe would crash all the time. -------------------------------------------------------------- -Jaron Lanier ==============================================================
![](https://seccdn.libravatar.org/avatar/bfbfb6ec18c46d7c5deb8753d4dd5ee7.jpg?s=120&d=mm&r=g)
when I enter psql template1 I get could not connect to server: No such file or directory is the server running locally and accepting connection on Unix domain socket "tmp/.s.PSQL.5432"? I am trying to run this on localhost. I had it running at one time, but it quit. I uninstalled and reinstalled, and still cannot even rcpostgresql start. I get Initializing the Postgresql database at location /var/lib/pgsql/data failed. You can find a log of the initialisation in "postgres/initlog. Have no idea where this log is. There is an initlog in /var/lib/pgsql but that has no information. There was a config file before that I changed for the host, etc., but can't find it again. Is the a step by step procedure for creating a SIMPLE database to access from the local machine somewhere? I am trying to use Rekall with it, but since I can't even get the server going, I get nothing. Art On Sun, 2003-01-26 at 12:24, Glenn Holmer wrote:
Art Fore wrote:
Found the documentation, went through it, created a database, started postmaster, but cannot get access to the database as user, I get permission denied. Supposedly the user should have access, but no such luck. Also, files are not where the documentation says they should be.
First of all you need to make yourself a Postgres user. You have to be user "postgres" to do this, which is best done in a roundabout way: 1) log in as root 2) type "su - postgres" (you now become user "postgres") 3) Start the SQL monitor with the command "psql template1" (template1 is the test database supplied when you install) 4) Now you can create a user. Type "\h create user" to see the help for creating a new user. Pay special attention to the options "CREATEDB" and "CREATEUSER". You can get general help on the "backslash" commands by typing "\?". 5) If you want to have remote access to the database using the C libraries or the Java JDBC driver over TCP/IP, make sure you are starting postmaster with the "-i" option. In SuSE 8.1, this is done by setting POSTGRES_OPTIONS="-i" in /etc/sysconfig/postgresql. You will also want to have a look at /var/lib/pgsql/data/pg_hba.conf.
HTH, if you need more information you can always schlep yourself over to:
Their mailing lists are especially helpful.
-- ============================================================== Glenn Holmer (Linux registered user #16682) -------------------------------------------------------------- If you make a small change to a program, it can result in an enormous change in what the program does. If nature worked that way, the universe would crash all the time. -------------------------------------------------------------- -Jaron Lanier ==============================================================
![](https://seccdn.libravatar.org/avatar/eb285856d0e2555b263c3583d0abf430.jpg?s=120&d=mm&r=g)
Art Fore wrote:
when I enter psql template1 I get could not connect to server: No such file or directory is the server running locally and accepting connection on Unix domain socket "tmp/.s.PSQL.5432"?
See my previous post about the "-i" option, this is the most common error people make.
I am trying to run this on localhost. I had it running at one time, but it quit. I uninstalled and reinstalled, and still cannot even rcpostgresql start. I get Initializing the Postgresql database at location /var/lib/pgsql/data failed. You can find a log of the initialisation in "postgres/initlog. Have no idea where this log is. There is an initlog in /var/lib/pgsql but that has no information.
/var/log/postgresql
There was a config file before that I changed for the host, etc., but can't find it again.
/var/lib/pgsql/data/pg_hba.conf For simplest usage (no security), change the host line like this: local all trust #host all 127.0.0.1 255.255.255.255 trust host all 0.0.0.0 0.0.0.0 trust -- ============================================================== Glenn Holmer (Linux registered user #16682) -------------------------------------------------------------- If you make a small change to a program, it can result in an enormous change in what the program does. If nature worked that way, the universe would crash all the time. -------------------------------------------------------------- -Jaron Lanier ==============================================================
![](https://seccdn.libravatar.org/avatar/0724cd2fec38c7b6f662bb7fda14c68c.jpg?s=120&d=mm&r=g)
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On January 26, 2003 12:01 pm, Art Fore wrote:
Found the documentation, went through it, created a database, started postmaster, but cannot get access to the database as user, I get permission denied. Supposedly the user should have access, but no such luck. Also, files are not where the documentation says they should be.
First off does you create the users in pqsql? If you did, did you terminate it with /g (or else the user woulden't be created)? The config files for postgres is in /var/lib/pgsql/data, please go through them. Also, It seem like some clients insists on using TCP/IP for connection rather than Unix sockets, so you should turn that on. Also, I find that doing a rcpostgresql restart after changing the config file doesn't work, while rcpostgresql stop; rcpostgresql start does. Charles -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+NEed3epPyyKbwPYRAmunAKCNvIGBiGtBFYvGkG/BJExThSN89gCbBOiV SIg/dT34S6pQVfmduwfJT7s= =gSZ4 -----END PGP SIGNATURE-----
![](https://seccdn.libravatar.org/avatar/0724cd2fec38c7b6f662bb7fda14c68c.jpg?s=120&d=mm&r=g)
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On January 26, 2003 03:39 pm, Charles Philip Chan wrote:
First off does you create the users in pqsql?
Sorry, typed too fast. the program name is actually psql. Charles -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+NEqV3epPyyKbwPYRAlDwAJ0YnR0GAem9gQOqYJn/nEb3imYniQCfTiYh DtNXbBBFO+/MbNfP7gyVXYQ= =cXCk -----END PGP SIGNATURE-----
participants (3)
-
Art Fore
-
Charles Philip Chan
-
Glenn Holmer