Re: [GENERAL] My Postgresql is inaccessible in Windows 8.1

2016-08-03 Thread Edson F. Lidorio
Em 2016-08-03 09:56, Adrian Klaver escreveu: On 08/03/2016 04:40 AM, Edson F. Lidorio wrote: Good Morning, Constantly my Postgresql is inaccessible, recording the following message in the log. I'm using Windows 8.1 and PostgreSQL 9.5 2016-08-02 17:05:59 BRT FATAL: the database syst

[GENERAL] My Postgresql is inaccessible in Windows 8.1

2016-08-03 Thread Edson F. Lidorio
Good Morning, Constantly my Postgresql is inaccessible, recording the following message in the log. I'm using Windows 8.1 and PostgreSQL 9.5 2016-08-02 17:05:59 BRT FATAL: the database system is starting up 2016-08-02 17:05:59 BRT LOG: database system was not properly shut down; automatic

Re: [GENERAL] Get the date of creation of objects in the database

2016-02-22 Thread Edson F. Lidorio
avid G. Johnston <mailto:david.g.johns...@gmail.com> Sent: ‎2/‎23/‎2016 0:14 To: Edson F. Lidorio <mailto:ed...@openmailbox.org> Cc: pgsql-general <mailto:pgsql-general@postgresql.org> Subject: Re: [GENERAL] Get the date of creation of objects in the database O

[GENERAL] Get the date of creation of objects in the database

2016-02-22 Thread Edson F. Lidorio
Hello, How to get the date of creation of objects in batabase? For example: The date of creation of tables and trigger. Thank you; Edson -- 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] Tutorial on How to Compile PostgreSQL 9.5 for Windows 64bit

2016-01-26 Thread Edson F. Lidorio
On 25-01-2016 16:46, Igal @ Lucee.org wrote: Hi Everybody, I have posted a video tutorial on How to Compile PostgreSQL 9.5 for Windows 64bit https://www.youtube.com/watch?v=-BJmuZT5IPE It was quite difficult for me to figure it out, so hopefully it will make life easier for the next guy (

Re: [GENERAL] Strange syntax with select

2015-12-25 Thread Edson F. Lidorio
select generate_series(1,10); INSERT 0 10 db => \set testvar 'sum(id) from test' db => select :testvar; sum - 55 (1 row) Bye Charles *From:*pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] *On Behalf Of *Edson F. Lidorio *Sent:* Freitag, 2

[GENERAL] Strange syntax with select

2015-12-25 Thread Edson F. Lidorio
Hello, I excuse my ignorance with SQL and my English. I wonder if these procedures are correct or is it a bug? I'm trying to put the result of a select within the v_saldo_ini variable, except I realized that the postgresql created a table with v_saldo_ini variable. See the steps below: CREATE

Re: [GENERAL] Download PostgreSQL 9.5 Alpha

2015-07-06 Thread Edson F. Lidorio
rking version to be "damaged". Bye Charles On 7/4/2015 02:24, Joshua D. Drake wrote: On 07/03/2015 04:32 PM, Edson F. Lidorio wrote: Hello, PostgreSQL 9.5 Alpha not appear on the downloads list in [1] Where do I download for Windows? [1] http://www.enterprisedb.com/products-se

[GENERAL] Download PostgreSQL 9.5 Alpha

2015-07-03 Thread Edson F. Lidorio
Hello, PostgreSQL 9.5 Alpha not appear on the downloads list in [1] Where do I download for Windows? [1] http://www.enterprisedb.com/products-services-training/pgdownload#windows -- Edson -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscrip

Re: [GENERAL] Standby problem after restore_command Implementation

2015-05-05 Thread Edson F. Lidorio
Em 2015-05-05 14:31, Adrian Klaver escreveu: > On 05/05/2015 08:35 AM, Edson F. Lidorio wrote: > On 05-05-2015 11:22, Melvin Davidson wrote: It's possible you have > wal_keep_segments set too low. What happens is that the master will keep the > wals ( in your case 20) afte

Re: [GENERAL] Standby problem after restore_command Implementation

2015-05-05 Thread Edson F. Lidorio
_reload_conf(); > > You must do ALL of the above to have any chance of making things work. > > On Tue, May 5, 2015 at 11:35 AM, Edson F. Lidorio > wrote: > > On 05-05-2015 11:22, Melvin Davidson wrote: > > It's possible you have wal_keep_segments set too low. What happ

Re: [GENERAL] Standby problem after restore_command Implementation

2015-05-05 Thread Edson F. Lidorio
lable to the standby. Try increasing wal_keep_segments = 100. On Tue, May 5, 2015 at 10:09 AM, Adrian Klaver mailto:adrian.kla...@aklaver.com>> wrote: On 05/05/2015 07:05 AM, Edson F. Lidorio wrote: CCing list. Em 2015-05-05 10:45, Adrian Klaver escreveu: On

[GENERAL] Standby problem after restore_command Implementation

2015-05-03 Thread Edson F. Lidorio
Hello, I'm having trouble on Standby after the implementation of the restore_command. I performed all the settings and it worked normally and after restart the slave server, started to generate errors in the log of the slave: I'm using Debian 8 with PostgreSQL 9.4.1 on x86_64-unknown-linux-gn

[GENERAL] Download Postgresql 9.4 beta for Windows is not available.

2014-07-09 Thread Edson F. Lidorio
Hello, I'm tempted to download the Postgresql 9.4 beta for Windows and can not, the download link http://www.postgresql.org/download only redirects to EnterpriseDB which is available only to versions page: http://www.enterprisedb.com/products-services-training/pgdownload # windows I would l