LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 05-22-2014, 05:55 AM   #1
sayhello_to_the_world
Member
 
Registered: May 2013
Posts: 229

Rep: Reputation: Disabled
installing postgresql on opensuse 13.1 - in combination with osmosis


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.

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:

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

Quote:
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 ;-)

Last edited by sayhello_to_the_world; 05-22-2014 at 06:02 AM.
 
Old 05-22-2014, 10:04 AM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 27,253

Rep: Reputation: 8079Reputation: 8079Reputation: 8079Reputation: 8079Reputation: 8079Reputation: 8079Reputation: 8079Reputation: 8079Reputation: 8079Reputation: 8079Reputation: 8079
Quote:
Originally Posted by sayhello_to_the_world View Post
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
installing osmosis - filter and convert on suse 13.1 - via commandline - looks funny sayhello_to_the_world Linux - General 1 04-14-2014 10:42 PM
[SOLVED] Postgresql 9 en OpenSuse 11.3 Starting Failed gonvaro Linux - Newbie 4 01-09-2011 12:54 PM
postgresql and opensuse installation yeehi SUSE / openSUSE 2 11-11-2007 09:41 AM
Bind Mouse Button Combination to Keyboard Key Combination? neoAKiRAz Linux - Desktop 0 05-04-2007 01:49 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 09:39 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration