PostgreSQL Administration - Help for postgresql binary installation v.8.0.3

Author

Help for postgresql binary installation v.8.0.3

Jana Nguyen

2005-07-12, 8:24 pm

Hi there,

I am installing postgresql v. 8.0.3 binary on a redhat linux rhel 3.0.
What rpms are needed and in what order for installation since I see a
slew of rpms below. It be great if there is documentation for binary
installation for postgresql v.8+ as well. If so, let me know.

postgresql-8.0.3-1PGDG.i686.rpm
postgresql-8.0.3-1PGDG.i686.rpm & #91;bittorrent] 2005
-05-12 11:41:12 2.8
MB
postgresql-contrib-8.0.3-1PGDG.i686.rpm
postgresql-contrib-8.0.3-1PGDG.i686.rpm & #91;bittorrent] 2005
-05-12
11:46:30 1 MB
postgresql-devel-8.0.3-1PGDG.i686.rpm
postgresql-devel-8.0.3-1PGDG.i686.rpm & #91;bittorrent] 2005
-05-12
11:46:59 1 MB
postgresql-docs-8.0.3-1PGDG.i686.rpm
postgresql-docs-8.0.3-1PGDG.i686.rpm & #91;bittorrent] 2005
-05-12
11:47:42 1.3 MB
postgresql-jdbc-8.0.3-1PGDG.i686.rpm
postgresql-jdbc-8.0.3-1PGDG.i686.rpm & #91;bittorrent] 2005
-05-12
11:48:14 879.1 KB
postgresql-libs-8.0.3-1PGDG.i686.rpm
postgresql-libs-8.0.3-1PGDG.i686.rpm 2005-05-12 11:48:24 327.2 KB
postgresql-pl-8.0.3-1PGDG.i686.rpm
postgresql-pl-8.0.3-1PGDG.i686.rpm 2005-05-12 11:48:40 476.3 KB
postgresql-python-8.0.3-1PGDG.i686.rpm
postgresql-python-8.0.3-1PGDG.i686.rpm 2005-05-12 11:48:43 66.4 KB
postgresql-server-8.0.3-1PGDG.i686.rpm
postgresql-server-8.0.3-1PGDG.i686.rpm & #91;bittorrent] 2005
-05-12
11:52:08 5.7 MB
postgresql-test-8.0.3-1PGDG.i686.rpm
postgresql-test-8.0.3-1PGDG.i686.rpm & #91;bittorrent] 2005
-05-12
11:52:39 1 MB

thanks,
Jana

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Devrim GUNDUZ

2005-07-13, 3:24 am

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

On Tue, 12 Jul 2005, Jana Nguyen wrote:

> I am installing postgresql v. 8.0.3 binary on a redhat linux rhel 3.0.
> What rpms are needed and in what order for installation since I see a
> slew of rpms below.

If you download all RPMs and run

rpm -qip package_name

comamnd, you'll see the detailed information about each package.

You'll need to install postgresql-libs first. If you want to run server,
install postgresql-server and postgresql rpms. If this will be a client,
then you don't need to install -server RPM. The other packages are for
developing applications, docs, tcl, pl, etc support.

However, due to an important change in PostgreSQL 8.0.2+, you'll need
another RPM in RHEL 3:

http://developer.PostgreSQL.org/~de...-3PGDG.i686.rpm

With this RPM, you can overcome the problem. First install this package
and then install PostgreSQL.

> It be great if there is documentation for binary installation for
> postgresql v.8+ as well. If so, let me know.

postgresql- RPM comes with a "README.rpm-dist" file and that will guide
you for RPM installations.

However it might be good to include an RPM doc in main documentation set.
I'll submit a patch today.

Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.tdmsoft.com.tr http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFC1LRJtl86P3SP
fQ4RAhNYAJ0ZaBHQ9yCg
UQ9l+McuXbTnAZDlXACg
zSd7
GF5eRKpB/VYHcnzff/r/sXU=
=f6HW
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Jana Nguyen

2005-07-13, 8:24 pm

Hi,

When I tried to install the another RPM in RHEL 3
'compat-postgresql-libs-3-3PGDG.i686.rpm' for postgresql v.8.0.3.
I get the following error:

[root@opt]# rpm -i compat-postgresql-libs-3-3PGDG.i686.rpm
warning: compat-postgresql-libs-3-3PGDG.i686.rpm: V3 DSA signature:
NOKEY, key ID 748f7d0e

Is postgresql v.8.0.3 a stable release, if not what latest version is stable?

Thanks.

On 7/12/05, Devrim GUNDUZ <devrim@gunduz.org> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> Hi,
>
> On Tue, 12 Jul 2005, Jana Nguyen wrote:
>
>
> If you download all RPMs and run
>
> rpm -qip package_name
>
> comamnd, you'll see the detailed information about each package.
>
> You'll need to install postgresql-libs first. If you want to run server,
> install postgresql-server and postgresql rpms. If this will be a client,
> then you don't need to install -server RPM. The other packages are for
> developing applications, docs, tcl, pl, etc support.
>
> However, due to an important change in PostgreSQL 8.0.2+, you'll need
> another RPM in RHEL 3:
>
> http://developer.PostgreSQL.org/~de...-3PGDG.i686.rpm
>
> With this RPM, you can overcome the problem. First install this package
> and then install PostgreSQL.
>
>
> postgresql- RPM comes with a "README.rpm-dist" file and that will guide
> you for RPM installations.
>
> However it might be good to include an RPM doc in main documentation set.
> I'll submit a patch today.
>
> Regards,
> - --
> Devrim GUNDUZ
> devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
> http://www.tdmsoft.com.tr http://www.gunduz.org
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.1 (GNU/Linux)
>
> iD8DBQFC1LRJtl86P3SP
fQ4RAhNYAJ0ZaBHQ9yCg
UQ9l+McuXbTnAZDlXACg
zSd7
> GF5eRKpB/VYHcnzff/r/sXU=
> =f6HW
> -----END PGP SIGNATURE-----
>

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Devrim GUNDUZ

2005-07-13, 8:24 pm

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

On Wed, 13 Jul 2005, Jana Nguyen wrote:

> When I tried to install the another RPM in RHEL 3
> 'compat-postgresql-libs-3-3PGDG.i686.rpm' for postgresql v.8.0.3.
> I get the following error:
>
> [root@opt]# rpm -i compat-postgresql-libs-3-3PGDG.i686.rpm
> warning: compat-postgresql-libs-3-3PGDG.i686.rpm: V3 DSA signature:
> NOKEY, key ID 748f7d0e

This is not an 'error', just a warning. To get rid of this, run the
following comamnd:

rpm --import http://www.gunduz.org/devrimgunduz.pgp.pub

> Is postgresql v.8.0.3 a stable release, if not what latest version is stable?

This is the latest stable in 8.0 branch.

Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.tdmsoft.com.tr http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFC1au2tl86P3SP
fQ4RArcAAJ9hwP2Tla/h9vXq/Lg5CT79Y72xggCfemCt
9Vz0JCrJP4xwYa1XF8tD
TWw=
=xW0L
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Sponsored Links