Also, depending on _how_ postgres is started, it may or may not connect to the right database. It is quite common to start postgres from init scripts in /etc/init.d which pass explicit parameters to postgres where it should look for it's databases. Make sure you start and stop it with the same parameters as when you created the dataset.
Marius K. David Ratte wrote: > Are you sure postgres is actually running on your machine / and you have=20 > permissions to use it? > > does 'psql template1' return an error?? > > On Monday 21 October 2002 05:48 pm, Hugh Esco wrote: > >>Thank you for your help. I appreciate the response. I have tried usin= > > g > >>both the password and the dbpasswd for the postgres user to create the >>Dataset. Both options give me a "could not connect to server: No such = > > file > >>or directory" error. Any other ideas of what I may be doing wrong? >> >>Since I am connecting from another machine on my network, I am using ho= > > st: > >>192.168.2.10 and port: 5432 (which is where I understand that postgreSQ= > > L > >>listens at). I get the same error when I connect from localhost, as we= > > ll, > >>without specifying a hostname and port number. Is it necessary to spec= > > ify > >>a port number given that the perl script which invokes the connection a= > > nd > >>the SQL server reside on the same machine? >> >>-- Hugh Esco >> >>At 01:14 PM 10/21/02 -0600, you wrote: >> >>>No, the two passwords are for different things. One is to login to SL,= > > the > >>>other is for the db user to login to the SQL server. >>> >>>Dieter Simader http://www.sql-ledger.org (780) 472-8161 >>>DWS Systems Inc. Accounting Software Fax: 478-5281 >>>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D On a clear disk you can seek forever= > > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > >>>On Sat, 19 Oct 2002, Hugh Esco wrote: >>> >>>> From the page entitled: SQL-Ledger Accounting / Database >>>>Administration, >>>> >>>>I get the following error: >>>> >>>>>Error! >>>>>could not connect to server: No such file or directory >>>> >>>>When I attempt to Create Dataset. >>>> >>>>I have apparently created three users in my efforts to get past thi= > > s > >>>>step in the installation: SQL-Ledger_Owner, postgres and hesco. I >>>>have tried every possible combination of userIDs and passwords. >>>> >>>>I am confused about why the user/members file contains both a dbpas= > > swd > >>>>and a password. What is the significance of these two fields? I >>>>recognize the dbpasswd for the two users I set up. Is the other on= > > e an > >>>>encrypted version of the first? Or is that a plain text rendering = > > of > >>>>what I would need to enter to authenticate? Which of these gets us= > > ed > >>>>how and when? >>>> >>>>And what of that error I keep getting? How can I create my Dataset= > > , so > >>>>I can build a Chart of Accounts and start importing my legacy data = > > for > >>>>the testing and training? >>>> >>>>-- Hugh Esco > > > --=20 > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > David Ratte > Superior Circuit Technologies, Inc. > [EMAIL PROTECTED] > http://www.superiorcircuits.com > Tel 321-254-4201 x 204 > Fax 321-254-6192 > -- Mvh, Marius Kjeldahl
