Обсуждение: Help Postgresql to start on Suse 10.2

Поиск
Список
Период
Сортировка

Help Postgresql to start on Suse 10.2

От
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


Re: Help Postgresql to start on Suse 10.2

От
"Scott Marlowe"
Дата:
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.

Re: Help Postgresql to start on Suse 10.2

От
Ivo Rossacher
Дата:
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



Re: Help Postgresql to start on Suse 10.2

От
Michael Monnerie
Дата:
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

Вложения

Re: Help Postgresql to start on Suse 10.2

От
"Scott Marlowe"
Дата:
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