What is the best way of selecting current timestamp in UTC?
SELECT
CURRENT_TIMESTAMP as ct1
,timezone('UTC',CURRENT_TIMESTAMP) as ct2
,timezone('utc',now()) as ct3
,CURRENT_TIMESTAMP at time zone 'UTC' as ct4
,NOW() at time zone 'utc' as ct5
Thank you everyone for the help.
Sorry there wasn't much detail given originally.
CURRENT_TIMESTAMP at time zone 'UTC' as ct4
Seems to be working well.
Thanks,
Chris
On 02/27/2018 01:26 PM, David G. Johnston wrote:
On Tue, Feb 27, 2018 at 1:16 PM, chris <mailto:chr...@pgsq
ors_cdc TO bob
I'm looking into parsing the string but i can't find a way to parse in a
way that'll work. Any ideas?
Thanks,
Chris
Hi,
I have a JDBC temping to connect to 2 postgres nodes in a hot standby
configuration. Running postgres 9.4 on centos6.
What we are trying to accomplish is in an event of a failover, to first
try to connect to the master. If that fails to then reach out to the
standby.
I looked online an
Given that the syntax looks correct for the url, how would we go about
debugging that it's not seeing the comma?
On 03/08/2018 02:27 PM, Adrian Klaver wrote:
On 03/08/2018 01:12 PM, chris wrote:
Hi,
I have a JDBC temping to connect to 2 postgres nodes in a hot standby
configur
I'm sorry that took a few days but I am running;
Postgresql-9.4
and
jre7.jar
Thanks in advance.
On 03/08/2018 02:30 PM, chris wrote:
Given that the syntax looks correct for the url, how would we go about
debugging that it's not seeing the comma?
On 03/08/2018 02:27 PM, Adr
I believe its Postgresql-9.4.1208.jre7.jar
On 03/13/2018 05:48 PM, Adrian Klaver wrote:
On 03/13/2018 04:46 PM, chris wrote:
I'm sorry that took a few days but I am running;
Postgresql-9.4
and
jre7.jar
What we are looking for is the JDBC driver you are using?
Thanks in advance.
Oh sorry for getting the wrong information.
How would I get the information on what driver is currently installed?
On 03/14/2018 09:44 AM, Adrian Klaver wrote:
On 03/14/2018 07:51 AM, chris wrote:
I believe its Postgresql-9.4.1208.jre7.jar
Pretty sure solving this is going to require
I wasnt able to find what version we had installed so we went ahead and
reinstalled it.
we downloaded the current version JDBC 4.1 Driver 42.2.1.jre7
We are still having the same problem.
Thanks
On 03/14/2018 03:27 PM, Adrian Klaver wrote:
On 03/14/2018 01:47 PM, chris wrote:
Oh sorry
I did the re install not to change versions but to now know what version
I am running
On 03/21/2018 02:44 PM, Adrian Klaver wrote:
On 03/21/2018 01:16 PM, chris wrote:
I wasnt able to find what version we had installed so we went ahead
and reinstalled it
Maybe I am missing something, but
pg now, I know more
people use it.
—pgadmin4:
I don’t like web client for database, I used it and it is good for
there is simple monitor-windows.
For now, I used jetbrains’s product:datagrip, it is also coded by java,but is
better for dbeaver.
Best Wishes,
Chris
> 在 2018年7月17日，上午6
Hi there,
There is a project named Apache MADlib, may help you.
http://madlib.apache.org
Thanks,
| |
Chris
|
|
yuanzefuwa...@126.com
|
签名由网易邮箱大师定制
On 10/18/2019 02:04，Pankaj Jangid wrote：
Hi,
I am working on a machine-learning project. Because of the available
study material in the ML
Hello list
I'm pondering migrating an FTS application from Solr to Postgres, just
because we use Postgres for everything else.
The application is basically fgrep with a web frontend. However the
indexed documents are very computer network specific and contain a lot
of hyphenated hostnames wi
More blog online, choose one for your attention.
https://www.mssqltips.com/sqlservertip/5745/compare-sql-server-mysql-and-postgresql-features/
Best Regards,
| |
Chris
|
|
yuanzefuwa...@126.com
|
签名由网易邮箱大师定制
On 03/11/2019 19:31，Sonam Sharma wrote：
Hi All,
We are planning to migrate our
Which version? Active session should be green.
Regards,
Chris
On 11/11/2021 21:24，Shaozhong SHI wrote：
I never came across this before and wonder why?
Regards,
David
OWNER TO bob.
This is on postgresl 9.6.
Thank you,
Chris
which my script can isolate the owner's name and set it to
a variable on its own. Same with grant.
Thanks
On 02/16/2018 01:05 PM, Melvin Davidson wrote:
On Fri, Feb 16, 2018 at 2:47 PM, chris <mailto:chr...@pgsqlrocket.com>> wrote:
HI,
I would like to know if the
I'm sorry I realized that I only need to know which users have
permissions to the table which I can do through
$ psql -t
SELECT grantee
FROM information_schema.role_table_grants
WHERE table_name='table_name'
GROUP BY grantee;
thanks!
On 02/16/2018 01:13 PM, chris wrote:
to
addressing these sorts of issues.
>
>
> Be very careful in attempting to codify 'correct' behaviour!
>>
>>
> Correct. I think one way to look at all of this is, "if you wouldn't say
> it to your boss or a client don't say it here". That too has problems but
> generally speaking I think it keeps the restrictions rational.
>
>
I will post a more specific set of thoughts here but in general I think the
presumption ought to be that people are trying to work together.
Misunderstanding can happen. But let's try to act in a collegial and
generally respectful way around eachother.
--
Best Regards,
Chris Travers
Database Administrator
Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com
Saarbrücker Straße 37a, 10405 Berlin
king the CoC official as of
> July 1 2018.
>
> regards, tom lane
>
> [1] https://www.postgresql.org/message-id/56a8516b.8000...@agliodbs.com
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
to form viable third parties in the US political landscape. An
international CoC committee is our best defense against an effort to co-opt
the community in the way you are worried about.
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
banned), and this is one issue which is incredibly divisive
throughout the world with a lot of people having very deep-seated feelings
on the issue, where one can expect small differences to lead to big
conflicts. And I think we want to avoid wading into those conflicts.
>
> Jim
>
>
On Tue, Jun 5, 2018 at 8:42 PM, James Keener wrote:
> I accidentally didn't send this to the whole list. I'll let Chris resend
> his response if he'd like.
>
> On Tue, Jun 5, 2018 at 1:58 PM, James Keener wrote:
>
>> I think the fundamental outcome i
On Wed, Jun 6, 2018 at 2:07 AM, Jan Claeys wrote:
> On Tue, 2018-06-05 at 16:45 +0200, Chris Travers wrote:
> > If I may suggest: The committee should be international as well
> > and include people from around the world. The last thing we want is
> > for it to be dominat
On Thu, Jun 7, 2018 at 2:14 AM, Jan Claeys wrote:
> On Wed, 2018-06-06 at 07:27 +0200, Chris Travers wrote:
> > The real fear here is the code of conduct being co-opted as a weapon
> > of world-wide culture war and that's what is driving a lot of the
> > resistance here
;This word does not mean anything bad
> where I come from."
>
This is true but it is needed that the committee is culturally diverse and
advertised as such. Otherwise I am concerned that it would signal to some
people that a certain sort of abuse would be permitted.
>
> --
> -- Christophe Pettus
>x...@thebuild.com
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
ommittee will likely have to sort out such
> situations and try to reconcile the two people without either starting a
> war or driving away either person. They may not always succeed. But not
> trying is not a better answer.
For what its worth, I am 100% in agreement with everything
direction.
>
> I'd probably leave it up to the CoC team/people to figure it out. :)
+1
If it were me I would just say that CoC has an obligation to try in good
faith to resolve things in line with the common interest of an
international community and leave it at that.
>
>
&
VS Code is open source (MIT License). You may be thinking of Visual Studo, the
closed source IDE - the two are not the same
Met vriendlijke groet,
REDstack BV
Chris Coutinho
Onderzoeker/Data analist
-Original Message-
From: Tim Clarke [mailto:tim.cla...@minerva-analytics.info]
Sent
this is clearly intended to be supported we would
like to work with upstream library vendors to make sure this functionality
is included. My reading of the docs is that parameterized queries are not
possible but simple queries are. Is this correct?
--
Best Wishes,
Chris Travers
Efficito:
ly free ?
>> > Any performance issues or any limitations?
>>
>> Yes, yes, depends
>>
>> --
>> Adrian Klaver
>> adrian.kla...@aklaver.com
>>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
fference.
I was wondering if anyone else had seen this behavior on their RDS Postgres
instances or had any suggestions on how I could shorten the shutdown time?
Thanks,
Chris
nually shutting
down all of my apps ahead of time is a real headache. Given that I haven't
gotten anywhere with their support, I figured I'd try asking on the mailing
list.
Thanks,
Chris
On Thu, Sep 13, 2018 at 3:17 PM Joshua D. Drake
wrote:
> On 09/13/2018 03:04 PM, Chris William
PostgreSQL.
>
> I think we are about ready to announce the initial membership of the
> CoC committee, as well, but that should be a separate post.
>
> regards, tom lane
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
On Fri, Sep 14, 2018 at 10:31 AM Chris Travers
wrote:
>
>
> On Wed, Sep 12, 2018 at 10:53 PM Tom Lane wrote:
>
>> I wrote:
>> > Stephen Frost writes:
>> >> We seem to be a bit past that timeline... Do we have any update on
>> when
>>
On Fri, Sep 14, 2018 at 11:45 AM Ilya Kosmodemiansky
wrote:
> On Fri, Sep 14, 2018 at 10:31 AM, Chris Travers
> wrote:
> > I really have to object to this addition:
> > "This Code is meant to cover all interaction between community members,
> > whether
On Fri, Sep 14, 2018 at 4:14 PM Dave Page wrote:
>
>
> On Fri, Sep 14, 2018 at 3:08 PM, Joshua D. Drake
> wrote:
>
>> On 09/14/2018 01:31 AM, Chris Travers wrote:
>>
>>
>> I apologize for the glacial slowness with which this has all been moving.
&
On Fri, Sep 14, 2018 at 4:16 PM Tom Lane wrote:
> [ Let's try to trim this discussion to just -general, please ]
>
> Robert Eckhardt writes:
> > On Fri, Sep 14, 2018 at 9:41 AM, Adrian Klaver
> > wrote:
> >> On 9/14/18 1:31 AM, Chris Travers wrote:
&g
is today and we must continue to do this.
2. Compared to the rest of the world, people from my culture (the US) have
a tendency to take disagreements regarding political policies, social
theories, etc. personally and see abuse/attack where mere disagreement was
present. People making complaints aren't necessarily acting in bad faith.
3. If we don't set the expectation ahead of time that we remain
pluralistic in terms of political philosophy, culture, then it is way too
easy to end up in a situation where people are bringing up bad press for
failing to kick out people who disagree with them.
Like it or not there are precedents for this in the open source community,
such as the dismissal of Brendan Eich, and in an international project with
developers from all kinds of cultures with different views on deeply
divisive issues, such conflicts could hurt our community.
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
and keep the peace, giving people room for civic
engagement even on divisive issues.
And frankly I am probably being paranoid here though I find paranoia is a
good thing when it comes to care of databases and computer systems. But I
do worry about the interactions between the PostgreSQL comm
7;s
all a shot in the dark I guess since we don't know the underlying cause.
Best,
Chris
On Fri, Sep 14, 2018 at 8:43 AM Jeremy Schneider
wrote:
> Hi Chris - this is an interesting one that we do see from time to time;
> seems worth responding here as actually our best understanding right
se while I don't see
the current community taking action on the basis of political views, I do
see a problem more generally with how these fights get picked and would
prefer to see some softening of language to protect the community in that
case. But again, I am probably being paranoid.
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
another Code of Conduct that takes precedence (such as a
conference's Code of Conduct)." I don't think that sentence solves the
problems you are trying to solve, and I think it creates new ones.
However I have said my piece. Unless there are replies that provide
something new for me to add, I won't continue arguing over that from here.
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
y big problem here since it
means you can have race conditions in advisory locks that can't happen with
other locking issues. I still love advisory locks but they are not a good
tool for this.
The real solution most of the time is actually to lock the rows by
selecting FOR UPDATE and possibly SK
> JD
>
> --
> Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc
> *** A fault and talent of mine is to tell it exactly how it is. ***
> PostgreSQL centered full stack support, consulting and development.
> Advocate: @amplifypostgres || Learn: https://postgresconf.org
> * Unless otherwise stated, opinions are my own. *
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
On Mon, Sep 17, 2018 at 6:08 PM Steve Litt
wrote:
> On Mon, 17 Sep 2018 17:39:20 +0200
> Chris Travers wrote:
>
>
> > Exactly. And actually the first sentence is not new. The second one
> > is a real problem though. I am going to try one last time at an
&g
nk&utm_campaign=sig-email&utm_content=emailclient>
> <#m_-9091154853724945458_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
oing elsewhere. So I don't think ti is a question of "trust us" but
rather that the community won't let that sort of abuse happen no matter who
is on the CoC committee.
>
>
> regards
>
> --
> Tomas Vondra http://www.2ndQuadrant.com
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
reason to think that feedback gathered now will have
any impact at all in the next revision.
>
> regards, tom lane
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
oC to emphasise that while we don't want to restrain people
> from "calling out" egregious behaviour, going via the CoC team is often
> more likely to lead to constructive communication and positive change.
>
Agreed on this.
My objection to the additional wording is simply that a) I think it does
not tackle the problem it needs to tackle, and b) creates a claim which
covers a bunch of things that it really shouldn't. It's a serious bug and
I still hope it gets fixed before it causes problems.
>
> --
> Craig Ringer http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
nice addition and
prevents a lot of concern.
>
> --
> Bruce Momjian http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + As you are, so once was I. As I am, so you will be. +
> + Ancient Roman grave inscription +
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
atabase is constructed with pg_dump and restore on fresh postgres
> installation.
>
Sounds like warming up the cache, but still in a test environment you may
want to add auto_explain to your list of preloads and perhaps set it to
dump explain analyze when it hits a certain threshold. Note t
gt;>
>>> On Wed, Oct 3, 2018, 7:43 PM Sonam Sharma wrote:
>>>
>>>> I have restored the database from backup dump but the size of source
>>>> and target databases are different. What can be the reason for this ?
>>>>
>>>> Regards,
>>>> Sonam
>>>>
>>>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
sense of index possibilities and
how the indexes actually work.
> lbrtchx
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
iting an import for JSON objects into a particular database is
indeed trivial.
>
> C
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
I'm looking for a system query that will lookup the primary key column on a
fdw table. It's possible we need to declare that part of the foreign
table's schema in the local (is that the right term?) database?
Here's the foreign table - I don't see anything showing a primary key, so
my hunch is we
The foreign table has a primary key. Ruby on Rails uses a system query to
lookup what the primary key on the table is, but it's querying the local
database, and not finding anything. In a schema dump of the local database,
I don't see a primary key defined, so I'm presuming I need to issue an ADD
C
nston <
david.g.johns...@gmail.com> wrote:
> On Wed, Oct 23, 2019 at 8:47 AM Chris Morris
> wrote:
>
>> The foreign table has a primary key. Ruby on Rails uses a system query to
>> lookup what the primary key on the table is, but it's querying the local
>> database,
would this be updated?
cheers,
Chris
On 05/11/2019 22:54, Adrian Klaver wrote:
On 11/5/19 2:46 PM, Chris Withers wrote:
Hi All,
Brazil recently abolished daylight savings time, resulting in updates
to system timezone information packages.
Does postgres use these? If so, does it need a reload or restart to
see the updated zone
the left pane
and then it allows me to edit the SQL in the query pane.
Thank you for any help you may provide.
Chris
*What does the Windows system log show when you do this?*
I don't know where to find this log (for Windows 10)
On Mon, Feb 3, 2020 at 3:47 PM Adrian Klaver
wrote:
> On 2/3/20 12:44 PM, Chris Charley wrote:
> Please reply to list also.
> Ccing list.
> > Adrian
> >
>
; On 2/3/20 12:54 PM, Chris Charley wrote:
> > /What does the Windows system log show when you do this?/
> >
> > I don't know where to find this log (for Windows 10)
> >
>
> I'm not a Windows user, what I can do is point you at:
>
>
> https://www
I tried items you suggested (1-5), but could find no helpful info.
Thanks for your help and going the extra mile!
On Mon, Feb 3, 2020 at 4:23 PM Adrian Klaver
wrote:
> On 2/3/20 1:11 PM, Chris Charley wrote:
> > Hi
> >
> > The link you provided
> > (
> https:
Moreno, thank you for all your help.
Following your instructions, I was able to recover my databases. All is
good.
Chris
On Wed, Feb 5, 2020 at 6:45 AM Moreno Andreo
wrote:
> Il 04/02/2020 21:18, Chris Charley ha scritto:
> > Hello Moreno
> >
> > Thanks for the reply!
&
Monday and thinking about potential problems related to the
number of available connections.
What's "too much" for max_connections? What happens when you set it to
high? What factors affect that number?
cheers,
Chris
Hi Chris
On Fri, 7 Feb 2020, 08:36 Chris Withers, wrote:
> Hi All,
>
> What's a sensible way to pick the number to use for max_connections?
>
Sensible in this context is some what variable. Each connection in
PostgreSQL will be allocated a backend process. These are not th
On 07/02/2020 12:49, Chris Ellis wrote:
What's "too much" for max_connections? What happens when you set it to
high? What factors affect that number?
When sizing max_connections you need to trade off how many connections
your application will use at peak vs how much RAM a
Is it even possible to use PG partitioning across a Foreign Server?
>
> > Is it even possible to use PG partitioning across a Foreign Server?
> I am not certain what you mean, but you can have foreign tables as
> partitions
> of a partitioned table. The partitions won't be processed in parallel
> though.
I have a large, growing table, that I'd like to start part
>
> Not yet.. There is ongoing work to make that happen though.
Glad to hear it. :) Thx.
Right now my dbs are hosted by Heroku, so I doubt I have any control over
the dbs at that level.
Thanks for the idea though! :)
On Wed, Mar 25, 2020 at 12:04 PM Michael Lewis wrote:
> Chris,
> Does it actually need to be a different server and database, or would it
> be possibl
I have a local script I've written that will scan a log of PG queries to
extract out unique queries without any specific parameter data. For
example, if these 2 queries are actually run:
SELECT * FROM foo where bar = 1;
SELECT * FROM foo where bar = 2;
It will capture only:
SELECT * FROM foo whe
Thx!
On Sat, Apr 11, 2020 at 11:55 PM Julien Rouhaud wrote:
> On Sun, Apr 12, 2020 at 6:51 AM Chris Morris
> wrote:
> >
> > I have a local script I've written that will scan a log of PG queries to
> extract out unique queries without any specific parameter data.
893183'::bigint))
-> Bitmap Index Scan on "IDX_DiaSource_htmId20"
disastrous :)
Planning Time: 7.569 ms
Execution Time: 316969.474 ms
On Thu, Apr 16, 2020 at 9:23 AM Pavel Stehule
wrote:
>
>
> čt 16. 4. 2020 v 16:08 odesílatel Chris Stephens
> napsal:
>
>> PG12
>> RHEL 8
>>
>> I suspect there's little I can do
On Thu, Apr 16, 2020 at 10:47 AM Michael Lewis wrote:
> My other thought was to range partition by pixelID + brin index.
>
> I would expect brin index to be INSTEAD of partitioning. You didn't share
> buffer hits, which I expect were 100% on the subsequent explain analyze
> runs, but the
as another Oracle DBA trying to pick up Postgresql one thing i haven't come
across are script libraries such as there are for Oracle (
https://github.com/tanelpoder/tpt-oracle and
https://oracle-base.com/dba/scripts as examples).
Does anything like that exist for PG? Would be nice to see how peopl
nything, am I getting badly wrong here?
- what can I do to speed up creation of this index?
- failing that, what can I do to import and then create the index
in the background?
As you can imagine, a 15hr outage for an upgrade has not met with
large amounts of happiness from the people whose application it is
;-)
Chris
On 14/05/2020 21:16, k...@rice.edu wrote:
Hi Chris,
This sounds like a candidate for pg_logical replicating from the old to
new system.
Can you point me to a good guide as to how to easily set this up for one
database and would work between pg 9.4 and pg 11.5?
cheers,
Chris
On 14/05/2020 21:31, Tom Lane wrote:
Chris Withers writes:
It has 4.1 million rows in it and while importing the data only
takes a couple of minutes, when I did a test load into the new
cluster, building the mkt_profile_period_col1_col4_col2_chan_excl
index for the
We're using Heroku's PG, and it comes with a default, almost super-user.
I'm wanting to restrict that account for only our production app servers,
and have anyone connecting for personal queries to go through an assigned
role by employee (that's all setup and working).
Other than polling pg_stat_a
Ah, I do appear to have that enabled (inside Heroku's config), but I can't
find anything like that in the logs, so I've opened a ticket with them. Thx
a lot!
On Fri, May 29, 2020 at 2:25 PM Peter J. Holzer wrote:
> On 2020-05-29 12:42:47 -0500, Chris Morris wrote:
> >
high throughput systems (I have
systems where a db cluster generates 10-20TB of WAL per day)
So I am not at all sure this would be a step in the right direction or
worth the work.
>
> --
> Andreas Joseph Krogh
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
posgresql 12
centos 7
i am trying to configure ldap authentication.
i have the following pg_hba.conf entry (server and basedn are correct but
not shown):
hostsslall all 0.0.0.0/0 ldap
ldapserver="ldaps://xxx" ldapbasedn="yyy" ldaptls=1
when i attempt to
!
On Mon, Jun 8, 2020 at 7:41 PM Thomas Munro wrote:
> On Tue, Jun 9, 2020 at 9:05 AM Chris Stephens
> wrote:
> > hostsslall all 0.0.0.0/0 ldap
> ldapserver="ldaps://xxx" ldapbasedn="yyy" ldaptls=1
>
> > does
it looks like there are a number of roles available through ansible galaxy
that support initial postgresql setup and configuration.
i'm wondering if there are any that are more popular/capable that i should
consider vs just picking a few and evaluating those.
does anyone have any recommendations?
in future releases?
Regards, Chris Sterritt
lsn).
Can you imagine other things that I could check from within postgres with
limited permissions to diagnose this?
Best Regards
Chris
from
within postgres?
Best Regards
Chris
On Tue, Aug 4, 2020 at 11:39 AM Srinivasa T N wrote:
> There may be lot of wal files or the size of log files in pg_log might be
> huge. "du -sh *" of data directory holding the database might help.
>
> Regards,
> Seenu.
>
>
Thanks for your insight!
I cannot find any errors related to archiving in the logs that are
accessible to me.
It's definitely something that I will forward to the support team of the
managed database.
Best Regards
Chris
On Thu, Aug 6, 2020 at 3:18 AM Mohamed Wael Khobalatte <
shot
(:
Best Regards
Chris
On Fri, Aug 7, 2020 at 4:22 PM Christoph Moench-Tegeder
wrote:
> ## Chris Borckholder (chris.borckhol...@bitpanda.com):
>
> > We are experiencing a strange situation with an AWS Aurora postgres
> > instance.
>
> The main problem here is that &quo
lue from, say, 100 IDR to 100 EUR at least for
display purposes.
I have some thoughts about how to do a multi-currency type but I am not
actually sure you get anything by tying the data together instead of having
it in separate columns.
>
> cheers,
> raf
>
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
e basically immutable.
>
> --
> Scott Ribe
> scott_r...@elevated-dev.com
> https://www.linkedin.com/in/scottribe/
>
>
>
>
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more
2meas1');
Now if you repeat the check for new measurements with the same query as at *,
you only get 3 rows.
Cheers, Chris Sterritt
s.station_id,sd.ameasurement from src_data sd join (SELECT
station_id,station_data FROM ins_station UNION SELECT station_id,station_data
FROM station)s using (station_data)
except select station_id,ameasurement from measurement;
select * from station;
select * from measurement;
Regards,
Chris Sterritt
s more something like delete+insert). So even if
the value of the column doesn't change, its tuple location changes, so
the index needs to be updated to reflect that change.
--
Guillaume.
If you execute
vacuum full plop;
you will see the size shrink back as the dead tuples will have been removed.
Chris
posgresql verion: 12
i can accomplish this procedurally fairly easily but would like to do this
strictly in SQL.
jsondb=# select jsonb_typeof(jsonb_path_query(vdl_json,'$.tables[*]')) from
vdl_json2;
jsonb_typeof
--
object
object
object
object
object
object
(6 rows)
jsondb=# s
n stays in bounds, or redesign your application.
In some cases it might help to restart your sessions when they get too
big, but that seems like at best a band-aid.
regards, tom lane
Would executing DISCARD ALL release the PL cache?
Regards, Chris Sterritt
alter column loc_nbr drop constraint
unique;' also
failed.
What's the proper syntax to drop the unique constraint on a table column?
TIA,
Rich
You need
alter table locations drop constraint ;
Cheers, Chris Sterritt
1 - 100 of 194 matches
Mail list logo
