Обсуждение: OpenSuse10.0 and postgresql

On Saturday 18 March 2006 09:15 am, Hrishikesh Deshmukh wrote:
> Hi All,
>
> Can somebody please tell me where i can find rpms for postgesql on OpenSuse
> 10.0?
>
> Sincerely,
> Hrishi
Try this site and enter postgresql. I found rpm's for OpenSuSE .
http://rpm.pbone.net/index.php3
--
Adrian Klaver
aklaver@comcast.net

On Saturday 18 March 2006 11:44 am, Hrishikesh Deshmukh wrote:
> Hi All,
>
> In downloaded the rpms and installed rpms.
> Could someone help me what to do next?!
> The 8.0 documentation talks about installation from source code!
>
> Thanks,
> Hrishi
SuSE puts their documentation for packages under /usr/share/doc/packages. Cd
to this directory and look for sub-directory with postgresql name. There
should be a README or other documentation in the sub-directory.

--
Adrian Klaver
aklaver@comcast.net

On Saturday 18 March 2006 01:38 pm, Hrishikesh Deshmukh wrote:
> The README doesn't talk about what next to do after installation from rpms,
> there is no file which talks about in the
> /usr/share/doc/packages/postgresql . It only says look at INSTALL file but
> there is no install with the rpms!!
>
> Thanks,
> Hrishi
>
> On 3/18/06, Adrian Klaver <aklaver@comcast.net> wrote:
> > On Saturday 18 March 2006 11:44 am, Hrishikesh Deshmukh wrote:
> > > Hi All,
> > >
> > > In downloaded the rpms and installed rpms.
> > > Could someone help me what to do next?!
> > > The 8.0 documentation talks about installation from source code!
> > >
> > > Thanks,
> > > Hrishi
> >
> > SuSE puts their documentation for packages under /usr/share/doc/packages.
> > Cd
> > to this directory and look for sub-directory with postgresql name. There
> > should be a README or other documentation in the sub-directory.
> >
> > --
> > Adrian Klaver
> > aklaver@comcast.net
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: Have you checked our extensive FAQ?
> >
> >                http://www.postgresql.org/docs/faq
I have always installed Postgres from source so I am sailing into uncharted
waters here. Looking at the file list of the RPM it looks like most of the
setup work has been done. You need to go to /usr/share/postgresql and modify
the sample config files (remember to save as without the .sample). Looks like
the data directory is /var/lib/pgsql/data. Once you are ready to start run
rcpostgresql to start the database. If you want database to run at boot you
can enable through YAST under System-->Runlevel Editor.

--
Adrian Klaver
aklaver@comcast.net

On 3/19/06, Hrishikesh Deshmukh <hdeshmuk@gmail.com> wrote:
> Can somebody please tell me where i can find rpms for postgesql on OpenSuse
> 10.0?

opensuse10 comes with PostgreSQL 8.0.1, installable once you configure
the installation sources correctly. (See
http://en.opensuse.org/Mirrors_Released_Version)

Unsupported PostgreSQL 8.1.x packages are available from:
http://ftp.suse.com/pub/projects/postgresql/

Not sure about the unsupported 8.1.x packages, but the default ones
are integrated with suse's startup scripts, so:

 * Go to /var/lib/pgsql/ and edit pg_hba.conf and postgresql.conf You
might have to do a "rcpostgresql start; rcpostgresql stop" to force it
to create the default database cluster (aka "initdb" in PostgreSQL
docs), before you can edit those two files. If you do so, you don't
need to manually initdb.

 * "rcpostgresql start" to start postgresql server manually. This is
equivalent to "pg_ctl -D /var/lib/pgsql -l /var/log/postgresql start"

 * "chkconfig -a postgresql" to add postgresql to the services to
start up during boot.

(This is a re-send, forgot to Cc the first time round)

Hrishikesh Deshmukh wrote:
> The README doesn't talk about what next to do after installation from rpms,
> there is no file which talks about in the /usr/share/doc/packages/postgresql
> . It only says look at INSTALL file but there is no install with the rpms!!

There should be a complete copy of the HTML manuals available too. They
are online here: http://www.postgresql.org/docs/

Might be worth making sure everything is installed - check you're not
missing a package:  rpm -qa | grep postg

A filename you can search for is "plpgsql.html" - that's probably only
installed by PG.
   locate plpgsql.html
   find /usr/share -name 'plpgsql.html'

HTH
--
   Richard Huxton
   Archonet Ltd

On Sat, 18 Mar 2006, Adrian Klaver wrote:

> On Saturday 18 March 2006 09:15 am, Hrishikesh Deshmukh wrote:
> > Hi All,
> >
> > Can somebody please tell me where i can find rpms for postgesql on OpenSuse
> > 10.0?
> >
> > Sincerely,
> > Hrishi
> Try this site and enter postgresql. I found rpm's for OpenSuSE .
> http://rpm.pbone.net/index.php3


I haven't found the SUSE 10 rpms are very current, so have been compiling
from source. It has been a pretty straightforward exercise (but not as
easy as installing from RPM :-)

I do hope to learn how to build RPMS & start providing Postgres/PostGIS &
related GIS/mapping packages but for someone with my technical skills, it
might take a while :-)

If anyone here is interested in mentoring me, all help gratefully
accepted!


Cheers,

  Brent Wood