installation of postgres 10.6

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

installation of postgres 10.6

Pavan Kumar-3
Hello Experts,

I am very new to postgres database technology and trying to learn Postgres administration  now.

I have couple of questions on installation.

I am trying to install postgres from source code and following below document 

here are my question.

1. Which user i need to install postgres (root) or do  i need to create a separate user for postgres?

Kindly advise.

-- 
Regards,

#!  Pavan Kumar
----------------------------------------------
-
Sr. Database Administrator..!

NEXT GENERATION PROFESSIONALS, LLC
Cell    #  267-799-3182 #  pavan.dba27 (Gtalk)  
India   # 9000459083

Take Risks; if you win, you will be very happy. If you lose you will be Wise  
Reply | Threaded
Open this post in threaded view
|

Re: installation of postgres 10.6

Pepe TD Vo
I am learning myself too, and I was successful to install postgres binary as root and yes you are still needed to create postgres os user to run postgres db as same as oracle and mysql  Make sure all the libraries are downloaded.

v/r,
 
Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success


On Monday, February 11, 2019 1:38 PM, Pavan Kumar <[hidden email]> wrote:


Hello Experts,

I am very new to postgres database technology and trying to learn Postgres administration  now.

I have couple of questions on installation.

I am trying to install postgres from source code and following below document 

here are my question.

1. Which user i need to install postgres (root) or do  i need to create a separate user for postgres?

Kindly advise.

-- 
Regards,

#!  Pavan Kumar
----------------------------------------------
-
Sr. Database Administrator..!

NEXT GENERATION PROFESSIONALS, LLC
Cell    #  267-799-3182 #  pavan.dba27 (Gtalk)  
India   # 9000459083

Take Risks; if you win, you will be very happy. If you lose you will be Wise  


Reply | Threaded
Open this post in threaded view
|

Re: installation of postgres 10.6

Ron-2
In reply to this post by Pavan Kumar-3
On 2/11/19 12:37 PM, Pavan Kumar wrote:

> Hello Experts,
>
> I am very new to postgres database technology and trying to learn Postgres
> administration  now.
>
> I have couple of questions on installation.
>
> I am trying to install postgres from source code and following below document
> https://www.postgresql.org/docs/10/install-getsource.html
>
> here are my question.
>
> 1. Which user i need to install postgres (root) or do  i need to create a
> separate user for postgres?
>
> Kindly advise.

If you're this new to Postgres, maybe you should install it from packages.

https://www.postgresql.org/download/linux/


--
Angular momentum makes the world go 'round.

Reply | Threaded
Open this post in threaded view
|

Re: installation of postgres 10.6

Shreeyansh dba
In reply to this post by Pavan Kumar-3
Go through the below link, hope this will help you.

https://www.tecmint.com/install-postgresql-from-source-code-in-linux/

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com


On Tue, Feb 12, 2019 at 12:08 AM Pavan Kumar <[hidden email]> wrote:
Hello Experts,

I am very new to postgres database technology and trying to learn Postgres administration  now.

I have couple of questions on installation.

I am trying to install postgres from source code and following below document 

here are my question.

1. Which user i need to install postgres (root) or do  i need to create a separate user for postgres?

Kindly advise.

-- 
Regards,

#!  Pavan Kumar
----------------------------------------------
-
Sr. Database Administrator..!

NEXT GENERATION PROFESSIONALS, LLC
Cell    #  267-799-3182 #  pavan.dba27 (Gtalk)  
India   # 9000459083

Take Risks; if you win, you will be very happy. If you lose you will be Wise  
Reply | Threaded
Open this post in threaded view
|

Re: installation of postgres 10.6

Laurenz Albe
In reply to this post by Pavan Kumar-3
Pavan Kumar wrote:

> I am very new to postgres database technology and trying to learn Postgres administration  now.
>
> I have couple of questions on installation.
>
> I am trying to install postgres from source code and following below document
> https://www.postgresql.org/docs/10/install-getsource.html
>
> here are my question.
>
> 1. Which user i need to install postgres (root) or do  i need to create a separate user for postgres?

You configure and build PostgreSQL as a normal user, not "root".

Only fir the final step (make install) you will need "root" permissions,
if you install the software in /usr or /opt or somewhere else where
only root can write.

You will need another user (traditionally called "postgres") to own
the database files and processes, but that comes after building and
installation.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com