Restoring Database created on windows on FreeBSD

On Wed, 2005-10-19 at 08:23 +0200, postgresql@bryden.co.za wrote:

Hi

I am very new to FreeBSD (Windows Background), but am busy trying to
implement a PostgreSQL database that I have running in the Windows
environemtn on FreeBSD. Naturally, most of my problems so far have been
geeting to grips with FreeBSD.

Anyway, I am having a problem at the moment. Having being previously
spoilt with the ease of installation on windows, I am sure that I have
missed the boat on something.

Freebsd ports is an amazingly easy way to install software.

I downloaded the latest port for PostgreSQL-8.0.4 from postgresql.org.

the postgresq website does not have Freebsd ports ... just source code
from what I can see.

I
followed the instructions in the documentation and all seemed to work. I
have successfully created "test" databases and have happily managed to
connect to the new PostgreSQL server using psql and pgAdmin III(on
windows). I have now backed up my DB from windows and have created a new
database on the BSD server. When restoring this DB I got a lot of errors
related to some of the system installed functions. I then realised that
the PostgreSQL installation on FreeBSD did not install any of the
contrib
modules. I went to the /contrib folder in the port I used to to install
postgreSQL (/usr/ports/database/postgresql-8.0.4/contrib). I excluded
/cube and /mysql from the MakeFile (cube seemed to be failing and why
would I want mysql stuff on PostgreSQL?). I then did a gmake install.
All
contribs seemed to install fine. I reran the restore on a clean DB and
most of the errors went away, but I am still getting errors all related
to
system functions looking for '$libdir/admin'.

Does anyone know what I could have missed here?

It looks like you built from source rather that using the FreeBSD ports
system. Assuming you have a fresh FreeBSD install one would do the
following to achieve your desired end goal.

1) cd /usr/ports/databases/postgresql80-server
2) make && make install
3) pay attention to the notes at the end about tuning your kernel for
shared memory usage (if you plan on having lots of connections)
4) cd /usr/ports/databases/postgresql-contrib
5) make && make install
6) /usr/local/etc/rc.d/010.pgsql.sh initdb
7) /usr/local/etc/rc.d/010.pgsql.sh start

Now if your ports tree is out of date (or even if not) you may want to
do the following instead:

1) pkg_add -r postgresql80-server
2) pkg_add -r postgresql-contrib

Then continue with steps 6 and 7 above. You can verify the package
installation via pkg_info. Also, you may need to build (via ports) or
add (via pkg_add) postgresql80-client.

HTH

Sven

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

On Wed, 2005-10-19 at 08:23 +0200, postgresql@bryden.co.za wrote:

Hi

I am very new to FreeBSD (Windows Background), but am busy trying to
implement a PostgreSQL database that I have running in the Windows
environemtn on FreeBSD. Naturally, most of my problems so far have been
geeting to grips with FreeBSD.

Anyway, I am having a problem at the moment. Having being previously
spoilt with the ease of installation on windows, I am sure that I have
missed the boat on something.

Freebsd ports is an amazingly easy way to install software.

I downloaded the latest port for PostgreSQL-8.0.4 from postgresql.org.

the postgresq website does not have Freebsd ports ... just source code
from what I can see.

I
followed the instructions in the documentation and all seemed to work. I
have successfully created "test" databases and have happily managed to
connect to the new PostgreSQL server using psql and pgAdmin III(on
windows). I have now backed up my DB from windows and have created a new
database on the BSD server. When restoring this DB I got a lot of errors
related to some of the system installed functions. I then realised that
the PostgreSQL installation on FreeBSD did not install any of the
contrib
modules. I went to the /contrib folder in the port I used to to install
postgreSQL (/usr/ports/database/postgresql-8.0.4/contrib). I excluded
/cube and /mysql from the MakeFile (cube seemed to be failing and why
would I want mysql stuff on PostgreSQL?). I then did a gmake install.
All
contribs seemed to install fine. I reran the restore on a clean DB and
most of the errors went away, but I am still getting errors all related
to
system functions looking for '$libdir/admin'.

Does anyone know what I could have missed here?

It looks like you built from source rather that using the FreeBSD ports
system. Assuming you have a fresh FreeBSD install one would do the
following to achieve your desired end goal.

1) cd /usr/ports/databases/postgresql80-server
2) make && make install
3) pay attention to the notes at the end about tuning your kernel for
shared memory usage (if you plan on having lots of connections)
4) cd /usr/ports/databases/postgresql-contrib
5) make && make install
6) /usr/local/etc/rc.d/010.pgsql.sh initdb
7) /usr/local/etc/rc.d/010.pgsql.sh start

Now if your ports tree is out of date (or even if not) you may want to
do the following instead:

1) pkg_add -r postgresql80-server
2) pkg_add -r postgresql-contrib

Then continue with steps 6 and 7 above. You can verify the package
installation via pkg_info. Also, you may need to build (via ports) or
add (via pkg_add) postgresql80-client.

HTH

Sven

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