pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres build doc
7+ messages / 5 participants
[nested] [flat]
* Postgres build doc
@ 2024-05-13 03:54 Naveed Iftikhar <naveed27c@yahoo.com>
0 siblings, 2 replies; 7+ messages in thread
From: Naveed Iftikhar @ 2024-05-13 03:54 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Hi Experts,
I am an Oracle DBA and adopting the PostgreSQL database. Our core Operating system platform is RHEL (Linux). Can someone please share any PostgreSQL Build document where the requirement filesystem, environment variables, build process , monitoring and extension details are documented from engineering standpoint which I can related to my own needs.
Appreciate the help and response.
Best Regards -Naveed-
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgres build doc
@ 2024-05-13 07:30 Kashif Zeeshan <kashi.zeeshan@gmail.com>
parent: Naveed Iftikhar <naveed27c@yahoo.com>
1 sibling, 2 replies; 7+ messages in thread
From: Kashif Zeeshan @ 2024-05-13 07:30 UTC (permalink / raw)
To: Naveed Iftikhar <naveed27c@yahoo.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Hi
Please follow the below guide, it contains all the information you need.
https://www.postgresql.org/docs/current/installation.html
Thanks
Kashif Zeeshan
Bitnine Global
On Mon, May 13, 2024 at 12:07 PM Naveed Iftikhar <naveed27c@yahoo.com>
wrote:
> Hi Experts,
>
> I am an Oracle DBA and adopting the PostgreSQL database. Our core
> Operating system platform is RHEL (Linux). Can someone please share any
> PostgreSQL Build document where the requirement filesystem, environment
> variables, build process , monitoring and extension details are documented
> from engineering standpoint which I can related to my own needs.
>
> Appreciate the help and response.
>
>
>
> Best Regards
> -Naveed-
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgres build doc
@ 2024-05-13 12:48 Ron Johnson <ronljohnsonjr@gmail.com>
parent: Kashif Zeeshan <kashi.zeeshan@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: Ron Johnson @ 2024-05-13 12:48 UTC (permalink / raw)
To: Kashif Zeeshan <kashi.zeeshan@gmail.com>; +Cc: Naveed Iftikhar <naveed27c@yahoo.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Telling someone to build from source when perfectly functional RPM packages
exist is IMNSHO bad advice.
On Mon, May 13, 2024 at 3:31 AM Kashif Zeeshan <kashi.zeeshan@gmail.com>
wrote:
> Hi
>
> Please follow the below guide, it contains all the information you need.
>
> https://www.postgresql.org/docs/current/installation.html
>
> Thanks
> Kashif Zeeshan
> Bitnine Global
>
> On Mon, May 13, 2024 at 12:07 PM Naveed Iftikhar <naveed27c@yahoo.com>
> wrote:
>
>> Hi Experts,
>>
>> I am an Oracle DBA and adopting the PostgreSQL database. Our core
>> Operating system platform is RHEL (Linux). Can someone please share any
>> PostgreSQL Build document where the requirement filesystem, environment
>> variables, build process , monitoring and extension details are documented
>> from engineering standpoint which I can related to my own needs.
>>
>> Appreciate the help and response.
>>
>>
>>
>> Best Regards
>> -Naveed-
>>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgres build doc
@ 2024-05-13 13:06 Ron Johnson <ronljohnsonjr@gmail.com>
parent: Naveed Iftikhar <naveed27c@yahoo.com>
1 sibling, 1 reply; 7+ messages in thread
From: Ron Johnson @ 2024-05-13 13:06 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Mon, May 13, 2024 at 3:07 AM Naveed Iftikhar <naveed27c@yahoo.com> wrote:
> Hi Experts,
>
> I am an Oracle DBA and adopting the PostgreSQL database. Our core
> Operating system platform is RHEL (Linux). Can someone please share any
> PostgreSQL Build document where the requirement filesystem, environment
> variables, build process , monitoring and extension details are documented
> from engineering standpoint which I can related to my own needs.
>
The RHEL repository links are here:
https://www.postgresql.org/download/linux/redhat/
Install PG just like any other RPM package. Part of the process creates
user "postgres" with $HOME in /var/lib/pgsql. It also creates
~postgres/.pgsql_profile. That's where "all" (there aren't many)
environment variables go.
If, for example, you're using Postgresql 16, I would make mount points
named:
/Database/16
/Database/16/backups
/var/log/postgresql
There are no hard+fast rules, though. If you don't like /Database, put it
somewhere else. /var/lib/pgsql/16 works fine, too.
/Database and everything under it should be owned by postgres:postgres.
Then "mkdir /Database/16/data", and then "initdb -D /Database/16/data".
Define and export environment variable PGDATA=/Database/16/data in
~postgres/.pgsql_profile.
THE configuration file is $PGDATA/postgresql.conf. You'll need to modify
the log_directory entry to be /var/log/postgresql (or wherever you decide
to put it). I would *not* leave it in it's default $PGDATA/data/pg_log,
since everything in and under $PGDATA gets replicated, and you don't want
your logs replicated.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgres build doc
@ 2024-05-13 16:35 Wells Oliver <wells.oliver@gmail.com>
parent: Ron Johnson <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Wells Oliver @ 2024-05-13 16:35 UTC (permalink / raw)
To: Ron Johnson <ronljohnsonjr@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Do people really still build from source these days? Are there highly
secured environments where binary repositories etc are a no-go?
On Mon, May 13, 2024 at 6:07 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
> On Mon, May 13, 2024 at 3:07 AM Naveed Iftikhar <naveed27c@yahoo.com>
> wrote:
>
>> Hi Experts,
>>
>> I am an Oracle DBA and adopting the PostgreSQL database. Our core
>> Operating system platform is RHEL (Linux). Can someone please share any
>> PostgreSQL Build document where the requirement filesystem, environment
>> variables, build process , monitoring and extension details are documented
>> from engineering standpoint which I can related to my own needs.
>>
>
> The RHEL repository links are here:
> https://www.postgresql.org/download/linux/redhat/
>
> Install PG just like any other RPM package. Part of the process creates
> user "postgres" with $HOME in /var/lib/pgsql. It also creates
> ~postgres/.pgsql_profile. That's where "all" (there aren't many)
> environment variables go.
>
> If, for example, you're using Postgresql 16, I would make mount points
> named:
> /Database/16
> /Database/16/backups
> /var/log/postgresql
>
> There are no hard+fast rules, though. If you don't like /Database, put
> it somewhere else. /var/lib/pgsql/16 works fine, too.
>
> /Database and everything under it should be owned by postgres:postgres.
>
> Then "mkdir /Database/16/data", and then "initdb -D /Database/16/data".
> Define and export environment variable PGDATA=/Database/16/data in
> ~postgres/.pgsql_profile.
>
> THE configuration file is $PGDATA/postgresql.conf. You'll need to modify
> the log_directory entry to be /var/log/postgresql (or wherever you decide
> to put it). I would *not* leave it in it's default $PGDATA/data/pg_log,
> since everything in and under $PGDATA gets replicated, and you don't want
> your logs replicated.
>
>
--
Wells Oliver
wells.oliver@gmail.com <wellsoliver@gmail.com>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgres build doc
@ 2024-05-13 16:55 Naveed Iftikhar <naveed27c@yahoo.com>
parent: Kashif Zeeshan <kashi.zeeshan@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: Naveed Iftikhar @ 2024-05-13 16:55 UTC (permalink / raw)
To: Kashif Zeeshan <kashi.zeeshan@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Thanks a lot for advise.
Best Regards -Naveed-
On Monday, May 13, 2024 at 12:31:05 AM PDT, Kashif Zeeshan <kashi.zeeshan@gmail.com> wrote:
Hi
Please follow the below guide, it contains all the information you need.
https://www.postgresql.org/docs/current/installation.html
ThanksKashif ZeeshanBitnine Global
On Mon, May 13, 2024 at 12:07 PM Naveed Iftikhar <naveed27c@yahoo.com> wrote:
Hi Experts,
I am an Oracle DBA and adopting the PostgreSQL database. Our core Operating system platform is RHEL (Linux). Can someone please share any PostgreSQL Build document where the requirement filesystem, environment variables, build process , monitoring and extension details are documented from engineering standpoint which I can related to my own needs.
Appreciate the help and response.
Best Regards -Naveed-
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Postgres build doc
@ 2024-05-15 07:36 Norbert Poellmann <np@ibu.de>
parent: Wells Oliver <wells.oliver@gmail.com>
0 siblings, 0 replies; 7+ messages in thread
From: Norbert Poellmann @ 2024-05-15 07:36 UTC (permalink / raw)
To: Wells Oliver <wells.oliver@gmail.com>; +Cc: Ron Johnson <ronljohnsonjr@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Mon, May 13, 2024 at 09:35:02AM -0700, Wells Oliver wrote:
> Do people really still build from source these days? Are there highly
> secured environments where binary repositories etc are a no-go?
In FreeBSD's ports system https://docs.freebsd.org/en/books/handbook/ports/
most applications were build by a full patch/configure/make/install
process. For a short comparison of pro/cons of installing from ports
vs. from pre-compiled packages, see there.
cheers
Norbert Poellmann.
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2024-05-15 07:36 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-05-13 03:54 Postgres build doc Naveed Iftikhar <naveed27c@yahoo.com>
2024-05-13 07:30 ` Kashif Zeeshan <kashi.zeeshan@gmail.com>
2024-05-13 12:48 ` Ron Johnson <ronljohnsonjr@gmail.com>
2024-05-13 16:55 ` Naveed Iftikhar <naveed27c@yahoo.com>
2024-05-13 13:06 ` Ron Johnson <ronljohnsonjr@gmail.com>
2024-05-13 16:35 ` Wells Oliver <wells.oliver@gmail.com>
2024-05-15 07:36 ` Norbert Poellmann <np@ibu.de>
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