Sfrgttk

Build ASCII Podiums

Why don't programs completely uninstall (remove all their files) when I remove them?

Is Screenshot Time-tracking Common?

Cryptic cross... with words

Minimum energy path of a potential energy surface

How can guns be countered by melee combat without raw-ability or exceptional explanations?

How to typeset a small black square as a binary operator?

Why does this quiz question say that protons and electrons do not combine to form neutrons?

Why write a book when there's a movie in my head?

Can I do anything else with aspersions other than cast them?

Is layered encryption more secure than long passwords?

Why do we interpret the accelerated expansion of the universe as the proof for the existence of dark energy?

Are all power cords made equal?

How can changes in personality/values of a person who turned into a vampire be explained?

Sets which are both Sum-free and Product-free.

How do I split ammo?

Why is Bernie Sanders maximum accepted donation on actblue $5600?

Is there any danger of my neighbor having my wife's signature?

What does it mean when an external ID field follows a DML Statement?

Euler and minus sign

A cancellation property for permutations?

Badly designed reimbursement form. What does that say about the company?

How can a kingdom keep the secret of a missing monarch from the public?

When distributing a Linux kernel driver as source code, what's the difference between Proprietary and GPL license?

Ideal way to start 'Database Server' in PostgreSQL 11

PostgreSQL 9.1 Hot Backup Error: the database system is starting upPostgresql - Segmentation fault (core dumped)which postgres do i have installed? what directory needs to be in my path to run initdb?Moving postgresql data directorypg_upgrade unrecognized configuration parameter “unix_socket_directory”runuser error on CentOS 7 Postgres 9.4Upgrade from Postgres 9.3 to 9.5pg_ctl won't start postgresParse error in pg_hba.confpsql: FATAL: role “postgres” does not exist

0

PostgreSQL version : 11.2
OS : RHEL 7.5

I am new to PostgreSQL.
I would like to know which is the ideal way to start 'Database server' . In Oracle world, we call this starting the instance.

Should I be using Option A or Option B ?

Option A. As root user , run

# systemctl start postgresql-11

Option B. As postgres user, run

$ postgres -D /var/lib/pgsql/11/data

NB: For Option B, PostgreSQL 11's official doc mentions a different directory (/usr/local/pgsql/data) as shown below . Maybe the doc not updated.

$ postgres -D /usr/local/pgsql/data

https://www.postgresql.org/docs/11/server-start.html

postgresql

share

asked 1 min ago

Keith BrabantKeith Brabant

1

New contributor

Keith Brabant is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

PostgreSQL version : 11.2
OS : RHEL 7.5

I am new to PostgreSQL.
I would like to know which is the ideal way to start 'Database server' . In Oracle world, we call this starting the instance.

Should I be using Option A or Option B ?

Option A. As root user , run

# systemctl start postgresql-11

Option B. As postgres user, run

$ postgres -D /var/lib/pgsql/11/data

NB: For Option B, PostgreSQL 11's official doc mentions a different directory (/usr/local/pgsql/data) as shown below . Maybe the doc not updated.

$ postgres -D /usr/local/pgsql/data

https://www.postgresql.org/docs/11/server-start.html

postgresql

share

asked 1 min ago

Keith BrabantKeith Brabant

1

New contributor

Keith Brabant is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

PostgreSQL version : 11.2
OS : RHEL 7.5

I am new to PostgreSQL.
I would like to know which is the ideal way to start 'Database server' . In Oracle world, we call this starting the instance.

Should I be using Option A or Option B ?

Option A. As root user , run

# systemctl start postgresql-11

Option B. As postgres user, run

$ postgres -D /var/lib/pgsql/11/data

NB: For Option B, PostgreSQL 11's official doc mentions a different directory (/usr/local/pgsql/data) as shown below . Maybe the doc not updated.

$ postgres -D /usr/local/pgsql/data

https://www.postgresql.org/docs/11/server-start.html

postgresql

share

asked 1 min ago

Keith BrabantKeith Brabant

1

New contributor

Keith Brabant is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

# systemctl start postgresql-11

$ postgres -D /var/lib/pgsql/11/data

$ postgres -D /usr/local/pgsql/data

share

asked 1 min ago

Keith BrabantKeith Brabant

1

New contributor

Keith Brabant is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 1 min ago

Keith BrabantKeith Brabant

1

New contributor

Keith Brabant is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 1 min ago

Keith BrabantKeith Brabant

1

New contributor

Keith Brabant is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 1 min ago

Keith BrabantKeith Brabant

1