Results 1 to 2 of 2
  1. #1
    Join Date
    May 2014
    Posts
    4

    Unanswered: installing postgresql on opensuse 13.1 - in combination with osmosis

    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.

    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:


    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:

    step 1. Set in /etc/sysconfig (with YaST)
    the POSTGRES_DATADIR to /home/postgres92/data
    (/home has the big partition...)
    this is not good!

    step3. create this file postgresql.service in /usr/lib/systemd/system/
    cd /usr/lib/systemd/system/
    vi postgresql.service
    this is not good!


    what else should i do !?
    should i run some tests on console
    or test the free space on disc!?

    love to her from you

    dilbert ;-)

  2. #2
    Join Date
    Dec 2012
    Posts
    43
    Hello dilbertone,

    I don't know something about "osmosis" but I know how to start and configure PostgreSQL at openSuSE 13.1:

    If you really want to set postgresql "DATADIR" to an other directory (for example /home/postgres92/data) it's important to create this directory and change the owner of this directory to user "postgres":
    Code:
    mkdir -p /home/postgres92/data
    Code:
    chown postgres:postgres /home/postgres92/data
    To start the postgresql server type in as user root:
    Code:
    systemctl start postgresql.service
    To stop the postgresql server just type in as user root:
    Code:
    systemctl stop postgresql.service
    You can enable postgresql server so postgresql server will start on every boot:
    Code:
    systemctl enable postgresql.service
    "pgadmin3" is a good GUI program for postgresl.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •