On 10/27/21 12:51, Jérémy Garniaux wrote:
Adrian,
Le 27/10/2021 à 19:30, Adrian Klaver a écrit :
While you are at it:
sudo pg_dropcluster 12 main
to get rid of the orphaned cluster.
Great, thanks for your help. Everything is back in order now.
I found out about Pg clusters in the process
Adrian,
Le 27/10/2021 à 19:30, Adrian Klaver a écrit :
Your Postgres 13 cluster is up and listening on 5433.
Your choices:
1) Connect using psql -d -U -p 5433
2) Open:
sudo vi /etc/postgresql/13/main/postgresql.conf
and change
port = 5433
to
port = 5432
and then restart server.
Wh
On 10/27/21 9:01 AM, Jérémy Garniaux wrote:
Hi Adrian,
Thanks for answering on both sides!
Same response as to your SO question:
What is the output of pg_lsclusters?
Ver Cluster Port Status Owner Data
directory Log file
12 main 5432 down,binaries_missing
emove --purge postgresql*" and reinstall postgresql-13. Now the
output of "psql --version" is "psql (PostgreSQL) 13.4 (Ubuntu
13.4-1)". However, trying to enter psql, I have this error:
psql: error: could not connect to server: Aucun fichier ou dossier de
ce type
Is
rsion" is "psql (PostgreSQL) 13.4 (Ubuntu 13.4-1)".
However, trying to enter psql, I have this error:
psql: error: could not connect to server: Aucun fichier ou dossier de ce
type
Is the server running locally and accepting
connections on Unix domain socket "/var/run/p
Ubuntu 13.4-1)".
However, trying to enter psql, I have this error:
psql: error: could not connect to server: Aucun fichier ou dossier de ce
type
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
I assume thi
robable cause of the failure.
connection to database failed: could not connect to server: Connection
refused (0x274D/10061)
Is the server running on host "localhost" (::1) and accepting
TCP/IP connections on port 50432?
could not connect to server: Connection refused (0x274D/10061)
Is
On 7/13/20 1:14 PM, FOUTE K. Jaurès wrote:
Hello,
The problem is related to my previous email "PostgreSQL 12 - ERROR:
could not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp"
to "pg_logical/snapshots/1A-7C00D890.snap": No space left on device" .
After stopping the replication p
Hello,
The problem is related to my previous email "PostgreSQL 12 - ERROR: could
not rename file "pg_logical/snapshots/1A-7C00D890.snap.13594.tmp" to
"pg_logical/snapshots/1A-7C00D890.snap": No space left on device" .
After stopping the replication postgresql has restarted to respond.
Le lun. 13
On Mon, Jul 13, 2020, 7:16 PM FOUTE K. Jaurès wrote:
> Hello,
>
> How can i solve this error
>
More info required
Regards,
Seenu.
>
> --
> Jaurès FOUTE
>
Hello,
How can i solve this error ?
--
Jaurès FOUTE
hursday, April 23, 2020 at 5:19 PM
*From:* "Dummy Account"
*To:* "Adrian Klaver"
*Cc:* "pgsql-general" , "David G.
Johnston"
*Subject:* Re: Fw: Re: Could Not Connect To Server
This worked.
sudo su - postgres
I was now able to log into data and ls
Inside
brary/PostgreSQL/12/data/log/postgresql-2020-04-22_171300.log.
Sent: Thursday, April 23, 2020 at 5:19 PM
From: "Dummy Account"
To: "Adrian Klaver"
Cc: "pgsql-general" , "David G. Johnston"
Subject: Re: Fw: Re: Could Not Connect To Server
This worked.
s
On 4/23/20 4:19 PM, Dummy Account wrote:
This worked.
sudo su - postgres
I was now able to log into data and ls
Inside data is "log".
How do I open log?
and got:
LSOpenURLsWithRole() failed with erro -610
I then tried:
log show
and I got:
log: Could not be open local log store: The log archive
"David G. Johnston"
Subject: Re: Fw: Re: Could Not Connect To Server
On 4/23/20 3:03 PM, Dummy Account wrote:
> I cannot login into a postgres role via command line.
> Issue #1.
> I have never done it before via command line, so maybe I am doing it
> incorrectly.
> I have be
On Thu, Apr 23, 2020 at 3:03 PM Dummy Account
wrote:
>
> I cannot login into a postgres role via command line.
>
> Issue #1.
> I have never done it before via command line, so maybe I am doing it
> incorrectly.
> I have been attempting to go:
>
> su - postgres
>
>
The "sudo" in Rob's answer wasn'
PM
*From:* "Adrian Klaver"
*To:* "Dummy Account"
*Cc:* "pgsql-general" , "David G.
Johnston"
*Subject:* Re: Fw: Re: Could Not Connect To Server
On 4/23/20 1:37 PM, Dummy Account wrote:
> From the Finder, I think that is the same a File Explorer on
at pgAdmin calls the "master password".
So even if I did remove the password for "PostgreSQL" server, would I be able to reset one?
Sent: Thursday, April 23, 2020 at 4:26 PM
From: "Adrian Klaver"
To: "Dummy Account"
Cc: "pgsql-general" , "David
On 4/23/20 3:26 PM, Adrian Klaver wrote:
On 4/23/20 1:37 PM, Dummy Account wrote:
From the Finder, I think that is the same a File Explorer on Widows.
From Finder, it's locked; I cannot access it. Could I use the
command line and change ownership or access privledges? And then get
acces
On 4/23/20 1:37 PM, Dummy Account wrote:
From the Finder, I think that is the same a File Explorer on Widows.
From Finder, it's locked; I cannot access it. Could I use the command
line and change ownership or access privledges? And then get access?
Why not from the command line use a text
laver"
To: "Dummy Account" , "pgsql-general" , "David G. Johnston"
Subject: Re: Fw: Re: Could Not Connect To Server
On 4/23/20 1:24 PM, Dummy Account wrote:
> Hey Everyone,
> I did find loggin.h and insallation_summary.log. Neither of which look
> t
?:
log/
And under it for log files?
Thanks
*Sent:* Thursday, April 23, 2020 at 2:32 PM
*From:* "Dummy Account"
*To:* "Adrian Klaver"
*Cc:* "David G. Johnston" , "pgsql-general"
*Subject:* Re: Could Not Connect To Server
Hey David,
Can you tell me the
"
Cc: "David G. Johnston" , "pgsql-general"
Subject: Re: Could Not Connect To Server
Hey David,
Can you tell me the exact name of the log file? Then I can search for it.
Thanks
Sent: Thursday, April 23, 2020 at 2:25 PM
From: "Adrian Klaver"
To:
On 4/23/20 12:36 PM, Rob Sargent wrote:
On 4/23/20 1:32 PM, Dummy Account wrote:
Hey David,
Can you tell me the exact name of the log file? Then I can search for it.
Thanks
Apparently in your case it is called "log". I don't have version 12,
To be clear 'log' is the name of the directory
On 4/23/20 1:32 PM, Dummy Account wrote:
Hey David,
Can you tell me the exact name of the log file? Then I can search for it.
Thanks
Apparently in your case it is called "log". I don't have version 12,
but version 9's start up name "pg_log" and that is the name of the file
in the data dir
Hey David,
Can you tell me the exact name of the log file? Then I can search for it.
Thanks
Sent: Thursday, April 23, 2020 at 2:25 PM
From: "Adrian Klaver"
To: "Dummy Account" , "David G. Johnston"
Cc: "pgsql-general"
Subject: Re: Could
rsday, April 23, 2020 at 1:55 PM
*From:* "David G. Johnston"
*To:* "Dummy Account"
*Cc:* "pgsql-general"
*Subject:* Re: Could Not Connect To Server
On Thu, Apr 23, 2020 at 11:48 AM Dummy Account <mailto:dummyaccoun...@mail.com>> wrote:
But here they are
*is* the entire
and complete log after that command.
Thanks, I appreciate the help.
*Sent:* Thursday, April 23, 2020 at 1:55 PM
*From:* "David G. Johnston"
*To:* "Dummy Account"
*Cc:* "pgsql-general"
*Subject:* Re: Could Not Connect To Server
On Thu, Apr 23, 2020
er that command.
Thanks, I appreciate the help.
Sent: Thursday, April 23, 2020 at 1:55 PM
From: "David G. Johnston"
To: "Dummy Account"
Cc: "pgsql-general"
Subject: Re: Could Not Connect To Server
On Thu, Apr 23, 2020 at 11:48 AM Dummy Account <dummyac
On Thu, Apr 23, 2020 at 11:48 AM Dummy Account
wrote:
> But here they are:
>
> waiting for server to start2020-04-22 15:57:51.766 CDT [5255] LOG:
> starting PostgreSQL 12.2 on x86_64-apple-darwin, compiled by Apple LLVM
> version 6.0 (clang-600.0.54) (based on LLVM 3.5svn), 64-bit
> 2020-04
I restored an Operating System because I changed out my hard drive for a solid state drive; therefore, I had to restore my Operating System from Time Machine/(backup).
Sent: Thursday, April 23, 2020 at 1:26 PM
From: "David G. Johnston"
To: "Dummy Account"
Cc: "pgsql-g
On Thu, Apr 23, 2020 at 11:18 AM Dummy Account
wrote:
>
> Trying to start the server, I navigate too: /Library/PostgreSQL/12/bin
>
> from bin, I ran: sudo -u postgres ./pg_ctl start -D
> /Library/PostgreSQL/12/data
>
> pg_ctl: could not start server
>
>
>
What do the logs say...
When I ran the
Hello,
I am running the following:
MacOS High Sierra 10.13.6
PostgreSQL 12.2
pgAdmin 4
To see my qustion on Stack Overflow with picture:
https://stackoverflow.com/questions/61353989/pgadmin-could-not-connect-to-server-connection-refused
I am trying to view databases with pgAdmin
33 matches
Mail list logo
