Re: [GENERAL] OpenSuse10.0 and postgresql
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 ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] OpenSuse10.0 and postgresql
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 ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] OpenSuse10.0 and postgresql
On 3/19/06, Hrishikesh Deshmukh <[EMAIL PROTECTED]> 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) ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] OpenSuse10.0 and postgresql
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 <[EMAIL PROTECTED]> 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 > > [EMAIL PROTECTED] > > > > ---(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 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] OpenSuse10.0 and postgresql
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, HrishiOn 3/18/06, Adrian Klaver <[EMAIL PROTECTED]> 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,> HrishiSuSE puts their documentation for packages under /usr/share/doc/packages. Cdto this directory and look for sub-directory with postgresql name. Thereshould be a README or other documentation in the sub-directory. --Adrian Klaver[EMAIL PROTECTED]---(end of broadcast)---TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] OpenSuse10.0 and postgresql
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 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] OpenSuse10.0 and postgresql
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
Re: [GENERAL] 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 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings