Not to come in too late, but have you tried the non-ubuntu:
sudo su
su -m postgres
pg_ctl -D /var/lib/postgresql/9.3/main start
cheers
Ben
On 29 March 2018 at 12:20, Adrian Klaver wrote:
> On 03/28/2018 07:29 PM, Ken Beck wrote:
>
> Comments in line.
>
> The current log is 0 length, and in
On 03/28/2018 07:29 PM, Ken Beck wrote:
Comments in line.
The current log is 0 length, and indeed empty.
I just tried 'sudo pg_ctlcluster 9.3 main start' and got the following
error:
Error: Config owner (kcb:1000) and data owner (postgres:116) do not
match, and config owner is not root
So
On Wed, Mar 28, 2018 at 7:29 PM, Ken Beck wrote:
> Is it possible a big problem is that the password for user postgres not
> longer works for some reason, not sure why. It appears the password can
> not be rest or changed without knowing the original, and what I thought
> was the original no long
On 03/28/2018 08:29 PM, Ken Beck wrote:
Is it possible a big problem is that the password for user postgres not
longer works for some reason, not sure why. It appears the password can
not be rest or changed without knowing the original, and what I thought
was the original no longer works.
Ma
The current log is 0 length, and indeed empty.
I just tried 'sudo pg_ctlcluster 9.3 main start' and got the following
error:
Error: Config owner (kcb:1000) and data owner (postgres:116) do not
match, and config owner is not root
Changed to user postgres, tried again and got:
Warning: the clust
On 03/28/2018 03:45 PM, Ken Beck wrote:
Thanks for both responses -- the file contents I sent were from file
named postgresql-9.3-main.log.1, and I am assuming this means from the
Well that is an archived log and would show old information. The current
log would be postgresql-9.3-main.log.
Thanks for both responses -- the file contents I sent were from file
named postgresql-9.3-main.log.1, and I am assuming this means from the
9.3, not 9.6. Sorry I did not include that earlier. Starting to sousnds
like I need to consult Ubuntu user groups.
Ken Beck
Liberty, Utah, USA
On 03/28/2018
Il 28/03/2018 18:28, Adrian Klaver ha scritto:
On 03/28/2018 09:24 AM, Moreno Andreo wrote:
Il 27/03/2018 22:57, Adrian Klaver ha scritto:
On 03/27/2018 01:46 PM, Ken Beck wrote:
I am working on two systems, one running in Oracle VirtualBox on my
laptop, the other in a DigitalOcean droplet. I
On 03/28/2018 09:24 AM, Moreno Andreo wrote:
Il 27/03/2018 22:57, Adrian Klaver ha scritto:
On 03/27/2018 01:46 PM, Ken Beck wrote:
I am working on two systems, one running in Oracle VirtualBox on my
laptop, the other in a DigitalOcean droplet. I know on one of them I
tried to remove the postgr
Il 27/03/2018 22:57, Adrian Klaver ha scritto:
On 03/27/2018 01:46 PM, Ken Beck wrote:
I am working on two systems, one running in Oracle VirtualBox on my
laptop, the other in a DigitalOcean droplet. I know on one of them I
tried to remove the postgres-9.6, and it must have been my laptop, here
On 03/27/2018 01:46 PM, Ken Beck wrote:
I am working on two systems, one running in Oracle VirtualBox on my
laptop, the other in a DigitalOcean droplet. I know on one of them I
tried to remove the postgres-9.6, and it must have been my laptop, here
is the output from pg_lsclusters:
Ver Cluster P
Ken Beck writes:
> I recently upgraded my OS from Ubuntu 14.04 LTS to 16.04 LTS and since,
> postgresql refuses to re-start. I am concerned that if I poke around too
> much, I may lose my old data. I have consulted various web postings here
> and in ubuntu forums, and have not found an obvious s
I am working on two systems, one running in Oracle VirtualBox on my
laptop, the other in a DigitalOcean droplet. I know on one of them I
tried to remove the postgres-9.6, and it must have been my laptop, here
is the output from pg_lsclusters:
Ver Cluster Port Status Owner Data directory
OK, there are some logs there, most have old date/time stamps. But there
is one with today's time on it, but all it has is week-old data, likely
from near the time I did the Ubuntu upgrade. The following entry makes
me worry (it is about 2/3 of the way down...)
2018-03-22 10:14:28 MDT LOG: databa
On 03/27/2018 11:00 AM, Ken Beck wrote:
I recently upgraded my OS from Ubuntu 14.04 LTS to 16.04 LTS and since,
postgresql refuses to re-start. I am concerned that if I poke around too
much, I may lose my old data. I have consulted various web postings here
and in ubuntu forums, and have not foun
Il 27/03/2018 20:00, Ken Beck ha scritto:
And, looking for log files, I find none.
Have you looked in /var/log/postgresql/ ?
On 03/27/2018 11:00 AM, Ken Beck wrote:
And, looking for log files, I find none.
Nothing in /var/log/postgresql or /var/lib/postgresql/9.3/main/pg_log?
JD
--
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc
*** A fault and talent of mine is to tell it exactly how it is.
I recently upgraded my OS from Ubuntu 14.04 LTS to 16.04 LTS and since,
postgresql refuses to re-start. I am concerned that if I poke around too
much, I may lose my old data. I have consulted various web postings here
and in ubuntu forums, and have not found an obvious solution. But please
excuse m
18 matches
Mail list logo
