![](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 ==============================================================