pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedinstallation of postgres 10.6
5+ messages / 5 participants
[nested] [flat]
* installation of postgres 10.6
@ 2019-02-11 18:37 Pavan Kumar <pavan.dba27@gmail.com>
2019-02-11 18:57 ` Re: installation of postgres 10.6 Pepe TD Vo <pepevo@yahoo.com>
2019-02-11 19:07 ` Re: installation of postgres 10.6 Ron <ronljohnsonjr@gmail.com>
2019-02-12 06:02 ` Re: installation of postgres 10.6 Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-02-12 08:05 ` Re: installation of postgres 10.6 Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 4 replies; 5+ messages in thread
From: Pavan Kumar @ 2019-02-11 18:37 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
--
*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 *
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: installation of postgres 10.6
2019-02-11 18:37 installation of postgres 10.6 Pavan Kumar <pavan.dba27@gmail.com>
@ 2019-02-11 18:57 ` Pepe TD Vo <pepevo@yahoo.com>
3 siblings, 0 replies; 5+ messages in thread
From: Pepe TD Vo @ 2019-02-11 18:57 UTC (permalink / raw)
To: Pavan Kumar <pavan.dba27@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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 <pavan.dba27@gmail.com> 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.
--
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: installation of postgres 10.6
2019-02-11 18:37 installation of postgres 10.6 Pavan Kumar <pavan.dba27@gmail.com>
@ 2019-02-11 19:07 ` Ron <ronljohnsonjr@gmail.com>
3 siblings, 0 replies; 5+ messages in thread
From: Ron @ 2019-02-11 19:07 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: installation of postgres 10.6
2019-02-11 18:37 installation of postgres 10.6 Pavan Kumar <pavan.dba27@gmail.com>
@ 2019-02-12 06:02 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
3 siblings, 0 replies; 5+ messages in thread
From: Shreeyansh Dba @ 2019-02-12 06:02 UTC (permalink / raw)
To: Pavan Kumar <pavan.dba27@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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 <pavan.dba27@gmail.com> 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.
>
> --
>
>
>
> *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 *
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: installation of postgres 10.6
2019-02-11 18:37 installation of postgres 10.6 Pavan Kumar <pavan.dba27@gmail.com>
@ 2019-02-12 08:05 ` Laurenz Albe <laurenz.albe@cybertec.at>
3 siblings, 0 replies; 5+ messages in thread
From: Laurenz Albe @ 2019-02-12 08:05 UTC (permalink / raw)
To: Pavan Kumar <pavan.dba27@gmail.com>; pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2019-02-12 08:05 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-02-11 18:37 installation of postgres 10.6 Pavan Kumar <pavan.dba27@gmail.com>
2019-02-11 18:57 ` Pepe TD Vo <pepevo@yahoo.com>
2019-02-11 19:07 ` Ron <ronljohnsonjr@gmail.com>
2019-02-12 06:02 ` Shreeyansh Dba <shreeyansh2014@gmail.com>
2019-02-12 08:05 ` Laurenz Albe <laurenz.albe@cybertec.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox