Re: Upgrading

2023-07-30 Thread Adrian Klaver
On 7/30/23 19:22, Amn Ojee Uw wrote: Thank you Ron and Peter for taking the time to respond to my call for help. In summery, I'd like to use PostgreSQL-15. However, since my Debian 12 already has already PostgreSQL-15 installed, did I inadvertently overwrote PostgreSQL-15 when I installed

Re: Migrating MySQL DB to PostgreSQL DB.

2023-07-30 Thread Tom Browder
On Sun, Jul 30, 2023 at 19:36 Kaushal Shriyan wrote: Thanks Ron for the suggestion. Much appreciated. Are there any PostgreSQL > GUI applications for MacOS, Windows and Linux similar to MySQL Workbench ( > https://www.mysql.com/products/workbench/) ? > Check out Dbeaver (dbeaver.com). -Tom

Re: Upgrading

2023-07-30 Thread Amn Ojee Uw
Thank you Ron and Peter for taking the time to respond to my call for help. In summery, I'd like to use PostgreSQL-15. However, since my Debian 12 already has already PostgreSQL-15 installed, did I inadvertently overwrote PostgreSQL-15 when I installed PostgreSQL-12? If so, how do I remove

Re: Understanding pg_stat_io.evictions

2023-07-30 Thread Kyotaro Horiguchi
At Fri, 28 Jul 2023 10:36:46 +, "Daniel Westermann (DWE)" wrote in > postgres=# insert into t select i, md5(i::text), md5(i::text), md5(i::text) > from generate_series(1,100) i; .. > client backend | 207 | normal > client backend | 0 | vacuum > > Shouldn't these

Re: Migrating MySQL DB to PostgreSQL DB.

2023-07-30 Thread Kaushal Shriyan
On Mon, Jul 31, 2023 at 4:15 AM Ron wrote: > On 7/30/23 09:01, Kaushal Shriyan wrote: > > Hi, > > > > I am running MySQL DB 8.0.34 on Red Hat Enterprise Linux release 8.7 > > (Ootpa). Is there a way to import MySQL DB along with data to PostgreSQL > > 14 database server? > > > > Please suggest.

Re: Migrating MySQL DB to PostgreSQL DB.

2023-07-30 Thread Ron
On 7/30/23 09:01, Kaushal Shriyan wrote: Hi, I am running MySQL DB 8.0.34 on Red Hat Enterprise Linux release 8.7 (Ootpa). Is there a way to import MySQL DB along with data to PostgreSQL 14 database server? Please suggest. Thanks in advance. Depending on the size of the database, the

Re: Migrating MySQL DB to PostgreSQL DB.

2023-07-30 Thread Kaushal Shriyan
Thanks Ken and Adrian for the quick email response. Really appreciate it. Thanks once again Best Regards, Kaushal On Sun, Jul 30, 2023 at 8:23 PM Adrian Klaver wrote: > On 7/30/23 07:11, Ken Marshall wrote: > > On Sun, Jul 30, 2023 at 07:31:02PM +0530, Kaushal Shriyan wrote: > >> Hi, > >> >

Re: Upgrading

2023-07-30 Thread Peter J. Holzer
On 2023-07-30 07:53:54 -0400, Amn Ojee Uw wrote: > On my Debian 12, I installed PostgreSQL-12, Where did you install that from? AFAICS, Debian 12 comes with PostgreSQL 15. > I'd like to upgrade to the latest release of PostgreSQL. So, my > question is, what is the best way to upgrade to the

Re: Migrating MySQL DB to PostgreSQL DB.

2023-07-30 Thread Adrian Klaver
On 7/30/23 07:11, Ken Marshall wrote: On Sun, Jul 30, 2023 at 07:31:02PM +0530, Kaushal Shriyan wrote: Hi, I am running MySQL DB 8.0.34 on Red Hat Enterprise Linux release 8.7 (Ootpa). Is there a way to import MySQL DB along with data to PostgreSQL 14 database server? Please suggest. Thanks

Re: Migrating MySQL DB to PostgreSQL DB.

2023-07-30 Thread Ken Marshall
On Sun, Jul 30, 2023 at 07:31:02PM +0530, Kaushal Shriyan wrote: > Hi, > > I am running MySQL DB 8.0.34 on Red Hat Enterprise Linux release 8.7 > (Ootpa). Is there a way to import MySQL DB along with data to PostgreSQL 14 > database server? > > Please suggest. Thanks in advance. > > Best

Migrating MySQL DB to PostgreSQL DB.

2023-07-30 Thread Kaushal Shriyan
Hi, I am running MySQL DB 8.0.34 on Red Hat Enterprise Linux release 8.7 (Ootpa). Is there a way to import MySQL DB along with data to PostgreSQL 14 database server? Please suggest. Thanks in advance. Best Regards, Kaushal

Re: Upgrading

2023-07-30 Thread Ron
On 7/30/23 06:53, Amn Ojee Uw wrote: Just a quick question. On my Debian 12, I installed PostgreSQL-12, I'd like to upgrade to the latest release of PostgreSQL. So, my question is, what is the best way to upgrade to the next release of PostgreSQL? To the latest release of v12 (which is

Upgrading

2023-07-30 Thread Amn Ojee Uw
Just a quick question. On my Debian 12, I installed PostgreSQL-12, I'd like to upgrade to the latest release of PostgreSQL. So, my question is, what is the best way to upgrade to the next release of PostgreSQL? Thanks in advance.