Re: Blank, nullable date column rejected by psql

On 2/11/19 5:44 PM, Rich Shepard wrote: On Mon, 11 Feb 2019, Ron wrote: You've got ADOS (All Databases are Oracle Syndrome). Interesting as I've never bought, used, or seen anything from Oracle. Guess it's transmitted by errent bits. It's easily transmitted via toilet seats. -- Angular

Re: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2

On 2/15/19 4:04 PM, Bruce Klein wrote: [snip] I'm glad Microsoft is trying though If Steve "Linux is a cancer" Ballmer were dead, he's be spinning in his grave... -- Angular momentum makes the world go 'round.

Re: Copy entire schema A to a different schema B

On 2/11/19 10:00 AM, Tiffany Thang wrote: Hi, To copy the source schema A to target schema B in the same database in PG10.3, I use psql to dump schema A and manually removes anything specific to the schema in the text dump file before importing into schema B. How do I achieve the same

Re: pgexpress 4.60 vita voom

On 1/30/19 5:22 AM, ceuro wrote: Hello everybody, this is my first post. I need to update to vita voom pgexpress 4.60 in order to upgrade to postgresql 9.2: I've tried to contact vita voom to collect (I've also already payed) the last release of the driver but nobody answer me: Is there anybody

Re: Need a command to take the backup of the child tables along with its master table.

On 1/24/19 3:40 AM, Raghavendra Rao J S V wrote: Hi All, We have one master table and multiple child tables (dependent tables)  associated with it. While taking the backup of the master table , I would like to take the backup of all its child (dependent) tables backup also. Please guide

[pgbackrest] Expiring the last backup?

Hi, The backups partition is running out of disk space, and I need to delete the only backup. $ pgbackrest expire --stanza=localhost --retention-full=0 ERROR: [032]: '0' is out of range for 'repo1-retention-full' option So, in version 2.07, what's the secret sauce for deleting that final

Re: how to properly start postgresql with no TCP listeners in ubuntu 16.04 LTS

On 1/23/19 8:41 PM, Alex Morris wrote: On 1/23/19 19:15, Stephen Frost wrote: Greetings, * Alex Morris (alex.mor...@twelvemountain.com) wrote: This question may simply be my ignorance of what piece of the systemd / systemctl puzzle needs attention.  Any clues are appreciated. The simplest

Re: Casting Integer to Boolean in assignment

On 1/24/19 9:05 AM, Geoff Winkless wrote: On Thu, 24 Jan 2019 at 14:28, David G. Johnston wrote: To assist developers in avoiding the writing of buggy queries. Amazing how many of these developers find this a hindrance. If only they could see how helpful we're being to them. It's the C vs.

Re: Casting Integer to Boolean in assignment

On 1/24/19 5:04 AM, Alexandre GRAIL wrote: Hello the list, Maybe this question has been debated before (I didn't find anything helpful) but : Why the default is to throw an error when casting Integer to Boolean in assignment, and accepting it everywhere else ? So you can type :

Re: [pgbackrest] Expiring the last backup?

On 1/24/19 7:26 AM, Stephen Frost wrote: Greetings, * Ron (ronljohnso...@gmail.com) wrote: The backups partition is running out of disk space, and I need to delete the only backup. $ pgbackrest expire --stanza=localhost --retention-full=0 ERROR: [032]: '0' is out of range for 'repo1-retention

Re: [pgbackrest] Expiring the last backup?

On 1/24/19 8:11 AM, Stephen Frost wrote: Greetings, * Ron (ronljohnso...@gmail.com) wrote: On 1/24/19 7:26 AM, Stephen Frost wrote: * Ron (ronljohnso...@gmail.com) wrote: The backups partition is running out of disk space, and I need to delete the only backup. $ pgbackrest expire --stanza

Date calculation

Hi, v9.6.6 Is there a built in function to calculate, for example, next Sunday? For example, postgres=# select current_date, next_dow(current_date, 'Sunday');     date    |    date |  2019-01-31 | 2019-02-03 (1 row) Thanks -- Angular momentum makes the world go

Re: problem

On 1/31/19 7:10 AM, Mirco Gallazzi wrote: GoodMornig, I can’t install postgres on my pc because i have Always this error: “ Problem running post-install step. Installation may not complete correctly. The database cluster initialisation failed.” I looked for a guide that can help me to

Re: Recommendation to run vacuum FULL in parallel

Look also at pg_stat_all_tables.n_dead_tup for tables which are candidates for vacuuming. On 4/10/19 11:49 PM, Perumal Raj wrote: Thanks Kevin for the inputs, In my Case there are 500+ Tables and biggest chunk 30GB ( Table only) + its indexes. So i have created 6 batches and executed in

Re: pg_upgrade --jobs

On 4/6/19 6:50 PM, Tom Lane wrote: senor writes: [snip] The --link option to pg_upgrade would be so much more useful if it weren't still bound to serially dumping the schemas of half a million tables. To be perfectly blunt, if you've got a database with half a million tables, You're Doing It

Re: Trigger when user logs in

On 4/11/19 9:52 PM, Tom Lane wrote: Ron writes: On 4/11/19 9:12 PM, Tom Lane wrote: PAM is the usual suggestion Can you be more specific? I'm suggesting that you use PAM auth https://www.postgresql.org/docs/current/auth-pam.html and then configure the email behavior on the PAM side

Trigger when user logs in

Hi, PCI auditors have mandated that our databases (all running v9.6) send an email when certain users log in.  Thus, I've been searching for how to do this, but without much luck. https://www.postgresql.org/message-id/flat/20170720204733.40f2b7eb.nagata%40sraoss.co.jp This long thread from

Re: Trigger when user logs in

On 4/11/19 9:12 PM, Tom Lane wrote: Ron writes: PCI auditors have mandated that our databases (all running v9.6) send an email when certain users log in.  Thus, I've been searching for how to do this, but without much luck. PAM is the usual suggestion Can you be more specific?  (All users

Re: Alter domain type / avoiding table rewrite

On 4/16/19 9:42 AM, Tom Lane wrote: Adrian Klaver writes: I suspect the OP wants the type to text with a CHECK constraint to allow for increasing the length of field values in the future by just changing the CHECK setting. If that is the case would changing the type to text and then adding a

Re: Alter domain type / avoiding table rewrite

On 4/16/19 9:28 AM, Adrian Klaver wrote: On 4/16/19 7:19 AM, Ron wrote: On 4/16/19 4:22 AM, Tim Kane wrote: So I have a situation where I would like to modify a field that is currently a domain type over a varchar(9) Specifically: CREATE DOMAIN old_type AS varchar(9) This isn't ideal, let's

Re: Alter domain type / avoiding table rewrite

On 4/16/19 4:22 AM, Tim Kane wrote: So I have a situation where I would like to modify a field that is currently a domain type over a varchar(9) Specifically: CREATE DOMAIN old_type AS varchar(9) This isn't ideal, let's just say.. legacy. I wish to modify this type.. ideally to a text type

Re: Multicolumn index for single-column queries?

On 4/18/19 8:45 AM, Gavin Flower wrote: On 19/04/2019 01:24, Ron wrote: On 4/18/19 2:14 AM, Andreas Kretschmer wrote: [snip] (Prefix compression would obviate the need for this question. Then your multi-column index would be *much* smaller.) True, but a multi column index will still

Re: Multicolumn index for single-column queries?

On 4/18/19 2:14 AM, Andreas Kretschmer wrote: Am 18.04.19 um 08:52 schrieb rihad: Hi. Say there are 2 indexes:     "foo_index" btree (foo_id)     "multi_index" btree (foo_id, approved, expires_at) foo_id is an integer. Some queries involve all three columns in their WHERE clauses, some

Re: Trigger when user logs in

On 4/13/19 7:28 PM, Schneider, Jeremy wrote: On Apr 11, 2019, at 19:52, Tom Lane wrote: Ron writes: I bet requests like this will start to make it onto the beaten path. Meh. I'm not that excited about inventing our own versions of wheels that already exist, especially when there's nothing

Re: When do vacuumed pages/tuples become available for reuse?

On 4/11/19 12:24 PM, Tom Lane wrote: Alvaro Herrera writes: On 2019-Apr-11, rihad wrote: 2019-04-11 19:39:44.450844500   tuples: 19150 removed, 2725811 remain, 465 are dead but not yet removable What Jeff said. This vacuum spent a lot of time, only to remove miserly 19k tuples, but 2.7M

Re: Safe to delete files?

On 4/12/19 3:11 PM, Paul van der Linden wrote: Hi, For my process, I needed to drop all the tables in a tablespace except one which I truncated. After that I would have expected to have a couple of KB max in that folder, but there was about 200GB in it. Did you vacuum afterwards? There

Re: Trigger when user logs in

On 4/14/19 4:05 AM, Peter J. Holzer wrote: On 2019-04-13 22:22:16 -0500, Ron wrote: In our case, another looming Auditor requirement is to be able to instantly kick off -- or at least send a warning email -- when certain roles log in from unapproved IP addresses or programs.  For example

Re: pg_basebackup from 9.4-bdr to 9.4 results in corrupt index

On 5/25/19 11:49 AM, Jānis Pūris wrote: Hello, I'm working with a 9.4-bdr cluster and want to move away from BDR tech all together. So my idea was to follow instructions on http://bdr-project.org/docs/stable/ to first strip the node from BDR making it into "regular" node and then moving the

Re: Converting yes or no to one letter strings.

On 6/4/19 7:19 PM, Adrian Klaver wrote: On 6/4/19 3:29 PM, Lou wrote: Hi everyone, Is it possible to convert a boolean yes or no field to hold a one letter string? For example, the strings: 's' 'f' 'p' 'e' To start off, I just need to convert true to 's'. false will have to be manually

Re: delimeters psql /CSV

On 6/7/19 5:01 AM, paul.m...@lfv.se wrote: Hi, I have a problem with psql and CSV. C:\Users\an\bin>C:\Tmp\psql -h 10.211.43.22 -p 5432 -U postgres -d aatest -w  -c  "\copy public.""Bayern"" FROM 'C:\Users\an\test\Bayern.csv' WITH DELIMITER ';' CSV" Error:  extra data after expected last

Re: configure multiple repository path in pgbackrest

You set pg1-path and pg1-port in both v1demo and v2demo. Shouldn't v2demo use pg2-path and pg2-port? On 6/5/19 2:43 PM, Pavan Kumar wrote: Hello Ron, Thank you so much for quick response. here is my configuration. [postgres@oralnx v2demo4448]$cat /etc/pgbackrest/pgbackrest.conf [v1demo] pg1

Re: with and trigger

On 5/29/19 8:26 AM, Tom Lane wrote: PegoraroF10 writes: We like to use With to insert, update and return some value to user. But some informations of those related tables are not available on that time, is that a bug ? No, see the "WITH Clause" section of the SELECT reference page: The

Re: configure multiple repository path in pgbackrest

On 6/5/19 9:48 AM, Pavan Kumar wrote: Hello Experts, Is it possible to configure multiple backup repositories in pgbackrest tool in one server? I am getting few issues with that. https://pgbackrest.org/command.html#command-backup 3.4.9 Repository Path Option (--repo-path) Path where

Re: Snippets?

On 5/24/19 1:15 PM, Ken Lacrosse wrote: Is there any way in postgresql to have a "snippet" of SQL code which you could apply to all tables.  Something you could add which would ensure that every table always has a Created, Changed and Deleted column for example.  Sort of like a C include I

Re: Snippets?

On 5/24/19 1:27 PM, Adrian Klaver wrote: On 5/24/19 11:15 AM, Ken Lacrosse wrote: Is there any way in postgresql to have a "snippet" of SQL code which you could apply to all tables. Something you could add which would ensure that every table always has a Created, Changed and Deleted column for

Re: vacuum/reindex

On 6/14/19 2:55 PM, Rob Sargent wrote: Is reindex table redundant after vacuum(analyse,verbose)? Instead of "redundant", I'd call it "backwards", since doing a vacuum(analyse,verbose) on a freshly reindexed table seems more fruitful. -- Angular momentum makes the world go 'round.

Re: Upgrade from PostgreSQL 9.6 to 11

On 6/9/19 11:36 PM, Pawan Sharma wrote: Hello All. What is the best way to upgrade from PostgreSQL 9.6 to PostgreSQL 11 instead of pg_upgrade. - Less downtime. - Approx database size are 1-3TB. If you really don't want to do pg_upgrade, then a possibility is multi-threaded pg_dump using

Re: User Details for PostgreSQL

https://github.com/pgaudit/pgaudit might help.  It's packed for install by the Postgres team,  (Of course, it's too late for existing accounts.) On 5/9/19 4:11 PM, Kumar, Virendra wrote: Thanks Chris! Since PostgreSQL still have to have those accounts even if we authenticate it externally

Re: Table update: restore or replace?

On 5/14/19 3:59 PM, Rich Shepard wrote: On Tue, 14 May 2019, Adrian Klaver wrote: A file level backup or database dump? Adrian, File level. April 20th is my most recent database dump because I forgot to run it last Friday afternoon. Note that referring to file level copies as dumps can be

Re: bigint out of range

On 5/18/19 5:39 PM, Peter J. Holzer wrote: On 2019-05-18 17:14:59 -0500, Ron wrote: On 5/18/19 3:49 PM, Peter J. Holzer wrote: On 2019-05-18 15:19:22 -0500, Ron wrote: On 5/18/19 2:27 PM, Peter J. Holzer wrote: On 2019-05-18 10:49:53 -0700, David G. Johnston wrote

Re: bigint out of range

On 5/18/19 2:27 PM, Peter J. Holzer wrote: On 2019-05-18 10:49:53 -0700, David G. Johnston wrote: On Saturday, May 18, 2019, Peter J. Holzer wrote: On 2019-05-16 08:48:51 -0700, David G. Johnston wrote: > On Thu, May 16, 2019 at 8:31 AM Daulat Ram wrote: > > >   

Re: bigint out of range

On 5/18/19 3:49 PM, Peter J. Holzer wrote: On 2019-05-18 15:19:22 -0500, Ron wrote: On 5/18/19 2:27 PM, Peter J. Holzer wrote: On 2019-05-18 10:49:53 -0700, David G. Johnston wrote: You don’t perform math on a hash That's not generally true. Hashes are used for further computation

Re: Centos : Load Average :OS Process Name : migration/1, migration/2 , migration/n

On 5/22/19 4:18 PM, Perumal Raj wrote: Hi All, We have recently migrated postgres DB to out of of server ( Centos 6.9 ) . Both Source and Target versions of OS/DB are same . Also Configuration is Apple-Apple. But We started seeing lot of process name 'migration' at OS Level in new server

Re: Oracle Migration Approach (Open source vs Vendor Specific)

On 5/8/19 3:30 PM, Sandeep Saxena wrote: [snip] @Ravi My company is trying to avoid another vendor lockin too , thats why we are bit skeptical on going to EDB as once we start using their Oracle compatability feature then it will be very difficult to move to community addition again. What

Re: Bulk inserts into two (related) tables

On 5/21/19 12:27 PM, Rich Shepard wrote: On Tue, 21 May 2019, Michael Lewis wrote: For each row- Insert into organizations table if the record does not exist, returning ID. Insert into people using that ID. Michael, The org_id will not exist until I run the insert script. Else, load all

Re: Upgrading 9.1.17 to which version?

On 5/16/19 4:36 AM, nigel.ander...@gmx.com wrote: Hi, I've just inherited an ancient install of 9.1.17 after our tech guy left, on what turns out to be a rapidly dying server and being a total newb to PostgreSQL (and not much more advanced on Linux) I'm a little stuck on the way ahead. I've

Re: Loading table with indexed jsonb field is stalling

On 5/20/19 7:21 PM, Will Hartung wrote: On May 20, 2019, at 5:15 PM, Ron wrote: Are there a sufficiently small number of elements in each traits object that you can do something like this, on the UNINDEXED table? SELECT traits->element1, traits->element2, count(*) from eis_entry

Re: Loading table with indexed jsonb field is stalling

On 5/20/19 4:48 PM, Will Hartung wrote: On May 20, 2019, at 2:36 PM, Ron wrote: I think you answered this earlier, but does the same stalling happen when indexes are dropped? No, the data loads fine. The way I originally stumbled upon this was that I had off loaded the data for some other

Re: Loading table with indexed jsonb field is stalling

On 5/20/19 6:51 PM, Will Hartung wrote: On May 20, 2019, at 4:27 PM, Ron <mailto:ronljohnso...@gmail.com>> wrote: I'm confused.  You wrote above that loading without indexes and with just the PK works just fine; if you *really* need it loaded in Aurora or production, just drop th

Re: Loading table with indexed jsonb field is stalling

On 5/20/19 4:14 PM, Will Hartung wrote: [snip] Also to note, I tried just loading the table with no indexes, and I was getting a solid 22MB/s via iostat of just raw data load (just to proof that I/O system, while certainly not extraordinary, was functional). I think you answered this earlier,

Re: Loading table with indexed jsonb field is stalling

On 5/20/19 5:43 PM, Will Hartung wrote: On May 20, 2019, at 2:55 PM, Ron wrote: And it pathologically loads even when there's just a PK on the numeric field? Yea, that works fine. Drop all indexes, load data, recreate indexes? No, I use the incremental load as it gives a much better

Re: Query not producing expected result

On 5/1/19 11:39 AM, Julien Rouhaud wrote: On Wed, May 1, 2019 at 6:27 PM Chuck Martin wrote: I need help figuring out why a query is not returning the records I expect it to. I'm searching on a DateTime column (timestamp without time zone - not nullable). The query includes: AND

Re: Postgres for SQL Server users

On 5/6/19 2:47 PM, Igal Sapir wrote: but I want to instill confidence in them that anything they do with SQL Server can be done with Postgres. Right off the top of my head, here are some things you can't (easily and trivially) do in Postgres: - Transparent Data Encryption - Block level full,

Re: PG version recommendation

On 5/7/19 1:52 PM, David Gauthier wrote: Hi: I'm going to be requesting a PG instance supported by an IT team in a large corp.  They will be creating the server as a VM.  We will be loading the DB using scripts (perl/dbi) on linux, possibly using bulk loading techniques if that's required. 

Re: PG version recommendation

No, I'm asking about the application. On 5/7/19 3:51 PM, David Gauthier wrote: >>Home-rolled application, or third party? Are you asking about how they do VMs ? They already provide PG v9.6.7 , so I gather they're not averse to supporting PG DBs. On Tue, May 7, 2019 at 4:05

Re: SQL query

On 4/18/19 11:43 AM, Vikas Sharma wrote: Hi, I have come across a query that a developer wrote to update a few rows in table, the query did update the two desired rows but also updated the rest of the table with the column value as 'false'. Update tableA set col1 = null and col2 in (1,2);

Re: Migrating database(s) from Sybase ASE 15.7 to PostgreSQL 10.6 on Linux

On 5/3/19 6:56 AM, Matthias Apitz wrote: Hello, We're investigating the migration of our LMS (Library Managment System) from Sybase ASE 15.7 to PostgreSQL 10.6. The used database in field have around 400 columns, some of them are also containing BLOB (bytea) data. The DB size vary upto 20

Re: Starting Postgres when there is no disk space

To get the cluster up and running, you only need to move a GB or two. On 5/1/19 9:24 PM, Igal Sapir wrote: Thank you both.  The symlink sounds like a very good idea. My other disk is 100GB and the database is already 130GB so moving the whole thing will require provisioning that will take more

Re: Optimize pg_dump schema-only

On 4/28/19 3:21 PM, senor wrote: Hi All, I'm looking for advice for optimizing the pg_dump portion of "pg_upgrade --link". Since this schema only dump can't take advantage of parallel processing with jobs I'm looking for any preparation or configuration settings that can improve speed. 9.2 to

Re: Import Database

On 5/5/19 12:20 PM, Andreas Kretschmer wrote: Am 05.05.19 um 18:47 schrieb Sathish Kumar: Is there a way to speed up the importing process by tweaking Postgresql config like maintenance_workmem, work_mem, shared_buffers etc., sure, take the dump in custom-format and use pg_restore with -j

Re: Postgres Database Hacked

On 5/8/19 5:42 AM, Prashant Hunnure wrote: Dear Team, I am working on postgres database version 9.3 is the part of opengeo suite and now my running database become hacked by someone. In the current situation I'm able to view my database under Pgadmin III but unable to view the tables,

Re: Vacuum and freeing dead rows

On 7/5/19 3:16 AM, Simon T wrote: Hi, I have a very heavily updated table in a Postgres 9.6.10 database with lots of disk bloat. Every row is updated about once a minute, and little to no inserts. Approx 18k rows total. The table has bloated from ~1700 KB to about 6 GB over a few weeks time.

Re: pg_dump and search_path

On 7/9/19 2:22 AM, Laurenz Albe wrote: On Mon, 2019-07-08 at 23:54 -0700, Igal @ Lucee.org wrote: I have a custom search_path: # show search_path; search_path -- "staging, transient, pg_catalog" (1 row) I ran `pg_dump --schema-only` and the only

Re: Statistics tables not being updated anymore

On 7/1/19 1:48 PM, Tom Lane wrote: Ron writes: Statistics views like pg_stat_*_tables, pg_stat_*_indexes, pg_statio_*_tables and pg_statio_*_indexes aren't being updated anymore. Specifically, all counter fields are 0, and date fields are blank. Does anything show up in the postmaster log

Statistics tables not being updated anymore

Hi. v9.6.9 Statistics views like pg_stat_*_tables, pg_stat_*_indexes, pg_statio_*_tables and pg_statio_*_indexes aren't being updated anymore. Specifically, all counter fields are 0, and date fields are blank. The first thing I checked was postgresql.conf (but it hasn't been modified since

Re: Measuring the Query Optimizer Effect: Turning off the QO?

On 7/7/19 6:49 PM, Tom Mercha wrote: On 08/07/2019 01:46, Rob Sargent wrote: On Jul 7, 2019, at 5:22 PM, Tom Mercha wrote: Hi All As we know, a query goes through number of stages before it is executed. One of these stages is query optimization (QO). There are various parameters to try and

Re: how to execute pgsql2shp exe in sql

On 7/14/19 10:54 PM, sunpeng wrote: Could I use the following in psql or in a sql : "D:\PostgreSQL\9.6\bin\pgsql2shp " This *should* work, though you might have to fiddle with the quotes: yourdb=> \! "D:\PostgreSQL\9.6\bin\pgsql2shp " -- Angular momentum makes the world go 'round.

Re: Backup and Restore (pg_dump & pg_restore)

On 4/21/19 3:58 PM, Adrian Klaver wrote: On 4/21/19 1:42 PM, Ron wrote: On 4/21/19 1:46 PM, Adrian Klaver wrote: On 4/21/19 9:35 AM, Daulat Ram wrote: Hello Team, We are getting below error while migrating pg_dump from Postgresql 9.6 to Postgresql 11.2 via pg_restore in docker environment

Re: Backup and Restore (pg_dump & pg_restore)

On 4/21/19 1:46 PM, Adrian Klaver wrote: On 4/21/19 9:35 AM, Daulat Ram wrote: Hello Team, We are getting below error while migrating pg_dump from Postgresql 9.6 to Postgresql 11.2 via pg_restore in docker environment. 90d4c9f363c8:~$ pg_restore -d kbcn "/var/lib/kbcn_backup19" pg_restore:

Re: how to add more than 1600 columns in a table?

On 4/24/19 5:55 PM, Alvaro Herrera wrote: On 2019-Apr-24, pabloa98 wrote: Regarding to (2), We are good by adding a patch and recompile a patched version for our server databases. But we are open on helping to add thousands of columns support as a compile-time parameter if there are other

Re: how to add more than 1600 columns in a table?

On 4/24/19 3:17 PM, pabloa98 wrote: Hello Sadly today we hit the 1600 columns limit of Postgresql 11. How could we add more columns? Note: Tables are OK. We truly have 2400 columns now. Each column represents a value in a matrix. We have millions of rows so I would prefer not to transpose

Re: how to add more than 1600 columns in a table?

On 4/24/19 3:22 PM, Adrian Klaver wrote: On 4/24/19 1:17 PM, pabloa98 wrote: Hello Sadly today we hit the 1600 columns limit of Postgresql 11. How could we add more columns? Note: Tables are OK. We truly have 2400 columns now. Each column represents a value in a matrix. Not sure how hit

Re: Statistics tables not being updated anymore

On 7/1/19 1:48 PM, Tom Lane wrote: Ron writes: Statistics views like pg_stat_*_tables, pg_stat_*_indexes, pg_statio_*_tables and pg_statio_*_indexes aren't being updated anymore. Specifically, all counter fields are 0, and date fields are blank. Does anything show up in the postmaster log

Re: Statistics tables not being updated anymore

On 7/1/19 1:48 PM, Adrian Klaver wrote: On 7/1/19 11:24 AM, Ron wrote: On 7/1/19 1:07 PM, Adrian Klaver wrote: On 7/1/19 10:27 AM, Ron wrote: Hi. v9.6.9 Statistics views like pg_stat_*_tables, pg_stat_*_indexes, pg_statio_*_tables and pg_statio_*_indexes aren't being updated anymore

Re: Statistics tables not being updated anymore

On 7/1/19 1:07 PM, Adrian Klaver wrote: On 7/1/19 10:27 AM, Ron wrote: Hi. v9.6.9 Statistics views like pg_stat_*_tables, pg_stat_*_indexes, pg_statio_*_tables and pg_statio_*_indexes aren't being updated anymore. Specifically, all counter fields are 0, and date fields are blank

Re: Statistics tables not being updated anymore

On 7/1/19 2:43 PM, Adrian Klaver wrote: On 7/1/19 12:30 PM, Ron wrote: On 7/1/19 1:48 PM, Tom Lane wrote: Ron writes: Statistics views like pg_stat_*_tables, pg_stat_*_indexes, pg_statio_*_tables and pg_statio_*_indexes aren't being updated anymore. Specifically, all counter fields are 0

Re: Statistics tables not being updated anymore

On 7/1/19 5:20 PM, Adrian Klaver wrote: On 7/1/19 1:38 PM, Ron wrote: On 7/1/19 2:43 PM, Adrian Klaver wrote: On 7/1/19 12:30 PM, Ron wrote: On 7/1/19 1:48 PM, Tom Lane wrote: Ron writes: Statistics views like pg_stat_*_tables, pg_stat_*_indexes, pg_statio_*_tables and pg_statio_*_indexes

Re: Probably a newbie question

On 8/10/19 1:57 PM, stan wrote: Sorry, I got the list address wrong the first time, and when I corected it, I forget to fix the subject line. I apologize for asking, what I suspect will turn out to be a newbie question, but I have managed to get myself quite confused on this. I am defining a

Re: postmaster utilization

On 8/19/19 5:40 AM, Shiwangini Shishulkar wrote: Hi, We have scheduled postgres full backup on centos 7 machine. DB size is around 66 GB. We observed while backup is running, postmaster CPU % reaches to 90 - 100%,which results very strange behavior: that we are not able to perform any DDL

Re: Importing from CSV, auto creating table?

On 8/21/19 4:15 PM, stan wrote: I have a situation where we need to import data, as an interim measure, from spreadsheets. I have read up on \copy and COPY, but I do not see that either of these can use the header from a CSV file to define a new table. Am I missing something? Data types. 

Re: Work hours?

On 8/27/19 5:27 PM, stan wrote: I am just starting to explore the power of PostgreSQL's time and date functionality. I must say they seem very powerful. I need to write a function that, given a month, and a year as input returns the "work hours" in that month. In other words something like 8 *

Re: Work hours?

On 8/27/19 10:22 PM, Christopher Browne wrote: On Tue, Aug 27, 2019, 6:27 PM stan > wrote: I am just starting to explore the power of PostgreSQL's time and date functionality. I must say they seem very powerful. I need to write a function that, given a

Re: killing vacuum analyze process

Those are all idle.  I've got a cron job to kill all idle processes more than 60 (or 30, I don't remember) minutes old. On 9/3/19 6:29 PM, Julie Nishimura wrote: Thank you Tom. I can see bunch of old processes running ROLLBACK... Should I kill them or they only way to clear those is to restart

Re: database files are incompatible with server

On 8/22/19 8:49 PM, Adrian Klaver wrote: On 8/22/19 6:29 PM, Ron wrote: On 8/22/19 7:08 PM, Adrian Klaver wrote: On 8/22/19 4:52 PM, Igal @ Lucee.org wrote: I have a data directory that was created by Postgres 12 (I thought beta 3 but now am not sure anymore) running in Docker. I have

Re: database files are incompatible with server

On 8/22/19 7:08 PM, Adrian Klaver wrote: On 8/22/19 4:52 PM, Igal @ Lucee.org wrote: I have a data directory that was created by Postgres 12 (I thought beta 3 but now am not sure anymore) running in Docker. I have installed Postgres 12b3 as a Systemd service and am trying to set the cluster

Re: Question from someone who is not trained in computer sciences

On 9/5/19 4:00 PM, Judith Lacoste wrote: Hi, I think PostgreSQL is the solution for my needs, but I am not a programmer/coder.  If I can confirm PostgreSQL does what I need, I will have to hire someone to assist, I am willing to give the effort to learn myself but it may be difficult, my

Re: Web GUI for PG table ?

On 9/12/19 9:08 AM, David Gauthier wrote: Hi: We're considering replacing a windows AccessDB based system with PG.  Access was chosen because of it's GUI to its tables (looks and behaves like a SS). But performance can be volatile given the fact that the AccessDB front-ends and back-end are

Re: Referncing a calculated column in a select?

On 9/12/19 2:23 PM, stan wrote: I am creating some views, that have columns with fairly complex calculations in them. The I want to do further calculations using the result of this calculation. Right now, I am just duplicating the first calculation in the select fro the 2nd calculated column.

Re: backing up the data from a single table?

On 9/13/19 9:13 AM, stan wrote: My development methodology is to create scripts that init the db, and load test data, as I make changes. Now, I am starting to move toward a test instance with real data. The end user has provided "real" test data, n spreadsheets. I have the inputing of data from

Re: PG SQL and LIKE clause

On 9/13/19 9:14 AM, Adrian Klaver wrote: On 9/12/19 11:11 PM, Ron wrote: On 9/13/19 12:28 AM, Matthias Apitz wrote: Hello, We're porting a huge Library Management System, written using all kind of languages one can think of (C, C++, ESQL/C, Perl, Java, ...) on Linux from the DBS Sybase to PG

Re: No primary key table

On 9/13/19 10:34 AM, Ertan Küçükoglu wrote: Hello, We are using PostgreSQL 10.0 on a Windows VM. There is one database in that server. There are several tables that will be used for data warehouse purposes. There are daily inserts and relatively heavy bulk (whole month data at once) reads

Re: Cascade Trigger Not Firing

On 9/14/19 9:54 AM, Tom Lane wrote: [snip The only mention of this feature in 38.1 "Overview of Trigger Behavior" is UPDATE triggers*can* moreover be set to fire only if certain columns are mentioned in the SET clause of the UPDATE statement. which seems to me to be plenty specific

pgbackrest restore to new location?

Hi, In order to do this, do I create a new stanza in config file which has pg1-path point to the new/empty directory structure while still pointing to the existing backup directory, and restore that stanza? Thanks -- Angular momentum makes the world go 'round.

Re: pgbackrest restore to new location?

On 9/17/19 4:29 AM, Luca Ferrari wrote: On Tue, Sep 17, 2019 at 3:09 AM Ron wrote: Hi, In order to do this, do I create a new stanza in config file which has pg1-path point to the new/empty directory structure while still pointing to the existing backup directory, and restore that stanza

Re: install pgcrypto module to existing postgreSQL

IOW, you installed it from source instead of a package. On 9/17/19 4:18 PM, Pavan Kumar wrote: Hello Adrian, i have used configure command install postgres   $ ./configure --prefix=/pgbin/11.2 --with-segsize=32 --with-pgport=5432 once configure is done, used make and make install to install

Re: PostgreSQL License

Charging for *installing* PostgreSQL is not the same as charging for PostgreSQL. Bottom line: you charge for *services**you provide* not for software that other people provide. On 9/18/19 5:11 PM, Ashkar Dev wrote: Thanks, but is it legal to charge for installing PostgreSQL? as you said:

Re: pgbackrest restore to new location?

On 9/17/19 6:48 AM, David Steele wrote: On 9/17/19 7:23 AM, Luca Ferrari wrote: On Tue, Sep 17, 2019 at 12:00 PM Ron wrote: The real problem is that after doing that, "pg_ctl start -D /path/to/new/data" fails with "PANIC: could not locate a valid checkpoint record". Soun

Re: PG SQL and LIKE clause

On 9/13/19 12:28 AM, Matthias Apitz wrote: Hello, We're porting a huge Library Management System, written using all kind of languages one can think of (C, C++, ESQL/C, Perl, Java, ...) on Linux from the DBS Sybase to PG, millions of lines of code, which works also with DBS Oracle and in the

Re: PostgreSQL License

On 9/18/19 11:43 PM, Ken Tanzer wrote: On Wed, Sep 18, 2019 at 6:35 PM Ron <mailto:ronljohnso...@gmail.com>> wrote: On 9/18/19 8:26 PM, Ken Tanzer wrote: On Wed, Sep 18, 2019 at 5:55 PM Ron mailto:ronljohnso...@gmail.com>> wrote: On 9/18/19 6:03 PM, K

Re: How do I create a Backup Operator account ?

On 7/30/19 12:58 AM, Luca Ferrari wrote: On Tue, Jul 30, 2019 at 2:50 AM Marcos Aurelio Nobre wrote: I was wondering if it was possible to configure the pgAdmin4 menus to be available for a particular login, only Backup & Restore items. But I'm not sure how to associate a bank login account

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