Re: [GENERAL] Backup strategy using 'wal_keep_segments'

2017-10-23 Thread Rhhh Lin 
Thanks very much for your reply Michael.

I note that it looks like pgbarman employs pg_receivexlog; I will check it out.


Regards,

Ruan


From: Michael Paquier 
Sent: 22 October 2017 22:17:01
To: Rhhh Lin
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Backup strategy using 'wal_keep_segments'

On Mon, Oct 23, 2017 at 5:57 AM, Rhhh Lin  wrote:
> Is this approach feasible? Assuming obviously, we have sufficient disk space
> to facilitate 1000 WAL files etc.

You expose yourself to race conditions with such methods if a
checkpoint has the bad idea to recycle past segments that your logic
is copying. So I would advise to not do that. Instead of using the
archive command, you should also consider using pg_receivexlog
combined with a replication slot. This brings way more control with
the error handling.
--
Michael

Re: [GENERAL] Two versions of an extension in the same cluster?

2017-10-23 Thread Tom Lane 
Paul Jungwirth  writes:
> I've got an extension that supplies functions written in C. Two 
> databases from the same cluster both use this extension. I understand 
> how I can load the example--2.0.0.sql file in one database, and 
> example--3.0.0.sql in another, but from what I can tell both databases 
> still share the same .so file. Is there any way to provide a separate 
> .so for each version?

Not very easily.  You can probably make it happen if you're stubborn
enough, but you'd have to do something like having the version update
script CREATE OR REPLACE every last C function in the extension to
change its shlib name from, eg, 'example-2' to 'example-3'.

Another thing that you should think long and hard on is that if you
go this route, there are likely to be scenarios where both libraries
are loaded into a backend process' address space.  Will they cope?
(For instance, if they both hook into some backend function hook,
will it be OK that hook actions get done twice?)

I think there are some other gotchas related to getting through a
pg_update scenario.  For instance, to get from 9.6 running example-2
to 10 running example-3, you'd need a version of example-2 built for
v10 (if you do the ALTER EXTENSION UPDATE after pg_upgrade) or a
version of example-3 built for 9.6 (if you do it in the other order).
So this definitely isn't going to reduce the number of builds you
have to maintain, rather the opposite.

There was a thread not too long ago concerning somebody who was putting
version numbers in his shlib name, and it was breaking things, and the
general recommendation was "so don't do that".  I don't recall the details
but you'd be well advised to check the archives before going that route.

> If not, what is the best approach for releasing a new .so that keeps the 
> old functionality? I guess something this?:

>  # example--2.0.0.sql
>  CREATE OR REPLACE FUNCTION
>  myfunc(anyarray)
>  RETURNS integer
>  AS 'example', 'myfunc_v2_0_0'
>  LANGUAGE c IMMUTABLE;

>  # example--3.0.0.sql
>  CREATE OR REPLACE FUNCTION
>  myfunc(anyarray)
>  RETURNS integer
>  AS 'example', 'myfunc_v3_0_0'
>  LANGUAGE c IMMUTABLE;

Yeah, there are several examples of that sort of thing in the contrib
modules.  Usually we only stick a version number into the C function
name when the function actually changes meaningfully; otherwise you'll
have a lot of makework boiler-plate in your version update scripts.
(Cases where you really need to do this should be the minority,
I'd think, otherwise you're talking about enough SQL behavioral change
that your users will probably be unhappy with you.)

regards, tom lane


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Two versions of an extension in the same cluster?

2017-10-23 Thread Paul Jungwirth 

Hello,

I've got an extension that supplies functions written in C. Two 
databases from the same cluster both use this extension. I understand 
how I can load the example--2.0.0.sql file in one database, and 
example--3.0.0.sql in another, but from what I can tell both databases 
still share the same .so file. Is there any way to provide a separate 
.so for each version?


If not, what is the best approach for releasing a new .so that keeps the 
old functionality? I guess something this?:


# example--2.0.0.sql
CREATE OR REPLACE FUNCTION
myfunc(anyarray)
RETURNS integer
AS 'example', 'myfunc_v2_0_0'
LANGUAGE c IMMUTABLE;

# example--3.0.0.sql
CREATE OR REPLACE FUNCTION
myfunc(anyarray)
RETURNS integer
AS 'example', 'myfunc_v3_0_0'
LANGUAGE c IMMUTABLE;

Thanks,
Paul


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] multiple sql results to shell

2017-10-23 Thread Randy Strauss 
On Oct 23, 2017, at 08:37, 
pgsql-general-ow...@postgresql.org 
wrote:

psql . | while read a; do
#some code
done

The only problem I find with this is that you can't pass variables out
of the while loop,

To get input from a file w/o a sub-shell,
you can put the input at the end of the loop:


#!/bin/sh

cat > file <

Re: [GENERAL] using conda environment for plpython3u?

2017-10-23 Thread John R Pierce 

On 10/23/2017 2:05 PM, Celia McInnis wrote:
Is it possible for users to use their conda environment for plpython, 
complete with the modules that they have loaded in that environment? 
If so, what do I do?


I am running postgres 9.6.2 and would like to use a conda environment 
for python 3.6 which contrains a fair number of modules that I want to 
use (eg., regex, recordclass, pandas, ...).



plpython runs in the context of the server user, not the end user.   as 
long as you can maket his 'conda environment' available to that user, 
and it doesn't violate the single threaded design of a postgres 
connection, I dunno why not.


that said, everything you do in a PL is running in the process context 
of the core database server.   I'm very very hesitant to drag in large 
complex external systems, and would generally prefer to do that sort of 
thing in an app server context outside the DB server.




--
john r pierce, recycling bits in santa cruz



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] using conda environment for plpython3u?

2017-10-23 Thread Celia McInnis 
Is it possible for users to use their conda environment for plpython,
complete with the modules that they have loaded in that environment? If so,
what do I do?

I am running postgres 9.6.2 and would like to use a conda environment for
python 3.6 which contrains a fair number of modules that I want to use
(eg., regex, recordclass, pandas, ...).

Re: [GENERAL] Installing PostgreSQL 10 on Mac OSX Undefined Symbol _heap_modify_tuple_by_cols

2017-10-23 Thread Tom Lane 
Ben Madin  writes:
> we are quite excited about the parallelisation enhancements, and keen to
> try, but trying to build (using the same configure as we have used for 9.6)
> is giving some warnings and errors.

Something's definitely messed up there:

> gcc -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
> -Wformat-security -fno-strict-aliasing -fwrapv
> -Wno-unused-command-line-argument -O2 -arch x86_64  -DREFINT_VERBOSE -I.
> -I./ -I/usr/local/pgsql965/include/server
> -I/usr/local/pgsql965/include/internal
> -I/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.13.sdk/usr/include/libxml2
> -I/usr/local/include  -c -o autoinc.o autoinc.c

Looking at this example of a v10 build log on macOS:
https://buildfarm.postgresql.org/cgi-bin/show_stage_log.pl?nm=longfin&dt=2017-10-23%2018%3A15%3A34&stg=make

the compile command for autoinc is

ccache gcc -Wall -Wmissing-prototypes -Wpointer-arith 
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute 
-Wformat-security -fno-strict-aliasing -fwrapv 
-Wno-unused-command-line-argument -g -O2 -fno-common 
-Wno-deprecated-declarations -Werror  -DREFINT_VERBOSE -I. -I. 
-I../../src/include  
-I/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.13.sdk/usr/include/libxml2
  -I/usr/local/ssl/include  -c -o autoinc.o autoinc.c

Some of the discrepancies (e.g. -Werror on the buildfarm machine) are
explainable as different configuration choices, but the references to
/usr/local/pgsql965 in your build sure look like trouble.

> Is this looking for an existing environment variable (which
> seems unlikely for a build process) or is something else unusual?

I believe the configure script *does* pay attention to environment
variables, particularly CPPFLAGS and CFLAGS.  Most likely you had
version-specific values in those when you ran configure, and they
got absorbed into src/Makefile.global.

regards, tom lane


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] table corruption

2017-10-23 Thread Peter Geoghegan 
> Nice to see it included in 10!
> https://www.postgresql.org/docs/10/static/amcheck.html

The reason that I pointed to the Github version rather than the
contrib version is that only the Github version currently has the
"heapallindexed" check. That seems likely to be by far the most
important check here.

-- 
Peter Geoghegan


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] table corruption

2017-10-23 Thread Scott Marlowe 
On Mon, Oct 23, 2017 at 9:35 AM, Peter Geoghegan  wrote:
> On Mon, Oct 23, 2017 at 7:44 AM, Peter Hunčár  wrote:
>> I know that zero_damaged_pages and vacuum (or restore the table from backup)
>> will help, but I want to ask if there is a way to identify affected
>> rows/datafiles, so we can 'fix' only the affected data using the
>> backup/source data, instead of restoring the whole table?
>
> You might find the latest version of amcheck helpful here:
> https://github.com/petergeoghegan/amcheck
>
> It's not really written with repair in mind, since that's such a can
> of worms, but it might still help you.
>
> --
> Peter Geoghegan
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

Nice to see it included in 10!

https://www.postgresql.org/docs/10/static/amcheck.html


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postgres 9.6 fails to start on VMWare

2017-10-23 Thread George Neuner 
On Mon, 23 Oct 2017 09:14:18 +0100, Martin Moore
 wrote:

>Same server. I tried a few times.
>
>I didn’t move the db separately, but did a ‘dd’ to copy the disk
>to an imagefile which was converted and loaded into VMWare.

If you copied the boot device that way while the system was running,
then you are lucky it even starts in the new environment.

What you did is only [really] safe to do with a data volume ... and
the volume should be mounted R/O while it is being copied.

Doesn't GCloud provide a way to export drive images?
[He asks naively, never having used it.]

>I ‘believed’ that this should keep the low level disk structure the
>same, but if this has corrupted the files I can drop, dump and
>restore, in which case how do I ‘drop’ the DB without postgres
>running?

Move/rename the PG data directory, then use initdb to create a new
cluster.  You'll have to reload your databases from backups.

But I would be concerned that the disk structure is damaged.  I would
run e2fsck on it - and if there are lots of errors found I wouldn't
use it.

George



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postgres 9.6 fails to start on VMWare

2017-10-23 Thread Martin Moore 
OK, cheers.

 

How can I remove the db so I can restore it properly?

 

From: Scott Mead 
Date: Monday, 23 October 2017 at 16:35
To: Martin Moore 
Cc: Michael Nolan , "pgsql-general@postgresql.org" 

Subject: Re: [GENERAL] Postgres 9.6 fails to start on VMWare

 

 

 

On Mon, Oct 23, 2017 at 11:26 AM, Martin Moore  wrote:

It was running – not sure how dd handles this. Maybe badly… ☺

 

it doesn't handle it at all.  This would be the cause of your issue.

 

--Scott

 

 

 

From: Michael Nolan 
Date: Monday, 23 October 2017 at 15:52
To: Martin Moore 
Cc: rob stone , "pgsql-general@postgresql.org" 

Subject: Re: [GENERAL] Postgres 9.6 fails to start on VMWare

 

 

 

On Mon, Oct 23, 2017 at 3:14 AM, Martin Moore  wrote:

Same server. I tried a few times.

I didn’t move the db separately, but did a ‘dd’ to copy the disk to an 
imagefile which was converted and loaded into VMWare.

I ‘believed’ that this should keep the low level disk structure the same, but 
if this has corrupted the files I can drop, dump and restore, in which case how 
do I ‘drop’ the DB without postgres running?

Ta,

Martin.

 

Was the server you were backing up shut down or in backup mode when you did the 
'dd' copy?

--

Mike Nolan



 

-- 

--
Scott Mead
Sr. Architect
OpenSCG

http://openscg.com

Re: [GENERAL] Postgres 9.6 fails to start on VMWare

2017-10-23 Thread Scott Mead 
On Mon, Oct 23, 2017 at 11:26 AM, Martin Moore 
wrote:

> It was running – not sure how dd handles this. Maybe badly… ☺
>

it doesn't handle it at all.  This would be the cause of your issue.

--Scott



>
>
> *From: *Michael Nolan 
> *Date: *Monday, 23 October 2017 at 15:52
> *To: *Martin Moore 
> *Cc: *rob stone , "pgsql-general@postgresql.org" <
> pgsql-general@postgresql.org>
> *Subject: *Re: [GENERAL] Postgres 9.6 fails to start on VMWare
>
>
>
>
>
>
>
> On Mon, Oct 23, 2017 at 3:14 AM, Martin Moore 
> wrote:
>
> Same server. I tried a few times.
>
> I didn’t move the db separately, but did a ‘dd’ to copy the disk to an
> imagefile which was converted and loaded into VMWare.
>
> I ‘believed’ that this should keep the low level disk structure the same,
> but if this has corrupted the files I can drop, dump and restore, in which
> case how do I ‘drop’ the DB without postgres running?
>
> Ta,
>
> Martin.
>
>
>
> Was the server you were backing up shut down or in backup mode when you
> did the 'dd' copy?
>
> --
>
> Mike Nolan
>



-- 
--
Scott Mead
Sr. Architect
*OpenSCG *
http://openscg.com

Re: [GENERAL] table corruption

2017-10-23 Thread Peter Geoghegan 
On Mon, Oct 23, 2017 at 7:44 AM, Peter Hunčár  wrote:
> I know that zero_damaged_pages and vacuum (or restore the table from backup)
> will help, but I want to ask if there is a way to identify affected
> rows/datafiles, so we can 'fix' only the affected data using the
> backup/source data, instead of restoring the whole table?

You might find the latest version of amcheck helpful here:
https://github.com/petergeoghegan/amcheck

It's not really written with repair in mind, since that's such a can
of worms, but it might still help you.

-- 
Peter Geoghegan


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postgres 9.6 fails to start on VMWare

2017-10-23 Thread Martin Moore 
It was running – not sure how dd handles this. Maybe badly… ☺

 

From: Michael Nolan 
Date: Monday, 23 October 2017 at 15:52
To: Martin Moore 
Cc: rob stone , "pgsql-general@postgresql.org" 

Subject: Re: [GENERAL] Postgres 9.6 fails to start on VMWare

 

 

 

On Mon, Oct 23, 2017 at 3:14 AM, Martin Moore  wrote:

Same server. I tried a few times.

I didn’t move the db separately, but did a ‘dd’ to copy the disk to an 
imagefile which was converted and loaded into VMWare.

I ‘believed’ that this should keep the low level disk structure the same, but 
if this has corrupted the files I can drop, dump and restore, in which case how 
do I ‘drop’ the DB without postgres running?

Ta,

Martin.

 

Was the server you were backing up shut down or in backup mode when you did the 
'dd' copy?

--

Mike Nolan

Re: [GENERAL] Postgres 9.6 fails to start on VMWare

2017-10-23 Thread Michael Nolan 
On Mon, Oct 23, 2017 at 3:14 AM, Martin Moore 
wrote:

> Same server. I tried a few times.
>
> I didn’t move the db separately, but did a ‘dd’ to copy the disk to an
> imagefile which was converted and loaded into VMWare.
>
> I ‘believed’ that this should keep the low level disk structure the same,
> but if this has corrupted the files I can drop, dump and restore, in which
> case how do I ‘drop’ the DB without postgres running?
>
> Ta,
>
> Martin.
>

Was the server you were backing up shut down or in backup mode when you did
the 'dd' copy?
--
Mike Nolan

[GENERAL] table corruption

2017-10-23 Thread Peter Hunčár 
Hi,

we have a table with around 1.6 billion rows having quite lot of big binary
data toasted.

Today we started getting:
WIB > ERROR:  invalid page in block 1288868309 of relation base/96031/96201

Which is a toast reltype.

I know that zero_damaged_pages and vacuum (or restore the table from
backup) will help, but I want to ask if there is a way to identify affected
rows/datafiles, so we can 'fix' only the affected data using the
backup/source data, instead of restoring the whole table?

Thank you

Regards

P.

[GENERAL] Matching statement and duration log lines

2017-10-23 Thread Popov Aleksey 
Hello!

I am sending PG logs to Elasticsearch and want to merge a line with statement 
and a line with duration into one document.
Having a statement line and a duration line, can I assume that if a session ids 
(%c) of these lines match,
and numbers of log lines (%l) are consecutive, then the duration line belongs 
to statement line?

[GENERAL] Is it safe to create foreign keys beforehand when logical replication is used?

2017-10-23 Thread Önder Kalacı 
Hi,

I'm trying to figure out whether the following is safe or not on all
conditions with logical replication:


-- on the source (localhost:5432), create the tables which have foreign
keys among them
-- load some data and create publication

CREATE TABLE rep_test (a int PRIMARY KEY);
CREATE TABLE rep_test_2 (a int REFERENCES rep_test);
INSERT INTO rep_test SELECT i FROM generate_series(0, 10) i;
INSERT INTO rep_test_2 SELECT i FROM generate_series(0, 10) i;
CREATE PUBLICATION pubtest FOR TABLE rep_test, rep_test_2;


-- on the target (localhost:9700) are the following stepscorrect?
-- create the foreign keys before the initial data load

CREATE TABLE rep_test (a int PRIMARY KEY);
CREATE TABLE rep_test_2 (a int REFERENCES rep_test);

-- later, create the subscription
CREATE SUBSCRIPTION testsub CONNECTION 'host=localhost port=5432
user=onderkalaci dbname=postgres' PUBLICATION pubtest;


According to my tests, I've never hit into any issues. But, I'm curious if
that's theoretically correct. Is there any case where the table which
references to another table's initial data load finishes earlier and the
referential integrity is broken?


Thanks,
Onder

Re: [GENERAL] A question on pg_stat_subscription view

2017-10-23 Thread Önder Kalacı 
Hi,

Thanks for the reply, however, the documentation does not mention about
that clearly.

It only mentions that 'latest_end_lsn'  is the `Last write-ahead log
location reported to origin WAL sender`. However, what I'm particularly
interested is that whether the reported log is the flushed or applied LSN.

Thanks,
Onder


On Sun, Oct 22, 2017 at 12:03 PM Günce Kaya  wrote:

> Hello,
>
> You can find more information about that view and its columns.
>
> https://www.postgresql.org/docs/devel/static/monitoring-
> stats.html#pg-stat-subscription
>
> Regards,
> Gunce
>
> On 22 Oct 2017 Sun at 11:11 Önder Kalacı  wrote:
>
>> Hi,
>>
>> I'm trying to understand the view pg_stat_subscription. What is the
>> `latest_end_lsn` column? Is that the latest lsn flushed or lsn replied or
>> something else?
>>
>> Thanks!
>>
> --
> Gunce Kaya
>

Re: [GENERAL] multiple sql results to shell

2017-10-23 Thread Geoff Winkless 
On 23 October 2017 at 15:08, Mark Lybarger  wrote:
> I have this bash/sql script which outputs some curl commands.  the backticks
> causes it to get interpreted by the shell.   This works fine if there is one
> result, but when there are many rows returned, it looks like one shell
> command.
>
> any help on getting multiple rows returned to be executed by the shell would
> be appreciated!

I tend to do

psql . | while read a; do
#some code
done

The only problem I find with this is that you can't pass variables out
of the while loop, because the pipe runs as a subshell. You could of
course use echo and encapsulate the whole thing, eg this would take
your results and (assuming they're integers) return the largest -
obviously your own code could decide differently how to output things.
You also have to move the read to later on, so you can send your
output to the parent.

myres=$(
  a=0
  biga=0
  psql -tqAX -h ${DB_HOST} -d ${DB_NAME} -u ${DB_USER} -c "select
'curl -X POST http://${REGISTER_HOST}:8080/' || source_id || '/${MT}/'
|| model || '/'   || site || '/backoffice/register' from
myschema.events where source_id = $SOURCE_ID and ineffective_date is
null" | while true; do
   if [ $a -gt $biga ] ; then
 biga=$a
   fi
   if ! read a; then echo $biga; break; fi
  done
)

A mess, but it works.

To be honest, by the time you've got to this level of complexity you
probably shouldn't be using shellscript any more.

Geoff


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] multiple sql results to shell

2017-10-23 Thread David G. Johnston 
On Mon, Oct 23, 2017 at 7:08 AM, Mark Lybarger  wrote:

> I have this bash/sql script which outputs some curl commands.  the
> backticks causes it to get interpreted by the shell.   This works fine if
> there is one result, but when there are many rows returned, it looks like
> one shell command.
>
> any help on getting multiple rows returned to be executed by the shell
> would be appreciated!
>
> thanks!
>
> `psql -P "tuples_only=on" -h ${DB_HOST} -d ${DB_NAME} -U ${DB_USER} -c
> "select 'curl -X POST http://${REGISTER_HOST}:8080/' || source_id ||
> '/${MT}/' || model || '/' || site || '/backoffice/register' from
> myschema.events where source_id = $SOURCE_ID and ineffective_date is null"`
>
>
​You will need to, instead, "SELECT source_id, model, site​ FROM ..." to
return the raw record data to bash and then use bash's loop facilities to
dynamically generate and execute the curl command.

A second option, that I've never tried, is returning the full string but
not within a backtick command, then using bash looping simply invoke the
string like a normal command.

David J.

[GENERAL] multiple sql results to shell

2017-10-23 Thread Mark Lybarger 
I have this bash/sql script which outputs some curl commands.  the
backticks causes it to get interpreted by the shell.   This works fine if
there is one result, but when there are many rows returned, it looks like
one shell command.

any help on getting multiple rows returned to be executed by the shell
would be appreciated!

thanks!

`psql -P "tuples_only=on" -h ${DB_HOST} -d ${DB_NAME} -U ${DB_USER} -c
"select 'curl -X POST http://${REGISTER_HOST}:8080/' || source_id ||
'/${MT}/' || model || '/' || site || '/backoffice/register' from
myschema.events where source_id = $SOURCE_ID and ineffective_date is null"`

Re: [GENERAL] Postgres 9.6 fails to start on VMWare

2017-10-23 Thread Martin Moore 
Same server. I tried a few times.

I didn’t move the db separately, but did a ‘dd’ to copy the disk to an 
imagefile which was converted and loaded into VMWare.

I ‘believed’ that this should keep the low level disk structure the same, but 
if this has corrupted the files I can drop, dump and restore, in which case how 
do I ‘drop’ the DB without postgres running?

Ta,

Martin.



On 23/10/2017, 00:51, "rob stone"  wrote:



On Sun, 2017-10-22 at 15:13 +0100, Martin Moore wrote:
> 2017-10-22 14:08:28 UTC [2479-1] LOG:  0: database system
> shutdown was interrupted; last known up at 2017-10-22 14:07:20 UTC

There is something missing here. Last shutdown at 2017-10-22 14:07:20
UTC on which server?
Then attempting to start it at 2017-10-22 14:08:28 UTC? One minute and
eight seconds later.
It might also help if you explained exactly how you moved the database
from Google Compute to this VM machine.

Cheers,
robert





-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Alternative to pgAdmin Postgres Manager that support pgagent (jobs)

2017-10-23 Thread Juliano 
Great!

No worries, after work I will start with some surveys about how to package 
Postgres extension, and get it onto pgxn.

Thanks
Juliano

 Original Message 

> Subject: Re: [GENERAL] Alternative to pgAdmin Postgres Manager that support 
> pgagent (jobs)
> Local Time: October 21, 2017 9:18 PM
> UTC Time: October 21, 2017 8:18 PM
> From: adambrusselb...@gmail.com
> To: Juliano 
> pgsql-general@postgresql.org 
>
> Happy to hear jpgAgent is working alright for you. If you have any
> questions with it feel free to ask me.
>
> If you do want to help with pgAutomator, that sounds like something
> you could start to learn on. jpgAgent is pretty much feature complete
> as far as my needs go, and no one has requested any additional
> features, so i'd rather spend any new time on pgAutomator.
>
> So one thing I know I need, is to figure out how to package a Postgres
> extension, and get it onto pgxn. The database portion of pgAutomator
> is pretty complete at this point, so it'd be nice to learn how to
> package it up even if I don't end up publishing it until I get a UI in
> place. I'll have to look, but i'm sure there are plenty of small
> tasks that can be done with the agent itself as well.