SEO

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=Ahu06i...Dypao8Wcj9tAcJ


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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.

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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=Ahu06i...Dypao8Wcj9tAcJ



--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.4-svn0 (GNU/Linux)

iD8DBQBIDPO+zhSR9xwSCbQRAjcDAKDrJentQqBu6CETcFlyQN l0gxdAeQCgmqoa
Ax+ktcLQv27/JzvBMCz2aac=
=6lP3
-----END PGP SIGNATURE-----

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/i...ntication.html

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin