Обсуждение: Help Postgresql to start on Suse 10.2
Dear, I am thinking to shift my software Axbo7.1 (see http://axbo.co.in/ ) to postgresql from mysql. I have Suse 10.2 operating system in my organization.I install version 8.1.5-13 successfuly. but when I start server as------------> pg_ctl start -D /var/lib/pgsql/data then error is-----------------> postmaster started. Could not open directory "base" No such file or directory. If you can't help then give any of address from whom I can get help. MOnalee Bhandge. Database Administrator. Sungrace Infotech. ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
On Mon, Apr 21, 2008 at 3:18 AM, Monalee Bhandge <monalee_b@yahoo.com> wrote: > Dear, > I am thinking to shift my software Axbo7.1 (see > http://axbo.co.in/ ) > to postgresql from mysql. > I have Suse 10.2 operating system in my organization.I > install version 8.1.5-13 successfuly. > but when I start server as------------> > pg_ctl start -D /var/lib/pgsql/data > then error is-----------------> > postmaster started. > Could not open directory "base" No such file or > directory. It's been a few years since I've used SUSE, but I'm guessing that you need to start it as a service from a file in the /etc/init.d directory, or something like that. Note that 8.1.5 is a bit out of date, but I don't know if SUSE backports bug fixes to earlier versions or releases whole new versions. 8.1.x is up to 8.1.11 now, so you should look at updating to that version while you're doing all this. If you must start it by hand, then use initdb -D /var/lib/pgsql/data first to initialize the db.
The Postgresql version which comes with Suse 10.2 actually is 8.2.6. If there is no reason to downgrade I would recommend to use 8.2.6 or at least the latest from the 8.1.x version which is 8.1.11 actually. You did not write what package exactly you installed, but I assume it is not a Suse RPM. So you most probably have to initdb first. See chapter 16.2 of the usermanual about details. If you use the Suse RPM install and start the server with the script under /etc/rc.d the system would take care doing the initdb for you. Best regards Ivo Am Montag, 21. April 2008 11.18:59 schrieb Monalee Bhandge: > Dear, > I am thinking to shift my software Axbo7.1 (see > http://axbo.co.in/ ) > to postgresql from mysql. > I have Suse 10.2 operating system in my organization.I > install version 8.1.5-13 successfuly. > but when I start server as------------> > pg_ctl start -D /var/lib/pgsql/data > then error is-----------------> > postmaster started. > Could not open directory "base" No such file or > directory. > > If you can't help then give any of address from whom I > can get help. > > MOnalee Bhandge. > Database Administrator. > Sungrace Infotech. > > > > > > ___________________________________________________________________________ >_________ Be a better friend, newshound, and > know-it-all with Yahoo! Mobile. Try it now. > http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
On Montag, 21. April 2008 Monalee Bhandge wrote: > I have Suse 10.2 rcpostgresql start or /etc/init.d/postgresql start If you need to configure it, edit /etc/sysconfig/postgresql mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0676/846 914 666 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: www.keyserver.net Key-ID: 1C1209B4
Вложения
Please keep responses on the list, I might not be able to get right back to you, but someone else might... :) On Tue, Apr 22, 2008 at 3:50 AM, Monalee Bhandge <monalee_b@yahoo.com> wrote: > Thanks for reply, > Now my postgre server is running but as a client I > can't connect to it. > I apply all the commands. Most of the time this is because of the pg_hba.conf file. http://www.postgresql.org/docs/8.1/interactive/client-authentication.html