| 1 |
rabbe@×××××××.se wrote: |
| 2 |
> Does anyone know, would it be practical to run an SQL server of some |
| 3 |
> variety in Prefix Portage? It would be for prototyping only. |
| 4 |
> |
| 5 |
> Let me state at once that I have little experience with databases. I did |
| 6 |
> run mysql on native Gentoo for some time though, with no problems. |
| 7 |
> |
| 8 |
> I see that there are things like postgresql and sqlite in the prefix tree. |
| 9 |
> Did anyone try them out? |
| 10 |
> |
| 11 |
> And what is the difference between the postgresql-server and postgresql |
| 12 |
> packages? Different packagings of the same server? (I see now that there |
| 13 |
> is a Gentoo guide and it says `emerge postgresql' very early on..) |
| 14 |
> |
| 15 |
> Rabbe Fogelholm |
| 16 |
> |
| 17 |
> |
| 18 |
> |
| 19 |
As Fabian (MonetDB? :)) has mentioned, it is possible. I'm having some |
| 20 |
troubles with eselect-postgresql (see bug #232701) at the moment, but |
| 21 |
it's not too hard to get set up. |
| 22 |
|
| 23 |
AFAIK the difference between postgresql and postgresql-server is that |
| 24 |
postgresql-server is a newer replacement for postgresql, yet postgresql |
| 25 |
hasn't been retired yet. Likewise, dev-db/postgresql-base is a |
| 26 |
replacement for dev-db/libpq (but has the psql client, etc.) |
| 27 |
|
| 28 |
Here's an example of how you can get by without init scripts: |
| 29 |
- create a directory somewhere to hold your database + configs, ie. ~/pgdata |
| 30 |
- run the initdb tool, which sets up the default config + database: |
| 31 |
# initdb -D ~/pgdata |
| 32 |
|
| 33 |
- start the server |
| 34 |
# pg_ctl -D ~/pgdata -l ~/pgdata/logfile start |
| 35 |
|
| 36 |
- check the server is running |
| 37 |
# psql -l |
| 38 |
|
| 39 |
- stop the server |
| 40 |
# pg_ctl -D ~/pgdata stop |
| 41 |
|
| 42 |
|
| 43 |
Matt. |
Archives