Quote:
Originally Posted by sayhello_to_the_world
hello dear Linux-Experts,
i am also new to postgresql: i have some expecience with mysql. So sorry for the noob - questions. i am willing to install postgresql on opensuse 13.1 - well i want to combine it with osmosis
first question : do i have to make some checks - to get an overview on the ressources and the performance and space etc. etx.
|
What do you mean by 'checks'??? If you try to install postgresql through yast/zypper, it will check your disk space, and install it if possible. After that, your postgresql requirements are met.
Quote:
note: i need to run postgresql with osmosis - so therefore i need some ressorces left. just need your advice for the first test - afterwards i am going to install postgresql btw: i am willing to follow some security advices:
|
There is no 'test' or 'check' to run...you can install postgresql by going to your package manager, and selecting it.
Quote:
something that is specific to my environment should not be placed in system part. So if we want to create a native postgresql.service for systemd on our system we have to place it in /etc/systemd/system
Well - i will try to avoid the following mistakes:
Code:
step 1. Set in /etc/sysconfig (with YaST)
the POSTGRES_DATADIR to /home/postgres92/data
(/home has the big partition...)
this is not good!
|
WHY is this 'not good'??? You're setting the place where the database goes, and that is typically NOT the system (/) partition. As with ANY database, having your own disk(s) for a database is very common, and having it on /home is no worse than having your database on /u01, or any other partition name.
Quote:
Code:
step3. create this file postgresql.service in /usr/lib/systemd/system/
cd /usr/lib/systemd/system/
vi postgresql.service
this is not good!
|
Again, WHY is this 'not good'??
Quote:
what else should i do !? should i run some tests on console or test the free space on disc!?
|
You should, as you've been advised several times in the past,
follow the instructions. Since you don't tell us where you got the instructions your quoting from, we can't tell you if they're right or not. Nothing you've posted is 'not good', or cause for ANY concern.
Also, again, a brief Google search for what you're trying to accomplish pulls up quite a few things:
https://help.openstreetmap.org/quest...and-postgresql
http://wiki.openstreetmap.org/wiki/O.../PostGIS_Setup