DragonFly BSD
DragonFly users List (threaded) for 2006-09
[Date Prev][Date Next]  [Thread Prev][Thread Next]  [Date Index][Thread Index]

Re: Postgresql HOWTO?

From: Petr Janda <elekktretterr@xxxxxxxxxxxxxx>
Date: Sat, 09 Sep 2006 13:08:54 +1000

1) Uninstall all postgres packages from your machine

You can do step number 2 in 2 ways:
2a) echo 'PKG_RCD_SCRIPTS=yes' >> /etc/mk.conf
or this way
2b) ln -s /usr/pkg/etc/rc.d/pgsql /etc/rc.d/

The 'a' way is better imo.

2) Install databases/postgres_81
3) echo 'pgsql=YES' >> /etc/rc.conf
4) Start up pgsql: /etc/rc.d/pgsql start
5) Add pgsql superuser: su - pgsql
6) "createuser root" and follow instructions till it returns you back to command line, make sure you make a superuser account. The instructions will ask you what type of account you want to create.
7) type exit and enter, which takes you back to your root account.
8) createdb testdb;
9) cd /usr/pkg/pgsql/data
10) Open pg_hba.conf and play with permissions, learn how to set permissions in pgsql.

After you create the super user you can add any other accounts with the createuser command with your regular root account and you DONT need to su - pgsql anymore.


Adrian M. Nida wrote:

Today I got some time to actually work on some DF related things at home. I wanted to install Gallery [0] so I could share some pics to family members (the other reason was that my DF box ran Gallery back in the pre-1.2 days). Happily, I found Gallery isn't in pkgsrc. The source install consists of a bunch of php files, so I was fine with that.

During the installation process, Gallery asks for a database connection. Thinking I had PostgreSQL [1] installed, I tried to run it against that. To my surprise I discovered that this box only had the client, not the server, installed. I completed a source install of /usr/pkgsrc/postgresql80-server and tried to run it.

At this point, I discovered that pkgsrc does not install *any* PostgreSQL startup files. I have a bunch of sample config files in /usr/pkg/share/
postgresql, but nothing that looks like a startup. I'm also assuming that the config files are supposed to go in /usr/pkg/etc/postgresql.

My question is whether anyone out there has a PostgreSQL (8.0) HOWTO? I tried the combinations "pkgsrc postgresql howto" and "netbsd postgresql howto" on Google [2] but neither returned anything remotely useful. Heck, at this point I'd appreciate just some general pointers/clarifications.

As many of you know, I'm quite content writing a HOWTO (and slaving through the labor of what works and what doesn't) from scratch. I'm just trying to figure out far "scratch" actually is.



[0] http://gallery.sourceforge.net/
[1] http://www.postgresql.org/
[2] http://www.google.com/

This mail sent through IMP: http://horde.org/imp/

[Date Prev][Date Next]  [Thread Prev][Thread Next]  [Date Index][Thread Index]