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
Hello,
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 Thu 2019-06-06 09:36:32 EDT; 12min ago
If we chang
16 matches
Mail list logo
