Re: [GENERAL] Weird performance difference

ing pg_class. See do_autovacuum(). -- Michael -- 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] A question on pg_stat_subscription view

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

[GENERAL] A question on pg_stat_subscription view

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!

Re: [GENERAL] tgrm index for word_similarity

On 10/21/2017 5:01 AM, Arthur Zakirov wrote: PostgreSQL doesn't use index scan with functions within WHERE clause. So you always need to use operators instead. You can try <% operator and pg_trgm.word_similarity_threshold variable: =# SET pg_trgm.word_similarity_threshold TO 0.1; =# SELECT

Re: [GENERAL] Re: Restoring tables with circular references dumped to separate files

are in "plain text" format, and compressed formats such as > "tar" would not be github friendly. > > > > -- > Sent from: http://www.postgresql-archive.org/PostgreSQL-general- > f1843780.html > > > -- > Sent via pgsql-general mailing list (pgsql-gener

[GENERAL] Re: Restoring tables with circular references dumped to separate files

ttp://www.postgresql-archive.org/PostgreSQL-general-f1843780.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] Alternative to pgAdmin Postgres Manager that support pgagent (jobs)

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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

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

Re: [GENERAL] Weird performance difference

hat I remove the cast to date (or index it), so I guess that's the first thing I'll try. 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] Re: Restoring tables with circular references dumped to separate files

On Sat, Oct 21, 2017 at 8:24 AM, doganmeh <meh...@edgle.com> wrote: > Seems that would be easier and less error prone. Thanks, > > > > -- > Sent from: http://www.postgresql-archive.org/PostgreSQL-general- > f1843780.html > > > -- > Sent via pgsql-general mai

[GENERAL] Re: Restoring tables with circular references dumped to separate files

Seems that would be easier and less error prone. Thanks, -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] tgrm index for word_similarity

<-> name; -- Arthur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company -- 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] Restoring tables with circular references dumped to separate files

ance in advance. > > > > -- > Sent from: > http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

[GENERAL] Restoring tables with circular references dumped to separate files

files? Thanks for guidance in advance. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.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] Weird performance difference

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] Weird performance difference

On Oct 20, 2017, at 3:31 PM, Justin Pryzby wrote: > > On Fri, Oct 20, 2017 at 03:08:26PM -0800, Israel Brewster wrote: >> Summary: the following query takes around 12 seconds on my test machine. On >> my production machine, it's at half an hour and counting. What's going

Re: [GENERAL] Weird performance difference

st to the rowcount estimate being off by a factor of 3e6. Justin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Weird performance difference

Summary: the following query takes around 12 seconds on my test machine. On my production machine, it's at half an hour and counting. What's going on?Details:As a first stab at getting some data I need, I've developed the following SQL query:SELECT    legfrom,    count(*) as totaldeps,    count(*)

Re: [GENERAL] How to find out extension directory

On 10/20/2017 02:10 PM, Tom Lane wrote: > "David G. Johnston" writes: >> On Fri, Oct 20, 2017 at 1:12 PM, rakeshkumar464 >> wrote: >>> How do I know beforehand where the dir path is ? > >> I think pg_config ( >>

Re: [GENERAL] How to find out extension directory

rrent/static/app-pgconfig.html ) is what > you are looking for. specifically, you can assume it's the "extension" subdirectory of whatever SHAREDIR is. "pg_config --sharedir" will tell you that. regards, tom lane -- Sent via pgsql-general mail

[GENERAL] Logical replication - behavior of REFRESH PUBLICATION's copy_data option

Hi all, I'm exploring the new PG10 logical replication feature and trying to understand how ALTER SUBSCRIPTION ... REFRESH PUBLICATION works. My planned publication will have over 100 tables, some of which are quite large. If I add a table to the publication, I understand that I have to use the

Re: [GENERAL] How to find out extension directory

On Fri, Oct 20, 2017 at 1:12 PM, rakeshkumar464 wrote: > I am documenting on automating installation of pgaudit extension for > containers. On my laptop I see that the directory where the files > pgaudit.control and pgaudit--1.2.sql needs to be present is > >

Re: [GENERAL] How to find out extension directory

ent is > > /usr/share/postgresql/10/extension. > > How do I know beforehand where the dir path is ? > > > > > -- > Sent from: http://www.postgresql-archive.org/PostgreSQL-general- > f1843780.html > > > -- > Sent via pgsql-general mailing list (pgsql-ge

[GENERAL] How to find out extension directory

from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.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] tgrm index for word_similarity

ts?  When used in auto-suggest there are usually several queries for each user in a relatively short period of time, so speed is important. Thanks, Igal -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Replication stops under certain circumstances

when inspecting the pg_locks table that don't get discovered. I hope I can reproduce that example also at some time. But have anyone else experienced problem with slave stopping to replicate because everything ends up being locked? Cheers Kim Carlsen -- Sent via pgsql-general mailing lis

[GENERAL] Issues shutting down PostgreSQL 10 cleanly

I am in the midst of heavy, large write operations on a new database this is currently around 23 billion lines. My max_wal_size is 256 GB and my checkpoint_timeout is 12 hours. (Smaller values were hindering the writes.) Note: this is on Ubuntu 16.04 LTS. I am having trouble shutting down

Re: [GENERAL] How do you decide what aggregates to add?

forever) every little special-purpose function somebody might want. 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] How do you decide what aggregates to add?

n-postgres/ -- Seamus Abshere, SCEA https://www.faraday.io https://github.com/seamusabshere https://linkedin.com/in/seamusabshere -- 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)

, and managed by SQL statements. -- 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

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

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

Re: [GENERAL] Is it OK to create a directory in PGDATA dir

On Thu, Oct 19, 2017 at 5:32 PM, John R Pierce wrote: > On 10/19/2017 1:25 PM, Tomas Vondra wrote: > > Is it fine to create a subdir inside PGDATA and store our stuff > there, or will PG freak out seeing a foreign object. > > > PostgreSQL certainly does not check if there

Re: [GENERAL] Is it OK to create a directory in PGDATA dir

On 10/19/2017 1:25 PM, Tomas Vondra wrote: Is it fine to create a subdir inside PGDATA and store our stuff there, or will PG freak out seeing a foreign object. PostgreSQL certainly does not check if there are unknown directories in the data directory, and it will not crash and burn. But it

Re: [GENERAL] Is it OK to create a directory in PGDATA dir

Hey I am not the container guy. I agree with you 100%. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

[GENERAL] tgrm index for word_similarity

Hello, I want to use Postgres for a fuzzy auto-suggest search field.  As the user will be typing their search phrase, Postgres will show a list of items that fuzzy-matches what they typed so far, ordered by popularity (ntile(20)) and distance, i.e. 1 - word_similarity(). I created a

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

On 10/19/2017 3:15 PM, Juliano wrote: Omnidb looks nice, but, I guess doesn't support pgAgent as well, any suggestions? pgAgent isn't part of postgres, its part of pgAdmin. -- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] pgpass file type restrictions

Matt, * Desidero (desid...@gmail.com) wrote: > I agree that it would be better for us to use something other than LDAP, If you happen to be using Active Directory, then you should really be using Kerberos-based auth instead. AD includes both LDAP and a KDC and the LDAP half is really *not* the

[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

Re: [GENERAL] Is it OK to create a directory in PGDATA dir

On 10/19/2017 1:25 PM, Tomas Vondra wrote: On 10/19/2017 09:58 PM, rakeshkumar464 wrote: In the container world, sometime the only persistent storage path (that is, storage outside container world) is PGDATA.> I don't want to be the "You're doing it wrong!" guy, but you're doing it wrong. If a

Re: [GENERAL] Is it OK to create a directory in PGDATA dir

dra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Is it OK to create a directory in PGDATA dir

/PostgreSQL-general-f1843780.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] Using Variables in Queries

On 10/19/2017 12:14 PM, Tom Lane wrote: "Igal @ Lucee.org" writes: My real query is for similarity here, so I'm testing different functions with the same value, e.g. SELECT item_name , similarity('red widget', item_name) , similarity(item_name, 'red widget')

Re: [GENERAL] Using Variables in Queries

ORDER BY target <<-> item_name >> >> PG 9.5 and up will flatten out cases like this to be exactly what you >> wrote out longhand. > ​Does it matter if the values expression is embedded in a CTE? Yes, CTEs are optimization fences ... regards

Re: [GENERAL] Using Variables in Queries

On Thu, Oct 19, 2017 at 12:14 PM, Tom Lane wrote: > FROM products, > (values ('red widget'::text)) consts(target) > WHERE similarity(target, item_name) > 0.25 > ORDER BY target <<-> item_name > > PG 9.5 and up will flatten out cases like this to be exactly what you >

Re: [GENERAL] Using Variables in Queries

nsts(target) WHERE similarity(target, item_name) > 0.25 ORDER BY target <<-> item_name PG 9.5 and up will flatten out cases like this to be exactly what you wrote out longhand. 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] Using Variables in Queries

2017-10-19 20:11 GMT+02:00 Igal @ Lucee.org : > On 10/19/2017 8:44 AM, David G. Johnston wrote: > > ​PREPARE sqlquery AS​ SELECT * FROM products WHERE col1 LIKE $1 OR col2 > LIKE $1; > EXECUTE sqlquery('red widget'); > > This works, but requires `DEALLOCATE sqlquery` when you

Re: [GENERAL] Using Variables in Queries

On 10/19/2017 8:44 AM, David G. Johnston wrote: ​PREPARE sqlquery AS​ SELECT * FROM products WHERE col1 LIKE $1 OR col2 LIKE $1;  EXECUTE sqlquery('red widget'); This works, but requires `DEALLOCATE sqlquery` when you want to update it from what I've seen which is not very friendly.  

Re: [GENERAL] pgpass file type restrictions

he latter, as if it hadn't its own problems. Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- 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] Problems with the time in data type timestamp without time zone

t time zone, > > > > > > Please forgive my english I'm using translator. > > > > > > > A minimal SQL example of your problem would help. > > > > David J. > > Please do not top post on this list. Your times are in UTC. You'll need to use

Re: [GENERAL] Using Variables in Queries

On Thu, Oct 19, 2017 at 8:21 AM, Igal @ Lucee.org wrote: > Is it still true (the posts I see on this subject are quite old) that I > can not do so in Postgres outside of a stored procedure/function? And if > so, what's the reason of not adding this feature? Seems very useful to

Re: [GENERAL] Using Variables in Queries

Hi 2017-10-19 17:21 GMT+02:00 Igal @ Lucee.org : > Hello, > > In other database servers, which I'm finally dropping in favor of > Postgres, I can do the following (mind you that this is for illustration > only, I do not actually write queries like that): > > DECLARE @query

Re: [GENERAL] Using Variables in Queries

quite old) that I >> can not do so in Postgres outside of a stored procedure/function? You should be able to do that using the DO statement: https://www.postgresql.org/docs/9.6/static/sql-do.html -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest. -- 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] Using Variables in Queries

On Thu, Oct 19, 2017 at 11:21 AM, Igal @ Lucee.org wrote: > Hello, > > In other database servers, which I'm finally dropping in favor of > Postgres, I can do the following (mind you that this is for illustration > only, I do not actually write queries like that): > > DECLARE

[GENERAL] Using Variables in Queries

Hello, In other database servers, which I'm finally dropping in favor of Postgres, I can do the following (mind you that this is for illustration only, I do not actually write queries like that): DECLARE @query varchar(64) = 'red widget'; SELECT * FROM products WHERE col1 LIKE @query    OR

Re: [GENERAL] Table partionning : INSERT with inconsistent return ligne inserted.

Hi Vik, Thanks for that, it is working. Didier. -Message d'origine- De : Vik Fearing [mailto:vik.fear...@2ndquadrant.com] Envoyé : mercredi 18 octobre 2017 19:30 À : STERBECQ Didier; pgsql-general@postgresql.org Objet : Re: [GENERAL] Table partionning : INSERT with inconsistent return

Re: [GENERAL] Problems with the time in data type timestamp without time zone

We are using two different programs within the same computer, a program saves the data with date and time in the DB and we are doing another program to retrieve that information with date and time to generate reports, all this within the same computer. Best regards. 2017-10-18 11:33 GMT-04:00

Re: [GENERAL] pgpass file type restrictions

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] pgpass file type restrictions

SSWORD environment variable, avoiding creating .pgpass in any form? Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgres

Re: [GENERAL] pgpass file type restrictions

drew Dunstanhttps://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- 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] pgpass file type restrictions

I agree that it would be better for us to use something other than LDAP, but unfortunately it's difficult to convince the powers that be that we can/should use something else that they are not yet prepared to properly manage/audit. We are working towards it, but we're not there yet. It's not

Re: [GENERAL] pgpass file type restrictions

, but > on SSL credentials or Kerberos auth, both of which libpq supports fine. > Yeah, we need to be convincing people with high security needs to get out of the password game. It's a losing battle. cheers andrew -- Andrew Dunstanhttps://www.2ndQuadrant.com Po

Re: [GENERAL] Problems with the time in data type timestamp without time zone

, Your program is Java? Anyways, if your local TZ is +3 (like mine at the moment) it would be likely the case. I appreciate your time and attention. Best regards. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Achilleas Mantzios IT DEV Lead IT DEPT

Re: [GENERAL] Log storage

ory and cheap server for database to store logs and I now even try to make different approach to remove the database server, because I store every day as separate gziped log file for backup. Regards, Hristo S -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] Divert triggers on materialized views

to ongoing monitoring, activity logging and auditing. This monitoring and auditing service may be provided by third parties. Such third parties can access information transmitted to, processed by and stored on NIWA's IT systems. ____ From: pgsql-general-ow...@postgresql

[GENERAL] Problems with the time in data type timestamp without time zone

. Best regards. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] COPY log row count feauture request

Hi everyone, i have question if is possible log count row of COPY command to csv/syslog. I know that there are some limitations like triggers BEFORE INSERT. Don't know if any others were pleased with this feature. Have a nice day. David -- - Ing. David

Re: [GENERAL] pgpass file type restrictions

h libpq supports fine. 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] pgpass file type restrictions

Hello, I’m running into problems with the restriction on pgpass file types. When attempting to use something like an anonymous pipe for a passfile, psql throws an error stating that it only accepts plain files. If it matters, I'm trying to use that so I can pass a decrypted pgpassfile into

Re: [GENERAL] Finally upgrading to 9.6!

ng a prod clone to 10 and asking some devs to run it through its paces, but spare time is a luxury that you can't just expect people to have. -- Don Seiler www.seiler.us <http://www.seiler.us> -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to y

Re: [GENERAL] Finally upgrading to 9.6!

of things so that I notice sharp edges early, but what we always want to have most folks running are the *same* versions in Dev+QA+Prod, so that there aren't unexpected differences. -- When confronted by a difficult problem, solve it by reducing it to the question, "How would the Lone Ranger handle this?" -- 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] Finally upgrading to 9.6!

On Wed, Oct 18, 2017 at 2:34 PM, Don Seiler wrote: > On Wed, Oct 18, 2017 at 4:17 PM, Vik Fearing > wrote: > >> On 10/18/2017 08:17 PM, Don Seiler wrote: >> >> > I disagree with this. It isn't my company's business to test the >> > Postgres software

Re: [GENERAL] Finally upgrading to 9.6!

On Wed, Oct 18, 2017 at 4:17 PM, Vik Fearing wrote: > On 10/18/2017 08:17 PM, Don Seiler wrote: > > > I disagree with this. It isn't my company's business to test the > > Postgres software in development, as much as it would be needed and > > appreciated by the

Re: [GENERAL] Monitoring Tool for PostgreSQL

ome clever plan, Doctor?" "Yes, Jamie, I believe I have." "What're you going to do?" "Bung a rock at it." -- 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] Finally upgrading to 9.6!

her or not to go right to 10.0, and I quickly put that down. Right, because when you say "official release versus a beta or release candidate", you don't actually mean it. -- Vik Fearing +33 6 46 75 15 36 http://2ndQuadrant.fr PostgreSQL : Exper

Re: [GENERAL] Finally upgrading to 9.6!

mpt, Inc. || http://the.postgres.company/ || @cmdpromptinc PostgreSQL Centered full stack support, consulting and development. Advocate: @amplifypostgres || Learn: https://pgconf.us * Unless otherwise stated, opinions are my own. * -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Finally upgrading to 9.6!

On Wednesday, October 18, 2017, Joshua D. Drake wrote: > > I am not sure why this is even a question. There are plenty of businesses > that can risk the deployment of a .0 release but there are also *MANY THAT > CAN NOT*. The proper way to do this is to have a staging

Re: [GENERAL] Finally upgrading to 9.6!

On Wed, Oct 18, 2017 at 1:08 PM, Vik Fearing wrote: > On 10/18/2017 05:57 PM, Melvin Davidson wrote: > > > > I support the policy of using caution with regards to new versions. They > > are often thought of as "bleeding edge" for the reason described by > > David G

Re: [GENERAL] Monitoring Tool for PostgreSQL

PostgreSQL? There is nothing "official" in the sense that it's developed by the Postgres development group. But OPM looks quite promising: http://opm.io/ There is a pretty extensive list in the Postgres wiki: https://wiki.postgresql.org/wiki/Monitoring -- Sent via pgsql-general mailing

Re: [GENERAL] Finally upgrading to 9.6!

he Betas and RC should have been used in development and QA. -- Vik Fearing +33 6 46 75 15 36 http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- 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] Monitoring Tool for PostgreSQL

We use a PERL script to handle this sort of thing. It’s nice this way since we can run them from just about anywhere. bobb On Oct 18, 2017, at 12:37 PM, Fabricio Pedroso Jorge > wrote: Hi all, is there a "official" monitoring tool for

Re: [GENERAL] Monitoring Tool for PostgreSQL

pported method I'm aware of). -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Monitoring Tool for PostgreSQL

Hi all, is there a "official" monitoring tool for PostgreSQL databases? For example, i come from Oracle Database, and there, we have Enterprise Manager to monitor and administrer the product... is there such a similar tool for PostgreSQL? Thanks for the attention. -- *Fabrício Pedroso

Re: [GENERAL] Finally upgrading to 9.6!

ion to unpromote it should things explode. Minimal downtime for upgrades AND a path back to the old version quickly if needed. All while having setup dev and stage servers ahead of time to get beaten on of course. -- 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 partionning : INSERT with inconsistent return ligne inserted.

+33 6 46 75 15 36 http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- 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] Finally upgrading to 9.6!

stack support, consulting and development. Advocate: @amplifypostgres || Learn: https://pgconf.us * Unless otherwise stated, opinions are my own. * -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] Finally upgrading to 9.6!

On Wed, Oct 18, 2017 at 11:46 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Oct 18, 2017 at 8:16 AM, Igal @ Lucee.org wrote: > >> On 10/18/2017 7:45 AM, Ron Johnson wrote: >> >> On 10/18/2017 09:34 AM, Igal @ Lucee.org wrote: >> >> A bit off-topic here, but

Re: [GENERAL] Finally upgrading to 9.6!

. Then think of it as 9.7.0 but with an easier name to pronounce ;) No .0 is going into production... -- World Peace Through Nuclear Pacification -- 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] Finally upgrading to 9.6!

On Wed, Oct 18, 2017 at 8:16 AM, Igal @ Lucee.org wrote: > On 10/18/2017 7:45 AM, Ron Johnson wrote: > > On 10/18/2017 09:34 AM, Igal @ Lucee.org wrote: > > A bit off-topic here, but why upgrade to 9.6 when you can upgrade to > 10.0? > > > There's no way we're going to put an

Re: [GENERAL] Problems with the time in data type timestamp without time zone

Where is the machine running the database physically located, in another timezone possibly? bobb On Oct 18, 2017, at 10:33 AM, David G. Johnston > wrote: On Wed, Oct 18, 2017 at 8:21 AM, américo bravo astroña

Re: [GENERAL] Problems with the time in data type timestamp without time zone

On Wed, Oct 18, 2017 at 8:21 AM, américo bravo astroña < americobr...@gmail.com> wrote: > Hi, > > I have a program that saves information in a DB Postgresql need to extract > data from date and time of that DB but when I retrieve the date and time > information is always ahead 3 hours, the type

[GENERAL] Problems with the time in data type timestamp without time zone

Hi, I have a program that saves information in a DB Postgresql need to extract data from date and time of that DB but when I retrieve the date and time information is always ahead 3 hours, the type of data that has that field is timestamp without time zone, Please forgive my english I'm using

Re: [GENERAL] Finally upgrading to 9.6!

On 10/18/2017 7:45 AM, Ron Johnson wrote: On 10/18/2017 09:34 AM, Igal @ Lucee.org wrote: A bit off-topic here, but why upgrade to 9.6 when you can upgrade to 10.0? There's no way we're going to put an x.0.0 version into production. Then think of it as 9.7.0 but with an easier name to

Re: [GENERAL] pg_dump throws too many command-line arguments in Postgres 10

ump thinks your hostname is "-U", your database is "admin", and everything after that is extra. Yours, Paul -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] pg_dump throws too many command-line arguments in Postgres 10

Andrus -- 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] Finally upgrading to 9.6!

ssible you'll need *less*, as you'll be absorbing the benefit of several years' worth of performance improvements. But this is such a workload-dependent thing that there's no general answer. XML stored in blobs (not sure whether text or bytea) and b-tree indexes. A bit off-topic here, but why u

Re: [GENERAL] Finally upgrading to 9.6!

tirely possible you'll need *less*, as you'll be absorbing the benefit of several years' worth of performance improvements. But this is such a workload-dependent thing that there's no general answer. XML stored in blobs (not sure whether text or bytea) and b-tree indexes. A bit off-topic here, b

Re: [GENERAL] Finally upgrading to 9.6!

orbing the benefit of several years' worth of performance improvements. But this is such a workload-dependent thing that there's no general answer. XML stored in blobs (not sure whether text or bytea) and b-tree indexes. A bit off-topic here, but why upgrade to 9.6 when you can upgrade t

Re: [GENERAL] Finally upgrading to 9.6!

worth of performance improvements. But this is such a workload-dependent thing that there's no general answer. XML stored in blobs (not sure whether text or bytea) and b-tree indexes. -- World Peace Through Nuclear Pacification -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) T

Re: [GENERAL] Log storage

Friendly greetings ! You may want to take a look at a postgresql "fork" called pipelinedb : https://www.pipelinedb.com/ https://github.com/pipelinedb/pipelinedb I'm not working for them, not using it, but i happen to know it exist :) *hugs* -- Laurent "ker2x" Laborde

Re: [GENERAL] Log storage

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

<    1   2   3   4   5   6   7   8   9   10   >