Re: [gentoo-alt] postgreql on prefix portage, doable?

[Rabbe Fogelholm]

Matt Michalowski wrote:
> rabbe@×××××××.se wrote:
>> Does anyone know, would it be practical to run an SQL server of some
>> variety in Prefix Portage? It would be for prototyping only.
>>
>> Let me state at once that I have little experience with databases. I did
>> run mysql on native Gentoo for some time though, with no problems.
>>
>> I see that there are things like postgresql and sqlite in the prefix
>> tree.
>> Did anyone try them out?
>>
>> And what is the difference between the postgresql-server and postgresql
>> packages? Different packagings of the same server? (I see now that there
>> is a Gentoo guide and it says `emerge postgresql' very early on..)
>>
>> Rabbe Fogelholm
>>
>>
>>
> As Fabian (MonetDB? :)) has mentioned, it is possible. I'm having some
> troubles with eselect-postgresql (see bug #232701) at the moment, but
> it's not too hard to get set up.
>
> AFAIK the difference between postgresql and postgresql-server is that
> postgresql-server is a newer replacement for postgresql, yet postgresql
> hasn't been retired yet. Likewise, dev-db/postgresql-base is a
> replacement for dev-db/libpq (but has the psql client, etc.)
>
> Here's an example of how you can get by without init scripts:
> - create a directory somewhere to hold your database + configs, ie.
> ~/pgdata
> - run the initdb tool, which sets up the default config + database:
>  # initdb -D ~/pgdata
>
> - start the server
>  # pg_ctl -D ~/pgdata -l ~/pgdata/logfile start
>
> - check the server is running
>  # psql -l
>
> - stop the server
>  # pg_ctl -D ~/pgdata stop
>
>
> Matt.

Which one of the two (postgresql or postgresql-server) should I look at?
Performance is not an issue; easy setup is more important.

--Rabbe