Re: Getting error while upgrading postgres from version 12 to 13

2023-03-18 Thread David G. Johnston
On Sat, Mar 18, 2023 at 7:27 PM shashidhar Reddy < shashidharreddy...@gmail.com> wrote: > Can someone please help me with this? > >> >> You haven't given others enough information to help you. Present to the fullest extent possible your current environment and the commands you are running. Showi

Re: Getting error while upgrading postgres from version 12 to 13

2023-03-18 Thread Adrian Klaver
On 3/18/23 19:26, shashidhar Reddy wrote: Can someone please help me with this? You have already been helped: https://www.postgresql.org/message-id/ba59dd9b-6a87-ebff-c041-2dbcffe74a89%40sourcepole.ch "You have configured the postgres v12 server to use a directory where there are data from a

Re: Getting error while upgrading postgres from version 12 to 13

2023-03-18 Thread shashidhar Reddy
Can someone please help me with this? On Sun, 19 Mar, 2023, 2:54 am shashidhar Reddy, < shashidharreddy...@gmail.com> wrote: > and adding to this the following is also showing in the error, we tried > changing the file permissions but still no luck > FATAL: could not load private key file > "/et

Re: Properly handle OOM death?

2023-03-18 Thread Jeffrey Walton
On Sat, Mar 18, 2023 at 6:02 PM Tomas Pospisek wrote: > > On 13.03.23 21:25, Joe Conway wrote: > > > Hmm, well big +1 for having swap turned on, but I recommend setting > > "vm.overcommit_memory=2" even so. > > I've snipped out the context here, since my advice is very unspecific: > do use swap on

Re: Properly handle OOM death?

2023-03-18 Thread Tomas Pospisek
On 13.03.23 21:25, Joe Conway wrote: Hmm, well big +1 for having swap turned on, but I recommend setting "vm.overcommit_memory=2" even so. I've snipped out the context here, since my advice is very unspecific: do use swap only as a safety net. Once your system starts swapping performance goe

Re: Can't connect to server

2023-03-18 Thread Jeff Janes
On Sat, Mar 18, 2023 at 2:11 AM Wu, Abigaile wrote: > I am writing to seek your assistance with a problem I am facing while > using pgAdmin4. After downloading the PostgreSQL 15, I downloaded the > latest version of Pgadmin 4 and then I click the server and choose > PostgreSQL 15. Whenever I try

Re: Getting error while upgrading postgres from version 12 to 13

2023-03-18 Thread Tomas Pospisek
On Sun, Mar 19, 2023 at 2:09 AM shashidhar Reddy mailto:shashidharreddy...@gmail.com>> wrote: Hello, I am in a process of upgrading postgresql from version 12 to 13 using pg_upgrdrade but I am getting error stating  FATAL:  database files are incompatible with server  DET

Re: Getting error while upgrading postgres from version 12 to 13

2023-03-18 Thread Tomas Pospisek
On 18.03.23 22:24, shashidhar Reddy wrote: and adding to this the following is also showing in the error, we tried changing the file permissions but still no luck FATAL:  could not load private key file "/etc/ssl/private/ssl-cert-snakeoil.key": key values mismatch This sounds like the private

Re: Getting error while upgrading postgres from version 12 to 13

2023-03-18 Thread shashidhar Reddy
and adding to this the following is also showing in the error, we tried changing the file permissions but still no luck FATAL: could not load private key file "/etc/ssl/private/ssl-cert-snakeoil.key": key values mismatch On Sun, Mar 19, 2023 at 2:09 AM shashidhar Reddy < shashidharreddy...@gmail.

Re: Getting error while upgrading postgres from version 12 to 13

2023-03-18 Thread Ron
On 3/18/23 15:39, shashidhar Reddy wrote: Hello, I am in a process of upgrading postgresql from version 12 to 13 using pg_upgrdrade but I am getting error stating  FATAL:  database files are incompatible with server  DETAIL:  The data directory was initialized by PostgreSQL version 13 , which

Getting error while upgrading postgres from version 12 to 13

2023-03-18 Thread shashidhar Reddy
Hello, I am in a process of upgrading postgresql from version 12 to 13 using pg_upgrdrade but I am getting error stating FATAL: database files are incompatible with server DETAIL: The data directory was initialized by PostgreSQL version 13 , which is not compatible with this version 12.14 (Ub

Re: Delete values from JSON

2023-03-18 Thread Andreas Joseph Krogh
Excellent! Thanks! På lørdag 18. mars 2023 kl. 14:26:57, skrev Boris Zentner mailto:b...@2bz.de>>: Am 17.03.2023 um 08:56 schrieb Andreas Joseph Krogh : Hi, in PG-14, how do I delete the keys "dunsNumber": "NaN": { "sessionId": "ce6fc9d0-5923-4d71-9f7e-ae60f35c45d6", "details": [ {

Re: Can't connect to server

2023-03-18 Thread Adrian Klaver
On 3/17/23 23:10, Wu, Abigaile wrote: I am writing to seek your assistance with a problem I am facing while using pgAdmin4. After downloading the PostgreSQL 15, I downloaded the latest version of Pgadmin 4 and then I click the server and choose PostgreSQL 15. Whenever I try to log in to the ser

Re: Delete values from JSON

2023-03-18 Thread Boris Zentner
> Am 17.03.2023 um 08:56 schrieb Andreas Joseph Krogh : > > Hi, in PG-14, how do I delete the keys "dunsNumber": "NaN": > > { > "sessionId": "ce6fc9d0-5923-4d71-9f7e-ae60f35c45d6", > "details": [ > { > "keyInformation": { > "dunsNumber": "NaN", > "organizationType

Re: Can't connect to server

2023-03-18 Thread Romain Mazière - SIGMAZ Consilium
Hi, As I can see in the error message : "localhost" (::1), port 5432 failed: FATAL: password authentication failed for user "postgres"." Pgadmin4 try to connect via the loopback in IPv6 (::1) and fail for postgres user. Have a look to pg_hba.conf, the file which describes access to postgres clus