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

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

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

but I would like to start to code as well Regards Juliano > Original Message > Subject: Re: [GENERAL] Alternative to pgAdmin Postgres Manager that support > pgagent (jobs) > Local Time: 20 October 2017 4:14 AM > UTC Time: 20 October 2017 03:14 > From: adambru

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

Hi guys I've been struggling for long years to find an alternative Postgres Manager that can support pgAgent jobs like pgAdmin does. PgAdmin works fine, but, it is not good as Oracle Enterprise Manager or SQL Server Management Studio and there is a lot of bugs. The version 1 it is obsolete and

[GENERAL] Cluster, repmgr, pgbouncer, pgpool, ha proxy, virtual IP, replication, failover and load balance

Hi guys > I would like to deploy load balance on Postgres master/slave(RW/R) servers > and also use a virtual IP on this cluster > > I currently have Postgres 9.4 using Repmgr for replication and manual > failover to avoid split-brain problems and save a witness server. Also, there > is Pgbounc

Re: [GENERAL] repmgr cascade replication node delay

Hi David, Thanks for your email. This recovery_min_apply_delay sounds interesting! I wold like to use it between 2 standby nodes (cascade replication using repmgr) instead of master/standby, anyone knows if is it possible? Regards, Juliano Sent with [ProtonMail](https://protonmail.com) Secure

[GENERAL] repmgr cascade replication node delay

? Open to suggestions, please ignore pg_dump and barman. Regards Juliano

[GENERAL] repmgr new standby node without clone master data

with --rsync-only. Regards Juliano

Re: [GENERAL] Overwrite pg_catalog?

Hi everyone, Ok, thanks. Just to explain: I have some custom objects on my pg_catalog and I would like to restore it in a new test database and I think that this is the best way, isn't it? Regards, Juliano Original Message Subject: Re: [GENERAL] Overwrite pg_ca

[GENERAL] Overwrite pg_catalog?

Hi everyone, I tried to restore pg_catalog to my new database, but the existing pg_catalog can't be overwritten or dropped, and postgres auto creates pg_catalog when I create a new DB. So, there is a way to restore the pg_catalog to a new database? Regards, Juliano

Re: [GENERAL] pg_dump system catalog

I'm not knew that system catalogs could be saved as schema, thanks Achilleas. So, I would like to get the data and the schema of the system catalogs. How can I include the data in a dump file with system schemas? (The parameter -a makes sense together the parameter --schema?) Regards, Juliano

[GENERAL] pg_dump system catalog

Hi everyone, How can I use pg_dump to do a backup of "system catalogs" only? Regards, Juliano

Re: [GENERAL] Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16)

I updated odbc drivers and it worked. Thanks everyone Regards, Juliano Sent with [ProtonMail](https://protonmail.com) Secure Email. Original Message Subject: Re: [GENERAL] Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16

[GENERAL] Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16)

Hi, I'm trying to import some data from a MS SQL Server 2014 sequential database to Postgresql using dbi-link. Postgresql 9.6 encoding is utf-8 and does not support utf-16 but, I need to transfer this data to postgres. I also tried to use tds_fdw version 1.0.8 and the same problem

[GENERAL] Insert with query

By doing insert into a table using a query, it seems that all records of consultation were included bypassing the AFTER INSERT triggers and as few as after all the records already included, the TRIGGER is fired for each record, I wonder if this occurrence is normal. I created an example that dem

[GENERAL] Experiences with BLOB + PostgreSQL

Please tell us the size of you database and the main problems you encountered managing it. It will certainly be very helpful, specially for me. Thank you all! Juliano -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgres

[GENERAL] Regression Tests

Hi, I've installed PostgreSQL 7.0.2 on Solaris following the INSTALL file that comes with the source. When I do: make runtest it gives out the following error message in regress.out: postmaster must already be running for the regression tests to succeed. The time zone is set to PST8PDT for th