Re: Loading table with indexed jsonb field is stalling

nths), > but I keep putting it away. > > Any insight is helpful. My biggest fear is that for whatever reason we will > not be able to reload this table during any particular crisis in the future > should it come to that. > > Thanks. Which version of postgres? How are you loading the data? (application, psql, pg_restore) using (insert, copy)? -- Tim Cross

Re: General question about OS

also see MS embracing Linux more with bash and linux subsystem, availability of linux VMs in Azure etc. For your larger databases, I see more Linux than MS. This could be related to storage and file systems more than anything else. -- Tim Cross

Re: Copy Bulk Ignore Duplicated

ry key, depending on what data type 'document' is and how large it is, you may find adding a column which is a checksum of your 'document' field a useful addition. I have done this in the past where I had an application where name was not unique and we only wanted distinct instances of 'document' (document was a fairly large XML document in this case). -- Tim Cross

Re: psql UPDATE field [tab] expands to DEFAULT?

d for candidates which start with 'other_t' e.g. 'other_table' or it would do nothing i.e. no completion candidates found, telling me there is no match based on the prefix I've typed. -- regards, Tim -- Tim Cross

Re: psql UPDATE field [tab] expands to DEFAULT?

On Tue, 18 Jun 2019 at 10:39, Tom Lane wrote: > Tim Cross writes: > > On Tue, 18 Jun 2019 at 09:34, Ken Tanzer wrote: > >> Thanks Adrian, though I wasn't really seeking tips for column names. I > >> was instead trying to understand whether this particular tab

Re: Compare with default value?

Ulrich Goebel writes: > Hi, > > o.k. I have to give some more information... > > Am 13.03.21 um 19:39 schrieb David G. Johnston: >> On Saturday, March 13, 2021, Ulrich Goebel > > wrote: >> >> I would like to get the rows, where a column has the default value, >>

Re: Compare with default value?

Ulrich Goebel writes: > Hi, > > Am 13.03.21 um 22:21 schrieb Tim Cross: >> Ulrich Goebel writes: >> >>> Hi, >>> >>> o.k. I have to give some more information... >>> >>> Am 13.03.21 um 19:39 schrieb David G. Johnston: &g

Re: CSV From Oracle with timestamp column getting errors

imestamp type - for example ISO or any of the psql timestamp formats (see psql manual). -- Tim Cross

Re: About CVE-2018-1058

fits to namespaces in programming languages. Failing to take advantage of this facility is like writing BASIC with lots of GOSUB and GOTOs - full of unexpected side effects, difficult to follow and hard to manage. -- Tim Cross

Re: The Amazon CloudFront distribution is configured to block access from your country.

required was to point them to EDB for assistance. Thankfully, a number of community members did politely do this and I'm sure the OP was appreciative for the pointers. It has also highlighted an area for possible clarification/improvement on the postgres.org site. -- Tim Cross

Re: Storing state machine

te the state of an item and a SQL statement to report on the state of an order. Your requirement statement is extremely simple and I suspect you have glossed over some of the constraints/requirements, but based on what you have written, your requirement seems to be trivial and easily satisfied with basic database facilities. -- Tim Cross

Re: Timestamp with vs without time zone.

FWS Neil writes: > On Sep 21, 2021, at 12:34 PM, Dave Cramer wrote: > On Tue, 21 Sept 2021 at 13:20, Peter J. Holzer wrote: > > On 2021-09-21 20:50:44 +1200, Tim Uckun wrote: > > That's all true and I won't argue about the madness that is timezones > > in the world. I am simply thinking

Re: Timestamp with vs without time zone.

Tim Uckun writes: > I'll add another layer of complication. > > You have a database server hosted in Australia, and that's also where > your web server and api server is. You have customers all over the > world though so you set up additional API servers in Europe, USA, > Japan etc. > > A korea

Database health check/auditing

s. Most of my technical work over the last 10 years has been with Oracle. I prefer to use scripts over GUI tools like pgAdmin and suspect that there is probably some good resources out there with existing scripts I can use as a starting point. Any pointers greatly appreciated. thanks, Tim -- Tim Cross

Re: Database health check/auditing

efore, so it shouldn't bee too bad. Establishing some standards and change control will help. thanks again, tim On 16 February 2018 at 14:11, Melvin Davidson wrote: > > > On Thu, Feb 15, 2018 at 9:22 PM, Tim Cross wrote: > >> Hi All, >> >> I was wondering i

Re: Database health check/auditing

Ibrahim Edib Kokdemir writes: > Hi Tim, > There are good continuously running apps to monitor postgres. > IMHO, the most successful one is pgcenter. > Here is the link. https://github.com/lesovsky/pgcenter > Thanks, a useful link. Tim -- Tim Cross

Re: Database health check/auditing

lthough rusty, once upon a time, I use to cut quite a lot of perl, so reasonable skill set match. Will check it out. Although on-going monitoring of the systems is definitely required, the first step is to just get an overall handle on the situation. There is no documentation and configuration, maintenance etc has been patchy. Tim -- Tim Cross

Re: Database health check/auditing

old school' (mu4e), where dealing with such preferences is much easier, but our wise network admins ban access internally (but you can still access the web interface...). Top v bottom posting issues are a blast from the past - I've not even seen a reference to it since the old Newsgroups days! ;-) Tim -- Tim Cross

Re: Database health check/auditing

nt in the message. This reduces confusion, misunderstanding and incorrect attribution arising from poor editing and makes it easy to reference the full discussion in one spot rather than having to go back through messages putting it all back together. YMMV. Tim -- Tim Cross

List policy/procedures [was Database health check/auditing]

George Neuner writes: > On Sat, 17 Feb 2018 07:23:32 +1100, Tim Cross > wrote: > >>Thomas Kellerer writes: >> >>> Plus: trimming the original content, so that not the whole email >>> thread is repeated in the quote. >> >>While I'm happy

Re: Need to fix one more glitch in upgrade to -10.2

he location the symbolic link in /usr/bin is pointing to is correct. Tim -- Tim Cross

Re: Need to fix one more glitch in upgrade to -10.2

nstead of using the old /etc/iinit.d scripts, you now do something like systemctl start postgres-10.2.service Tim -- Tim Cross

Re: Need to fix one more glitch in upgrade to -10.2

Rich Shepard writes: > On Sun, 18 Feb 2018, Tim Cross wrote: > >> This may not be relevant, > > Tim, > >Nope. Pat goes for stability, not cutting edge. No systemd in the > forthcoming 15.0, either. > > Thanks, > > Rich No worries, though I'm

Re: Need to fix one more glitch in upgrade to -10.2

Rich Shepard writes: > On Sun, 18 Feb 2018, Tim Cross wrote: > >>> # ll /usr/bin/postgres >>> lrwxrwxrwx 1 root root 35 Feb 17 09:30 /usr/bin/postgres -> >>> ../lib/postgresql/10.2/bin/postgres* > >> Try doing an 'll' on the second part

Re: Need to fix one more glitch in upgrade to -10.2

Rich Shepard writes: > On Mon, 19 Feb 2018, Tim Cross wrote: > >> It is possible for the target of a symbolic link to be changed, deleted >> etc (a dangling sym link). > > Tim, > >Broken symlinks display in a different color, black on a red background if >

<    1   2