PostgreSQL and local HDD
Hello, Why is the PostgreSQL database slow when it is on the server's hard drive? My servers are HPE ProLiant DL380p G8 and HPE ProLiant DL380 G9. Does the database have to be on a storage like EMC or QNAP? Does PostgreSQL have an option to increase speed? Thank you.
PostgreSQL and GUI management
Hello,Does PostgreSQL have a graphical environment for management or is it only managed through CLI? Thank you.
Re: AW: PostgreSQL and GUI management
Hello,Thank you so much for your reply.Is it free?Has it met all your needs? Sent from Yahoo Mail on Android On Tue, Aug 15, 2023 at 6:40 PM, [Quipsy] Markus Karg wrote: I am using pg_admin in the browser, and it works rather fine for me. -Markus Von: Jason Long Gesendet: Dienstag, 15. August 2023 17:09 An: pgsql-general@lists.postgresql.org Betreff: PostgreSQL and GUI management Hello, Does PostgreSQL have a graphical environment for management or is it only managed through CLI? Thank you.
PostgreSQL Guard
Hello, I have some questions about the PostgreSQL database: 1- If I want to distribute the PostgreSQL database on several servers at the same time. what should I do? Something similar to high availability. 2- Is there any special guard to protect PostgreSQL? Thank you.
Re: PostgreSQL Guard
Hi,1- Both split-brain protection and security. Any tool? 2- Consider a database related to a website, which data is regularly entered. Now you want to transfer this database to another server. What's the solution? On Tue, Feb 27, 2024 at 5:39 PM, Ron Johnson wrote: On Tue, Feb 27, 2024 at 3:43 AM Jason Long wrote: Hello, I have some questions about the PostgreSQL database: 1- If I want to distribute the PostgreSQL database on several servers at the same time. what should I do? Something similar to high availability. HA replication is native in Postgresql. 2- Is there any special guard to protect PostgreSQL? Guard, as in protection from a split-brain?
Re: PostgreSQL Guard
Hi,Should I read https://www.postgresql.org/docs/current/warm-standby.html#STANDBY-SERVER-SETUP for question number 2? On Tue, Feb 27, 2024 at 7:28 PM, Adrian Klaver wrote: On 2/27/24 07:08, Jason Long wrote: > Hi, > 1- Both split-brain protection and security. Any tool? > > 2- Consider a database related to a website, which data is regularly > entered. Now you want to transfer this database to another server. > What's the solution? https://www.postgresql.org/docs/current/high-availability.html -- Adrian Klaver adrian.kla...@aklaver.com
Re: PostgreSQL Guard
Hi,Do I have to run this command on the server where the main database is located? Suppose you want to transfer the database of a website like Amazon.com to a new server and delete the old one. Many users are buying and selling on this website at the same time and it is not possible to turn off the server. What do you do to move a database to another server? On Tue, Feb 27, 2024 at 9:30 PM, Ron Johnson wrote: I used this web page to implement hot standby via physical streaming. This command sets up everything for you:pg_basebackup \ --pgdata=$PGDATA \ --dbname=service=basebackup \ --verbose --progress \ --checkpoint=fast \ --write-recovery-conf \ --wal-method=stream \ --create-slot --slot=pgstandby1 \ --compress=server-zstd I got it from https://www.tecmint.com/configure-postgresql-streaming-replication-in-centos-8/, which I encourage you to read. For guarding, and situations with a minimal RTO SLA, I use PgPool-II to manage the cluster, automatic failover and Virtual IP address. Note that only two database servers are needed. Install PgPool on the two DB servers, and a third, smaller system. There are other products which do the same thing as PgPool, and you might find them better. On Tue, Feb 27, 2024 at 12:00 PM Jason Long wrote: Hi,Should I read https://www.postgresql.org/docs/current/warm-standby.html#STANDBY-SERVER-SETUP for question number 2? On Tue, Feb 27, 2024 at 7:28 PM, Adrian Klaver wrote: On 2/27/24 07:08, Jason Long wrote: > Hi, > 1- Both split-brain protection and security. Any tool? > > 2- Consider a database related to a website, which data is regularly > entered. Now you want to transfer this database to another server. > What's the solution? https://www.postgresql.org/docs/current/high-availability.html -- Adrian Klaver adrian.kla...@aklaver.com
PostgreSQL Read-only mode usage
Hello, What is the use of a database in read-only mode? Thank you.
Re: PostgreSQL Guard
Hi,Thanks again.I have another questions: 1- Should I just install PostgreSQL normally on the Standby server? 2- Are the steps the same for other Linux distributions like Debian? On Wed, Feb 28, 2024 at 9:29 AM, Ron Johnson wrote: As before, I encourage you to read https://www.tecmint.com/configure-postgresql-streaming-replication-in-centos-8/. On Tue, Feb 27, 2024 at 3:48 PM Jason Long wrote: Hi,Do I have to run this command on the server where the main database is located? Suppose you want to transfer the database of a website like Amazon.com to a new server and delete the old one. Many users are buying and selling on this website at the same time and it is not possible to turn off the server. What do you do to move a database to another server? On Tue, Feb 27, 2024 at 9:30 PM, Ron Johnson wrote: I used this web page to implement hot standby via physical streaming. This command sets up everything for you:pg_basebackup \ --pgdata=$PGDATA \ --dbname=service=basebackup \ --verbose --progress \ --checkpoint=fast \ --write-recovery-conf \ --wal-method=stream \ --create-slot --slot=pgstandby1 \ --compress=server-zstd I got it from https://www.tecmint.com/configure-postgresql-streaming-replication-in-centos-8/, which I encourage you to read. For guarding, and situations with a minimal RTO SLA, I use PgPool-II to manage the cluster, automatic failover and Virtual IP address. Note that only two database servers are needed. Install PgPool on the two DB servers, and a third, smaller system. There are other products which do the same thing as PgPool, and you might find them better. On Tue, Feb 27, 2024 at 12:00 PM Jason Long wrote: Hi,Should I read https://www.postgresql.org/docs/current/warm-standby.html#STANDBY-SERVER-SETUP for question number 2? On Tue, Feb 27, 2024 at 7:28 PM, Adrian Klaver wrote: On 2/27/24 07:08, Jason Long wrote: > Hi, > 1- Both split-brain protection and security. Any tool? > > 2- Consider a database related to a website, which data is regularly > entered. Now you want to transfer this database to another server. > What's the solution? https://www.postgresql.org/docs/current/high-availability.html -- Adrian Klaver adrian.kla...@aklaver.com
Re: PostgreSQL Read-only mode usage
Hi,1- What does it mean, not the whole database? 2- Can this be considered a kind of guard? 3- Can you tell me a read-only scenario? For example, if we have three servers, then one of the servers can be the main server and the other two servers can be read only. On Wed, Feb 28, 2024 at 4:24 PM, Francisco Olarte wrote: On Wed, 28 Feb 2024 at 13:34, Jason Long wrote: > What is the use of a database in read-only mode? Normally it is a connection/session to the database what is in read-only mode, not the whole database. As it has been pointed out, you connect in read only mode to read, so you are protected from accidental modifications. Also, knowing your transactions are not going to write make life easier for optimizers and other things. Francisco Olarte.
Re: Moving PostgreSQL servers to a new server
Hello,I have the same question. I hope someone can answer this question clearly. On Wed, Feb 28, 2024 at 10:04 PM, normandavis1990 wrote: Hi,I am new to PostgreSQL. My scenario is as follows: https://cdn.bloghunch.com/uploads/uNxNoi5uVKeDibd5.webp I have a Master server and two Replica (Replica-1 and Replica-2) servers. One of these Replica servers is in read-only mode and a report is prepared from it using Microsoft PowerBI. Due to a series of issues, I want to transfer the Master server and one of the Replica servers to other servers in two steps, but I don't want to have any interruptions. A) Assuming PostgreSQL is installed on the new server, what should I do first to migrate the Master? Please show me a tutorial and share your experiences. B) After transferring the Master, I want to transfer one of the Replica servers. What should I do to transfer this server? Cheers.
PostgreSQL hardening best practice
Hello,There are many articles on the internet to secure PostgreSQL, but which one is valid and up-to-date! Please introduce a suitable article. Thank you.
