installing PostgreSQL + pgadmin

[zlatko]

Hello.

Could someone explain how to install PostgreSQL + pgadmin3 on PC-BSD and how to start PostgreSQL server?
Please, be descriptive as much as possible, because I don't have experience in Unix...

Thanks in advance

Zlatko

[dracheflieger]

First load your ports tree and source files

KMenu -> Settings -> System Administration -> PC-BSD System and once that window opens, go to the Tasks tab and use both buttons. This will take a while as there is probably close to 500 mbs of data and ports. The Fetch Ports will appear behind the main window so move the main window out of the way to view progress.

Once those are downloaded then you need to open a terminal.

KMenu -> System -> konsole

Once konsole opens click on the Settings menu item, then History and click the Set Unlimited button and then the OK button. You will need to look back later. Now type in su and <enter> then your root password and once you see the # prompt you will know you are root or type whoami and it should return as root.

now type in cd /usr/ports/databases/postgresql81-server && make install clean && rehash

That will install the version 81 server...there are also older versions if that is what you need (73, 74 and 80...just replace the 81 with one of them if you need an older version). Look at the bottom of the install and it should give you instructions on what you need to do to get it to run.

Next type in
cd /usr/ports/databases/postgresql81-client && make install clean && rehash to install the client. Same options apply as the server if you want an older one, just be sure you use the same versions on each. After your compile is complete type in cd /usr/ports/databases/pgadmin3 && make install clean && rehash Again, you will need to look near the end of these to see how to make things happen or Google it. I don't use Postgres for anything currently other than perhaps a few programs that I've got install that depend on it but all of that happens in the background.

Welcome and good luck.

[TerryP]

I don't know what you need it for but you might be able to use the PostgreSQL 8.1.4 (http://www.pbidir.com/packages.php?code=349) PBI for installing it.

I havn't gotton around to setting up a web local web server yet so I don't have any exp. With Databases in this regard ether

[JUNIORSATANAS]

help :


[root@pcbsd]/usr/ports/databases/postgresql73-server(49)# ls
Makefile files pkg-install-server pkg-plist-client pkg-plist-plperl pkg-plist-pltcl
distinfo pkg-descr pkg-plist pkg-plist-contrib pkg-plist-plpython pkg-plist-server
[root@pcbsd]/usr/ports/databases/postgresql73-server(50)# make install
===> postgresql-server-7.3.21_1 is marked as broken: "You must remove heimdal's /usr/bin/krb5-config and /usr/lib/libkrb5.so*, and set NO_KERBEROS=true in /etc/make.conf to build successfully with MIT-KRB".
*** Error code 1

Stop in /usr/ports/databases/postgresql73-server.
[root@pcbsd]/usr/ports/databases/postgresql73-server(51)#


--------------------------------------------------------------------------

=========== BACKUP YOUR DATA! =============
As always, backup your data before
upgrading. If the upgrade leads to a higher
minor revision (e.g. 7.3.x -> 7.4), a dump
and restore of all databases is
required. This is *NOT* done by the port!

Press ctrl-C *now* if you need to pg_dump.
===========================================

===> Vulnerability check disabled, database not found
===> Found saved configuration for postgresql-server-8.1.17
=> postgresql-8.1.17.tar.bz2 doesn't seem to exist in /usr/ports/distfiles/postgresql.
=> Attempting to fetch from ftp://ftp9.us.postgresql.org/pub/mirror ... e/v8.1.17/ (ftp://ftp9.us.postgresql.org/pub/mirrors/postgresql/source/v8.1.17/).
fetch: ftp://ftp9.us.postgresql.org/pub/mirror ... 17.tar.bz2 (ftp://ftp9.us.postgresql.org/pub/mirrors/postgresql/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp10.us.postgresql.org/pub/postg ... e/v8.1.17/ (ftp://ftp10.us.postgresql.org/pub/postgresql/source/v8.1.17/).
fetch: ftp://ftp10.us.postgresql.org/pub/postg ... 17.tar.bz2 (ftp://ftp10.us.postgresql.org/pub/postgresql/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from http://ring.nict.go.jp/archives/misc/db ... e/v8.1.17/ (http://ring.nict.go.jp/archives/misc/db/postgresql/source/v8.1.17/).
fetch: http://ring.nict.go.jp/archives/misc/db ... 17.tar.bz2 (http://ring.nict.go.jp/archives/misc/db/postgresql/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from http://ring.k-opti.com/archives/misc/db ... e/v8.1.17/ (http://ring.k-opti.com/archives/misc/db/postgresql/source/v8.1.17/).
fetch: http://ring.k-opti.com/archives/misc/db ... 17.tar.bz2 (http://ring.k-opti.com/archives/misc/db/postgresql/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from http://ring.riken.jp/archives/misc/db/p ... e/v8.1.17/ (http://ring.riken.jp/archives/misc/db/postgresql/source/v8.1.17/).
fetch: http://ring.riken.jp/archives/misc/db/p ... 17.tar.bz2 (http://ring.riken.jp/archives/misc/db/postgresql/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp.au.postgresql.org/pub/postgre ... e/v8.1.17/ (ftp://ftp.au.postgresql.org/pub/postgresql/source/v8.1.17/).
fetch: ftp://ftp.au.postgresql.org/pub/postgre ... 17.tar.bz2 (ftp://ftp.au.postgresql.org/pub/postgresql/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp.at.postgresql.org/db/www.post ... e/v8.1.17/ (ftp://ftp.at.postgresql.org/db/www.postgresql.org/pub/source/v8.1.17/).
fetch: ftp://ftp.at.postgresql.org/db/www.post ... 17.tar.bz2 (ftp://ftp.at.postgresql.org/db/www.postgresql.org/pub/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp.be.postgresql.org/postgresql/source/v8.1.17/.
fetch: ftp://ftp.be.postgresql.org/postgresql/ ... 17.tar.bz2 (ftp://ftp.be.postgresql.org/postgresql/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp.ba.postgresql.org/pub/postgre ... e/v8.1.17/ (ftp://ftp.ba.postgresql.org/pub/postgresql/source/v8.1.17/).
fetch: ftp://ftp.ba.postgresql.org/pub/postgre ... 17.tar.bz2 (ftp://ftp.ba.postgresql.org/pub/postgresql/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp.cz.postgresql.org/DATA/postgr ... e/v8.1.17/ (ftp://ftp.cz.postgresql.org/DATA/postgresql/source/v8.1.17/).
fetch: ftp://ftp.cz.postgresql.org/DATA/postgr ... 17.tar.bz2 (ftp://ftp.cz.postgresql.org/DATA/postgresql/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp2.cz.postgresql.org/pub/postgr ... e/v8.1.17/ (ftp://ftp2.cz.postgresql.org/pub/postgresql/source/v8.1.17/).
fetch: ftp://ftp2.cz.postgresql.org/pub/postgr ... 17.tar.bz2 (ftp://ftp2.cz.postgresql.org/pub/postgresql/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp.ee.postgresql.org/mirrors/pos ... e/v8.1.17/ (ftp://ftp.ee.postgresql.org/mirrors/postgresql/source/v8.1.17/).
fetch: ftp://ftp.ee.postgresql.org/mirrors/pos ... 17.tar.bz2 (ftp://ftp.ee.postgresql.org/mirrors/postgresql/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp.fr.postgresql.org/source/v8.1.17/.
fetch: ftp://ftp.fr.postgresql.org/source/v8.1 ... 17.tar.bz2 (ftp://ftp.fr.postgresql.org/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp.de.postgresql.org/mirror/post ... e/v8.1.17/ (ftp://ftp.de.postgresql.org/mirror/postgresql/source/v8.1.17/).
fetch: ftp://ftp.de.postgresql.org/mirror/post ... 17.tar.bz2 (ftp://ftp.de.postgresql.org/mirror/postgresql/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp3.de.postgresql.org/pub/Mirror ... e/v8.1.17/ (ftp://ftp3.de.postgresql.org/pub/Mirrors/ftp.postgresql.org/source/v8.1.17/).
fetch: ftp://ftp3.de.postgresql.org/pub/Mirror ... 17.tar.bz2 (ftp://ftp3.de.postgresql.org/pub/Mirrors/ftp.postgresql.org/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp.gr.postgresql.org/pub/databas ... e/v8.1.17/ (ftp://ftp.gr.postgresql.org/pub/databases/postgresql/source/v8.1.17/).
fetch: ftp://ftp.gr.postgresql.org/pub/databas ... 17.tar.bz2 (ftp://ftp.gr.postgresql.org/pub/databases/postgresql/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp.hk.postgresql.org/postgresql/source/v8.1.17/.
fetch: ftp://ftp.hk.postgresql.org/postgresql/ ... 17.tar.bz2 (ftp://ftp.hk.postgresql.org/postgresql/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp.ie.postgresql.org/mirrors/ftp ... e/v8.1.17/ (ftp://ftp.ie.postgresql.org/mirrors/ftp.postgresql.org/pub/source/v8.1.17/).
fetch: ftp://ftp.ie.postgresql.org/mirrors/ftp ... 17.tar.bz2 (ftp://ftp.ie.postgresql.org/mirrors/ftp.postgresql.org/pub/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp2.it.postgresql.org/mirrors/po ... e/v8.1.17/ (ftp://ftp2.it.postgresql.org/mirrors/postgres/source/v8.1.17/).
fetch: ftp://ftp2.it.postgresql.org/mirrors/po ... 17.tar.bz2 (ftp://ftp2.it.postgresql.org/mirrors/postgres/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp.kr.postgresql.org/postgresql/source/v8.1.17/.
fetch: ftp://ftp.kr.postgresql.org/postgresql/ ... 17.tar.bz2 (ftp://ftp.kr.postgresql.org/postgresql/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp.lv.postgresql.org/pub/postgre ... e/v8.1.17/ (ftp://ftp.lv.postgresql.org/pub/postgresql/source/v8.1.17/).
fetch: ftp://ftp.lv.postgresql.org/pub/postgre ... 17.tar.bz2 (ftp://ftp.lv.postgresql.org/pub/postgresql/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp2.nl.postgresql.org/mirror/pos ... e/v8.1.17/ (ftp://ftp2.nl.postgresql.org/mirror/postgresql/source/v8.1.17/).
fetch: ftp://ftp2.nl.postgresql.org/mirror/pos ... 17.tar.bz2 (ftp://ftp2.nl.postgresql.org/mirror/postgresql/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp4.nl.postgresql.org/postgresql ... e/v8.1.17/ (ftp://ftp4.nl.postgresql.org/postgresql.zeelandnet.nl/source/v8.1.17/).
fetch: ftp://ftp4.nl.postgresql.org/postgresql ... 17.tar.bz2 (ftp://ftp4.nl.postgresql.org/postgresql.zeelandnet.nl/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp6.pl.postgresql.org/pub/postgr ... e/v8.1.17/ (ftp://ftp6.pl.postgresql.org/pub/postgresql/source/v8.1.17/).
fetch: ftp://ftp6.pl.postgresql.org/pub/postgr ... 17.tar.bz2 (ftp://ftp6.pl.postgresql.org/pub/postgresql/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp7.pl.postgresql.org/pub/mirror ... e/v8.1.17/ (ftp://ftp7.pl.postgresql.org/pub/mirror/ftp.postgresql.org/source/v8.1.17/).
fetch: ftp://ftp7.pl.postgresql.org/pub/mirror ... 17.tar.bz2 (ftp://ftp7.pl.postgresql.org/pub/mirror/ftp.postgresql.org/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp6.ro.postgresql.org/pub/mirror ... e/v8.1.17/ (ftp://ftp6.ro.postgresql.org/pub/mirrors/ftp.postgresql.org/source/v8.1.17/).
fetch: ftp://ftp6.ro.postgresql.org/pub/mirror ... 17.tar.bz2 (ftp://ftp6.ro.postgresql.org/pub/mirrors/ftp.postgresql.org/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp.ru.postgresql.org/pub/unix/da ... e/v8.1.17/ (ftp://ftp.ru.postgresql.org/pub/unix/database/pgsql/source/v8.1.17/).
fetch: ftp://ftp.ru.postgresql.org/pub/unix/da ... 17.tar.bz2 (ftp://ftp.ru.postgresql.org/pub/unix/database/pgsql/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp2.ru.postgresql.org/pub/databa ... e/v8.1.17/ (ftp://ftp2.ru.postgresql.org/pub/databases/postgresql/source/v8.1.17/).
fetch: ftp://ftp2.ru.postgresql.org/pub/databa ... 17.tar.bz2 (ftp://ftp2.ru.postgresql.org/pub/databases/postgresql/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp3.ru.postgresql.org/pub/mirror ... e/v8.1.17/ (ftp://ftp3.ru.postgresql.org/pub/mirror/postgresql/pub/source/v8.1.17/).
fetch: ftp://ftp3.ru.postgresql.org/pub/mirror ... 17.tar.bz2 (ftp://ftp3.ru.postgresql.org/pub/mirror/postgresql/pub/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp5.es.postgresql.org/mirror/pos ... e/v8.1.17/ (ftp://ftp5.es.postgresql.org/mirror/postgresql/source/v8.1.17/).
fetch: ftp://ftp5.es.postgresql.org/mirror/pos ... 17.tar.bz2 (ftp://ftp5.es.postgresql.org/mirror/postgresql/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp.se.postgresql.org/pub/databas ... e/v8.1.17/ (ftp://ftp.se.postgresql.org/pub/databases/relational/postgresql/source/v8.1.17/).
fetch: ftp://ftp.se.postgresql.org/pub/databas ... 17.tar.bz2 (ftp://ftp.se.postgresql.org/pub/databases/relational/postgresql/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp3.tw.postgresql.org/pub/postgr ... e/v8.1.17/ (ftp://ftp3.tw.postgresql.org/pub/postgresql/source/v8.1.17/).
fetch: ftp://ftp3.tw.postgresql.org/pub/postgr ... 17.tar.bz2 (ftp://ftp3.tw.postgresql.org/pub/postgresql/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp.postgresql.org/pub/source/v8.1.17/.
fetch: ftp://ftp.postgresql.org/pub/source/v8. ... 17.tar.bz2 (ftp://ftp.postgresql.org/pub/source/v8.1.17/postgresql-8.1.17.tar.bz2): No address record
=> Attempting to fetch from ftp://ftp.FreeBSD.org/pub/FreeBSD/ports ... ostgresql/ (ftp://ftp.FreeBSD.org/pub/FreeBSD/ports/distfiles/postgresql/).
fetch: ftp://ftp.FreeBSD.org/pub/FreeBSD/ports ... 17.tar.bz2 (ftp://ftp.FreeBSD.org/pub/FreeBSD/ports/distfiles/postgresql/postgresql-8.1.17.tar.bz2): No address record
=> Couldn't fetch it - please try to retrieve this
=> port manually into /usr/ports/distfiles/postgresql and try again.
*** Error code 1

Stop in /usr/ports/databases/postgresql81-server.
*** Error code 1

Stop in /usr/ports/databases/postgresql81-server.
[root@pcbsd]/usr/ports/databases/postgresql81-server(54)#