Thank you so much for your help!
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Monday, October 14, 2019 2:19 PM
To: Lu, Dan
Cc: Christopher Browne ; Francisco Olarte
; pgsql-gene...@postgresql.org
Subject: Re: Postgres 10.7 Systemd Startup Issue
"Lu
, June 07, 2019 3:22 PM
To: 'Tom Lane'
Cc: 'Christopher Browne' ; 'Francisco Olarte'
; Kelly, Kevin ;
'pgsql-gene...@postgresql.org'
Subject: RE: Postgres 10.7 Systemd Startup Issue
Hello All,
I ended up removing all configuration. Re-unzip the binary tar
"Lu, Dan" writes:
> Is there a catalog view that I can query to see what options were used
> to configure the PG instance?
No, but pg_config should tell you.
regards, tom lane
On 2019-06-07 12:45:36 +, Lu, Dan wrote:
> Thank you so much for pointing that out.
>
> I downloaded the binary from https://ftp.postgresql.org/pub/source/v10.7
^^
source, obviously.
> After download, I did the following.
>
> mkdir /hostname/pg/P
M
To: 'Tom Lane'
Cc: Christopher Browne ; Francisco Olarte
; Kelly, Kevin ;
pgsql-gene...@postgresql.org
Subject: RE: Postgres 10.7 Systemd Startup Issue
I apologize, it was a copy/paste error. I did include the option
"--with-systemd".
This is our first install of postg
Lu:
On Fri, Jun 7, 2019 at 3:48 PM Lu, Dan wrote:
> Even with the added option “—with-systemd”, it is not working still.
> Status remains “ Active: activating (start) since Fri 2019-06-07 09:40:06
> EDT; 13s ago”.
> To outline what I did.
> 1) Stop PostgreSQL instance running with “/hostname/
SQL Server and MySQL in production so
far.
Dan
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Friday, June 07, 2019 10:04 AM
To: Lu, Dan
Cc: Christopher Browne ; Francisco Olarte
; Kelly, Kevin ;
pgsql-gene...@postgresql.org
Subject: Re: Postgres 10.7 Systemd Startup
"Lu, Dan" writes:
> Even with the added option “—with-systemd”, it is not working still.
Hmmm
> To outline what I did.
> 2) Configure PostgreSQL to new location
> mkdir /hostname/pg/PostgreSQL-10.7_2
> ./configure --prefix=/hostname/pg/PostgreSQL-10.7_2
Is it just a copy-and-paste mistak
/hostname/pg/PostgreSQL-10.7
3) Start PostgreSQL instance
Any more suggestion?
Dan
From: Lu, Dan
Sent: Friday, June 07, 2019 8:46 AM
To: 'Christopher Browne' ; Tom Lane
Cc: Francisco Olarte ; Kelly, Kevin
; pgsql-gene...@postgresql.org
Subject: RE: Postgres 10.7 Systemd Startup Issue
Th
[mailto:cbbro...@gmail.com]
Sent: Thursday, June 06, 2019 9:19 PM
To: Tom Lane
Cc: Francisco Olarte ; Kelly, Kevin
; pgsql-gene...@postgresql.org; Lu, Dan
Subject: Re: Postgres 10.7 Systemd Startup Issue
On Thu, Jun 6, 2019, 8:19 PM Tom Lane
mailto:t...@sss.pgh.pa.us>> wrote:
Francisco
Tom:
On Fri, Jun 7, 2019 at 2:19 AM Tom Lane wrote:
> Francisco Olarte writes:
> > On Thu, Jun 6, 2019 at 6:57 PM Kelly, Kevin wrote:
> > and is running, notify means it does systemd integration via socket,
> > with IIRC postgres does not.
>
> I might be confusing this with some other issue, b
On Thu, Jun 6, 2019, 8:19 PM Tom Lane wrote:
> Francisco Olarte writes:
> > On Thu, Jun 6, 2019 at 6:57 PM Kelly, Kevin wrote:
> >> We’re attempting to launch postgres via systemd and noticing that when
> invoking via systemctl start postgres.service the prompt never returns. If
> we switch to
Francisco Olarte writes:
> On Thu, Jun 6, 2019 at 6:57 PM Kelly, Kevin wrote:
>> We’re attempting to launch postgres via systemd and noticing that when
>> invoking via systemctl start postgres.service the prompt never returns. If
>> we switch to another tty and check the status it shows as:
>>
eaching out!
-Kevin Kelly
-Original Message-
From: Francisco Olarte [mailto:fola...@peoplecall.com]
Sent: Thursday, June 06, 2019 1:44 PM
To: Kelly, Kevin
Cc: pgsql-gene...@postgresql.org; Lu, Dan
Subject: Re: Postgres 10.7 Systemd Startup Issue
On Thu, Jun 6, 2019 at 6:57 PM Kelly, Kevin
On Thu, Jun 6, 2019 at 6:57 PM Kelly, Kevin wrote:
> We’re attempting to launch postgres via systemd and noticing that when
> invoking via systemctl start postgres.service the prompt never returns. If we
> switch to another tty and check the status it shows as:
> Active: activating (start) since
15 matches
Mail list logo
