pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Help Postgresql to start on Suse 10.2
5+ messages / 4 participants
[nested] [flat]

* Help Postgresql to start on Suse 10.2
@ 2008-04-21 09:18  Monalee Bhandge <monalee_b@yahoo.com>
  0 siblings, 3 replies; 5+ messages in thread

From: Monalee Bhandge @ 2008-04-21 09:18 UTC (permalink / raw)
  To: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Help Postgresql to start on Suse 10.2
@ 2008-04-21 18:56  Scott Marlowe <scott.marlowe@gmail.com>
  parent: Monalee Bhandge <monalee_b@yahoo.com>
  2 siblings, 1 reply; 5+ messages in thread

From: Scott Marlowe @ 2008-04-21 18:56 UTC (permalink / raw)
  To: Monalee Bhandge <monalee_b@yahoo.com>; +Cc: pgsql-admin

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.



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Help Postgresql to start on Suse 10.2
@ 2008-04-21 19:32  Ivo Rossacher <rossacher@bluewin.ch>
  parent: Monalee Bhandge <monalee_b@yahoo.com>
  2 siblings, 0 replies; 5+ messages in thread

From: Ivo Rossacher @ 2008-04-21 19:32 UTC (permalink / raw)
  To: pgsql-admin

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





^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Help Postgresql to start on Suse 10.2
@ 2008-04-21 20:06  Michael Monnerie <michael.monnerie@it-management.at>
  parent: Monalee Bhandge <monalee_b@yahoo.com>
  2 siblings, 0 replies; 5+ messages in thread

From: Michael Monnerie @ 2008-04-21 20:06 UTC (permalink / raw)
  To: pgsql-admin

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

Attachments:

  signature.asc (application/pgp-signature, 193B) download

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Help Postgresql to start on Suse 10.2
@ 2008-04-22 15:20  Scott Marlowe <scott.marlowe@gmail.com>
  parent: Scott Marlowe <scott.marlowe@gmail.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Scott Marlowe @ 2008-04-22 15:20 UTC (permalink / raw)
  To: Monalee Bhandge <monalee_b@yahoo.com>; pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2008-04-22 15:20 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-04-21 09:18 Help Postgresql to start on Suse 10.2 Monalee Bhandge <monalee_b@yahoo.com>
2008-04-21 18:56 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-04-22 15:20   ` Scott Marlowe <scott.marlowe@gmail.com>
2008-04-21 19:32 ` Ivo Rossacher <rossacher@bluewin.ch>
2008-04-21 20:06 ` Michael Monnerie <michael.monnerie@it-management.at>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox