Re: Compression In Postgresql 9.6

On 8/5/19 7:31 AM, Kenneth Marshall wrote: On Mon, Aug 05, 2019 at 12:00:14PM +0530, Shital A wrote: Hello, Need inputs on below: We are working on a setting up a new highly transactional (tps 100k) OLTP system for payments using blockchain and postgresql 9.6 as DB on Rhel 7.6. Postgres versio

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 vi

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 and

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.  Sure

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 t

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: 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 mon

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: 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 spec

Re: How to reformat output of "age()" function

On 9/11/19 10:38 AM, David Gauthier wrote: How can I change the default output of the "age" function to be, for example, in minutes? E.g. dvdb=> select age('2019-09-11 09:00:00','2019-09-09 11:00:00');       age  1 day 22:00:00 (1 row) I want the equivalent of that time delta

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 a

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. The

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 past

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

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 at

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 e

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? No

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: 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 p

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:

pgbackrest - question about restoring cluster to a new cluster on same server

Hi, (Thanks, Stephen, for helping with my earlier problem.) Scenario: there's data corruption on production server, so we need to do a PITR restore from "a few days ago" of the cluster holding the prod databases to a second cluster on that same VM in order to try and find the missing data and

Re: PostgreSQL License

On 9/18/19 6:03 PM, Ken Tanzer wrote: On Wed, Sep 18, 2019 at 3:20 PM Ron <mailto:ronljohnso...@gmail.com>> wrote: Charging for *installing* PostgreSQL is not the same as charging for PostgreSQL. Bottom line: you charge for *services**you provide* not for software t

Re: PostgreSQL License

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, Ken Tanzer wrote: On Wed, Sep 18, 2019 at 3:20 PM Ron mailto:ronljohnso...@gmail.com>> wrote: Charging for *installing* Po

Re: pgbackrest - question about restoring cluster to a new cluster on same server

On 9/18/19 8:31 PM, David Steele wrote: On 9/18/19 6:59 PM, Ron wrote: Scenario: there's data corruption on production server, so we need to do a PITR restore from "a few days ago" of the cluster holding the prod databases to a second cluster on that same VM in order to try and f

Re: pgbackrest - question about restoring cluster to a new cluster on same server

On 9/18/19 8:58 PM, David Steele wrote: On 9/18/19 9:40 PM, Ron wrote: I'm concerned with one pgbackrest process stepping over another one and the restore (or the "pg_ctl start" recovery phase) accidentally corrupting the production database by writing WAL files to the original

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: pgbackrest - question about restoring cluster to a new cluster on same server

On 9/19/19 9:17 AM, Stephen Frost wrote: [snip] Ah, but you are talking about a cluster promotion, though you don't realize it. Any time there is a "at some point, I was to stop replaying WAL and start accepting new changes", there's a timeline switch and notionally a promotion. The point of t

Re: is it safe to drop 25 tb schema with cascade option?

On 9/19/19 4:55 PM, Tom Lane wrote: Adrian Klaver writes: So this is the part I need some clarification on. If you start vacuuming the tables that are setting the min then that should buy you some time? Yes, if there are some small tables that have relfrozenxid even further back than the big o

Re: unable to drop index because it does not exists

On 9/23/19 6:39 AM, Luca Ferrari wrote: Hi, running 11.5 I've got a partitioned table where I want to destroy an index (on a column that has nothing to do with the partition): respidb=# \d+ respi.root Column|Type | --+-+-

Re: Upgrading old server

On 9/25/19 9:29 AM, Christoph Berg wrote: Re: Ekaterina Amez 2019-09-25 <8818b028-bd2d-412e-d4e3-e29c49ffe...@zunibal.com> We've decided to upgrade our PostgreSQL production servers. First task is remove an old v7.14 version. It was supposed to be upgraded to a v8.4 server. The server was instal

Re: Redis 16 times faster than Postgres?

On 9/29/19 4:42 PM, Colin 't Hart wrote: Hi, Can someone take a look at this blog post? https://www.peterbe.com/plog/redis-vs-postgres-blob-of-json Can Redis really be 16 times faster than Postgres? Surely Postgres can get closer to the raw speed of the hardware than 1 order of magnitude? Re

Re: Redis 16 times faster than Postgres?

On 9/29/19 7:01 PM, Morris de Oryx wrote: Sigh. I despair of "16x faster" and "20x faster" headlines that ignore the raw numbers. *The worst numbers in there are far below the threshold of user perception*. Unless these results are compounded by running in a loop, they are meaningless. Not imme

Re: Redis 16 times faster than Postgres?

On 9/29/19 8:09 PM, Steve Litt wrote: On Mon, 30 Sep 2019 07:46:14 +1000 Nathan Woodrow wrote: Redis is a in memory database so I would except it to be always much faster.. Is there a way to have Redis periodically update an on-disk backup? That would be great, but otherwise you're at the mer

Re: Drop a primary

On 10/2/19 1:48 PM, Martin Mueller wrote: I created a primary key with the following commands Add id serial Add primary key (id) I cannot figure out from the documentation how to drop that column. Drop it just like you added it: test=# alter table foobar add id serial; ALTER TABLE test=#

Re: Declarative Range Partitioning Postgres 11

On 10/7/19 6:17 PM, Michael Lewis wrote: No, what you want is not possible and probably won't ever be I would expect. Sure it is.  Maybe not the (weird) way that Postgres does partitioning, but the legacy RDBMS that I still occasionally maintain has for at least 25 years had partition key ind

Re: Declarative Range Partitioning Postgres 11

On 10/8/19 12:33 PM, Michael Lewis wrote: On Tue, Oct 8, 2019 at 8:00 AM Shatamjeev Dewan > wrote: Hi Michael, In this case , I always need to include partition key(date)  in primary key ( if I have a primary key defined on non partition key column e.g i

Re: day interval

Date subtraction returns the integer data type; timestamp subtraction returns the interval datatype. postgres@haggis:~$ psql test psql (9.6.15) Type "help" for help. test=# select date('20191001') - date('20190923');  ?column? --     8 (1 row) test=# select date('2019-10-01') - dat

Re: Securing records using linux grou permissions

It can be done, but you'd need much tighter integration with the OS, which would probably lock you in to only one platform ("Unix", not just Linux). On 10/15/19 12:10 PM, David Gauthier wrote: Ok, thanks. I was hoping there was a way to integrate the user/permissions/groups in linux with the P

Re: CVE-2018-1058

On 10/16/19 2:40 PM, Adrian Klaver wrote: On 10/14/19 3:27 PM, Lizeth Solis Aramayo wrote: Good afternoon, I am working with postgresql 9.6.15 and I need to restore in a 9.6.5 version,  I got an error, and  I found this page to install a patch What commands did you use to dump the 9.6.15 ver

Re: drop database

On 10/17/19 3:44 PM, Julie Nishimura wrote: Guys, can anybody reply if they drop any postgresql database larger than 1 tb and how long did it take? A lot has to do with how quickly the underlying file system can delete files. To be honest, though... *does it really matter* how long it takes? 

Re: Sv: drop database

On 10/17/19 3:58 PM, Andreas Joseph Krogh wrote: På torsdag 17. oktober 2019 kl. 22:44:15, skrev Julie Nishimura mailto:juliez...@hotmail.com>>: Guys, can anybody reply if they drop any postgresql database larger than 1 tb and how long did it take? Thanks About 280ms: andreak@[loca

Re: drop database

There are other databases in the cluster. On 10/17/19 5:12 PM, Andrew Kerber wrote: If you are decommissioning the database, why not just rm -rf the whole system? On Thu, Oct 17, 2019 at 4:31 PM Michael Lewis > wrote: Your plan to loop over tables and truncate t

Re: Create role like role

On 10/18/19 5:08 AM, Sonam Sharma wrote: I have created one role reader and granted usage on schema and select all tables role. I have created one more user and have Grant reader to sonam. But still user Sonam is not able to read the tables.. Anything I am missing please let me know .. You

Re: Primary key definition?

On 10/22/19 2:47 PM, stan wrote: I started doing the following to define my primary keys long ago and in a universe far away: CREATE TABLE employee ( employee_key integer DEFAULT nextval('employee_key_serial') PRIMARY KEY , WEE ran into a scenario, after a total db restore on a proje

Re: date function bug

On 10/23/19 9:22 AM, Abraham, Danny wrote: Hi, The function "to_date" does not fail illegal values. Is this a known bug? What is the recommended type checking? ctrlmdb=> select to_date('2018100X','MMDD'); to_date 2018-10-01 (1 row) psql (9.6.15) Type "help" for help. p

Re: date function bug

On 10/23/19 9:32 AM, Ravi Krishna wrote: > postgres=# select to_date('2018150X','MMDD');   > to_date > 2019-03-03 > postgres=# select to_date('20181501','MMDD'); >  to_date >   > 2019-03-03 is this a cut-n-paste mistake? Nope. Here's the screen print: http

Re: Is this a bug ?

On 10/23/19 10:42 AM, Ravi Krishna wrote: We noticed this bug in Redshift. It then occurred to me that this may very well be a PG bug since Redshift is based on PG. Reproduced it in Version 11.5 create table bugtest (fld1 char(1)) ; insert into bugtest values('a'); insert into bugtest values('

Re: Is this a bug ?

On 10/23/19 10:51 AM, Geoff Winkless wrote: On Wed, 23 Oct 2019 at 16:42, Ravi Krishna wrote: select count(*) from bugtest where fld1 in ('a','b','c' 'd','e'); Note the missing comma after 'c'. PG takes it a syntactically right SQL and gives 3 as

Re: Is this a bug ?

On 10/23/19 11:03 AM, Geoff Winkless wrote: On Wed, 23 Oct 2019 at 16:55, Ron wrote: Then -- since the 'e' is separated from 'd' by a comma, the result should be "4", not "3". No doubt: it's a bug, no matter what the Pg devs say. I'm confu

Re: Is this a bug ?

On 10/23/19 11:00 AM, Tom Lane wrote: Ron writes: On 10/23/19 10:51 AM, Geoff Winkless wrote: Two string constants that are only separated by whitespace with at least one newline are concatenated and effectively treated as if the string had been written as one constant. Then -- since the &#

Re: Is this a bug ?

On 10/23/19 11:20 AM, Geoff Winkless wrote: On Wed, 23 Oct 2019 at 17:09, Ron wrote: As much as I hate to say it, MSFT was right to ignore this bug in the standard. Standards are standards for a reason. It is almost never correct to deliberately ignore them. If you don't like them,

Re: Is this a bug ?

On 10/23/19 11:27 AM, Geoff Winkless wrote: On Wed, 23 Oct 2019 at 17:20, Geoff Winkless wrote: For what it's worth, I can see a value to having SELECT 'this is quite a long string' 'which I've joined together ' 'across multiple lines'; although the advantage o

Re: Is this a bug ?

On 10/23/19 11:20 AM, Geoff Winkless wrote: On Wed, 23 Oct 2019 at 17:09, Ron wrote: As much as I hate to say it, MSFT was right to ignore this bug in the standard. Standards are standards for a reason. It is almost never correct to deliberately ignore them. If you don't like them,

Re: SQL pretty pritner?

But does it reformat the text? On 10/28/19 8:00 AM, Basques, Bob (CI-StPaul) wrote: All, Take a look at the VI(m) editor. There is a Syntax mode for highlighting different file types, as well as tools for exporting the highlighted text to HTML. I have yet to find a file type that it doesn’t

Query which shows FK child columns?

v9.6.16 I have a query which shows the parents and children in FK relations, along with the parent column name, but can't seem to find the child column names. Is there a way to find the child column names without having to dig into pg_constraint? Thanks test=# select ccu.table_schema||'.'|

Re: Function performance degrades after repeated execution

On 11/16/19 8:22 AM, Dave Roberge wrote: Hi, We've been troubleshooting a slow running function in our postgres database. I've been able to boil it down to the simplest function possible. It looks like this: FOR rec IN select 1 as matchval FROM table1 t1, table2 t2 join table3 t3 on t3.col

Re: Isolation of multiple databse instances provided by a single postgres server

On 11/20/19 4:03 PM, stan wrote: I am working on a fairly small application to use for managing a companies business. I have a "production" instance hosted by one of the cloud providers, and 2 other instances. This is fairly new to me. In the past, I have created applications by keeping a set of

Re: Isolation of multiple databse instances provided by a single postgres server

On 11/21/19 5:55 AM, stan wrote: On Wed, Nov 20, 2019 at 04:24:40PM -0600, Ron wrote: On 11/20/19 4:03 PM, stan wrote: I am working on a fairly small application to use for managing a companies business. I have a "production" instance hosted by one of the cloud providers, a

Re: Isolation of multiple databse instances provided by a single postgres server

On 11/21/19 8:42 AM, stan wrote: On Thu, Nov 21, 2019 at 08:18:21AM -0600, Ron wrote: [snip] Yes, but ... schema in Postgres are /different/ from Oracle schema.?? In Postgres, the CREATE SCHEMA command creates a schema, whereas CREATE USER creates a schema in Oracle. I am still struggling

Re: Tablespace setup issue

On 11/21/19 8:52 AM, Laurenz Albe wrote: On Thu, 2019-11-21 at 09:48 -0500, Sébastien Bihorel wrote: Now, I would like to assign a particular disk location for the tablespace used by this database but I am getting all kinds of errors apparently linked to folder permissions. Don't create tables

Re: Tablespace setup issue

On 11/21/19 8:59 AM, Laurenz Albe wrote: On Thu, 2019-11-21 at 08:54 -0600, Ron wrote: Don't create tablespaces. Stick with the default tablespace. Why? Because you won't need them. Tablespaces have a limited number of use cases: - Distribute I/O across several devices (you can d

Re: Client Computers

On 11/23/19 4:25 AM, Jason L. Amerson wrote: Do my Windows 10 computers that will be clients, need PostgreSQL installed to connect remotely to my server or is pgAdmin or some other client all I need? They only need pgAdmin installed if they're going to actually run pgAdmin. If they're "ju

Re: Trouble incrementing a column

On 11/23/19 3:28 PM, Blake McBride wrote: Greetings, I am using PostgreSQL 10.10.  I am having trouble incrementing a column for reasons I can't see.  It's probably some basic SQL thing.  Your help is appreciated. create table my_table (     listid char(36) not null,     seq smallint not nul

ROLE VALID UNTIL timezone?

Hi, In 9.6, does it default to UTC, the postgresql.conf timezone value (US/Eastern) value or to local system time? -- Angular momentum makes the world go 'round.

Re: MS Access Frontend

On 12/1/19 10:46 AM, Michael Nolan wrote: On Sun, Dec 1, 2019 at 8:09 AM Martin Gainty > wrote: that said I think MS missed the boat on 2-phase-commits Microsoft has never really embraced the concept of a multi-user database environment. You haven't use

Re: upgrade and migrate

On 12/3/19 10:48 PM, Michael Paquier wrote: On Tue, Dec 03, 2019 at 10:32:22PM +, Julie Nishimura wrote: Hello, what is the best way to migrate from PostgreSQL 8.3.11 on x86_64-redhat-linux-gnu to PostgreSQL 9.6.16 on x86_64-pc-linux-gnu server, with minimal downtime? The caveat is the sourc

Re: Date created for tables

On 12/5/19 1:01 PM, Tom Lane wrote: Chloe Dives writes: Having moved to PostgreSQL from Oracle a few years ago I have been generally very impressed by Postgres, but there are a few things that I still miss. One of those is being able to see the created and last modified dates for database

Re: Date created for tables

On 12/5/19 7:40 PM, Michael Paquier wrote: On Thu, Dec 05, 2019 at 07:12:22PM -0600, Ron wrote: On 12/5/19 1:01 PM, Tom Lane wrote: It's been considered, and rejected, many times. Aside from the overhead involved, there are too many different ideas of what such dates ought to mean (e.g.,

Re: Fast, stable, portable hash function producing 4-byte or 8-byte values?

On 12/10/19 3:11 PM, Erwin Brandstetter wrote: I am looking for stable hash functions producing 8-byte or 4-byte hashes from long text values in Postgres 10 or later. There is md5(), the result of which can be cast to uuid. This reliably produces practically unique, stable 16-byte values. I ha

Re: Is there any tool that provides Physical Backup plus PITR for a single database ( Not the whole PG instance ) ?

On 12/15/19 10:32 AM, Adrian Klaver wrote: On 12/15/19 6:33 AM, Abraham, Danny wrote: I assume that this magic does not exist. Am I right ? Take a look at: https://pgbackrest.org/user-guide.html#restore/option-db-include and see it that meets your needs. I have never actually done it so I c

Re: Fast, stable, portable hash function producing 4-byte or 8-byte values?

On 12/15/19 3:59 PM, George Neuner wrote: On Tue, 10 Dec 2019 18:00:02 -0600, Ron wrote: On 12/10/19 3:11 PM, Erwin Brandstetter wrote: I am looking for stable hash functions producing 8-byte or 4-byte hashes from long text values in Postgres 10 or later. There is md5(), the result of which

Re: Experiencing error during restore - found unexpected block ID (0)

It's typically recommended that you use the pg_dump of the same version as the pg_restore.  In your case, the v12 pg_dump *will* successfully read from a 10.1 database. On 12/19/19 9:24 AM, Sar wrote: for pg_dump it is: PostgreSQL 10.1, compiled by Visual C++ build 1800, 64-bit for pg_restore

Re: Semi-unable to add new records to table--primary key needed?

On 12/20/19 8:19 PM, Boylan, Ross wrote: I have a table that seems to act for some purposes as if I can't add new records to it. I would like to understand why that is and fix it. The initial problem was that an MS-Access application using an ODBC driver (driver and database 64 bit PG 12.0) f

Re: Semi-unable to add new records to table--primary key needed?

On 12/20/19 11:02 PM, Adrian Klaver wrote: On 12/20/19 6:28 PM, Ron wrote: The lack of PK should make insertions *more* forgiving.  (It really should have a PK, but that's irrelevant to this problem.) Actually it is the problem: https://www.pgadmin.org/docs/pgadmin4/4.16/editgrid.html

Re: Date created for tables

On 12/23/19 7:01 PM, Bruce Momjian wrote: On Thu, Dec 5, 2019 at 05:10:20PM +, Chloe Dives wrote: Having moved to PostgreSQL from Oracle a few years ago I have been generally very impressed by Postgres, but there are a few things that I still miss. One of those is being able to see the crea

Re: Date created for tables

On 12/24/19 10:39 AM, Adrian Klaver wrote: On 12/23/19 6:14 PM, Ron wrote: On 12/23/19 7:01 PM, Bruce Momjian wrote: On Thu, Dec  5, 2019 at 05:10:20PM +, Chloe Dives wrote: Having moved to PostgreSQL from Oracle a few years ago I have been generally very impressed by Postgres, but there

Re: Date created for tables

On 12/24/19 12:14 PM, Adrian Klaver wrote: On 12/24/19 8:44 AM, Ron wrote: On 12/24/19 10:39 AM, Adrian Klaver wrote: On 12/23/19 6:14 PM, Ron wrote: On 12/23/19 7:01 PM, Bruce Momjian wrote: Is this something that has been considered for implementation? I wrote a blog about this: https

Re: Date created for tables

On 12/24/19 1:14 PM, Rob Sargent wrote: If there's not enough time and motivation for the developers to implement CREATED_ON and LAST_ALTERED in pg_class, then you should have said that in the first place. We're adults; we understand that OSS projects have limited resources, and won't go off

Re: Date created for tables

On 12/24/19 8:58 PM, Rob Sargent wrote: On Dec 24, 2019, at 11:48 AM, Ron wrote:  On 12/24/19 1:14 PM, Rob Sargent wrote: If there's not enough time and motivation for the developers to implement CREATED_ON and LAST_ALTERED in pg_class, then you should have said that in the first

Re: Backup and Restore

On 12/25/19 7:46 AM, Andreas Kretschmer wrote: Am 25.12.19 um 14:34 schrieb Dor Ben Dov: Hi All, What Is the best recommended / used tool for backup and restore that you suggest or work with postgres ? depends on your needs, most of our customers using barman. pgbackrest is also popul

Re: How to reset a server error '25P02 in_failed_sql_transaction'

On 12/31/19 3:40 AM, Guillaume Lelarge wrote: Le mar. 31 déc. 2019 à 06:55, Matthias Apitz > a écrit : Hello, Due to a wrong human input in the GUI of our application our application server, from the point of view of the PostgreSQL server it is the Post

Re: How to reset a server error '25P02 in_failed_sql_transaction'

On 12/31/19 11:29 AM, David G. Johnston wrote: On Tuesday, December 31, 2019, Ron <mailto:ronljohnso...@gmail.com>> wrote: But how do you issue a ROLLBACK to a different pid? You cannot.  At that point you need to start from scratch. pg_terminate_backend(/pid int/) An

Re: postgresql commands(psql,createdb,dropdb) are not working from shell script

Does the Jenkins' $PATH variable have the Postgres binaries' location? On 1/17/20 2:47 AM, ramesh penumalli wrote: Dear Team, I am using postgresql 9.2.12 version and I am facing  an issue while running the executing the commands createdb,dropdb,psql commands in the shell script which is runn

Re: postgresql commands(psql,createdb,dropdb) are not working from shell script

s binaries. On 1/17/20 6:56 AM, Ramesh Penuballi wrote: Dear Ron, Thanks for looking into this query. Could you please let me know how can I check the same. We are able take our production backup  from the  Jenkins server, and the issue is with our uat database server only. Could you please l

Re: postgresql commands(psql,createdb,dropdb) are not working from shell script

Where is JENKINS installed, and where is Postgres installed?  Are they on the same server? On 1/20/20 12:00 AM, Ramesh Penuballi wrote: Hi Ron, I have checked on my Jenkins server.bashrc and. bashprofiles filed of root and Jenkins users but  didn't find anything about postgresql pat

Re: pgbackrest: ERROR: [029]: unable to convert base 10 string '0000000B' to unsigned int

On 1/21/20 1:10 AM, Eric Veldhuyzen wrote: Hi, We are using pgbackrest (2.21) to backup out postgresql (11) clusters. Last night our nightly diff backup gave me the ERROR: unable to convert base 10 string '000B' to unsigned int. I tried if a full backup would fix this, but it didn't. Maybe

Re: Does converting an indexed varchar to text rewrite its index? Docs say so, tests say no.

Since you just built the index, and it's relatively small, maybe all the data is still cached. On 1/23/20 10:55 AM, Mike Lissner wrote: I think the docs say that if you convert a varchar to text, it'll rewrite the index, but my test doesn't seem to indicate that. Is the test or the documentati

Re: How to transfer databases form one server to other

On 1/26/20 7:30 PM, Adrian Klaver wrote: On 1/26/20 2:47 PM, Andrus wrote: Hi! Before you do any of this I would check the Release Notes for the first release of each major release. Prior to version 10 that would be X.X.x where X is a major release. For 10+ that is X.x.  I would also test the

Re: How to transfer databases form one server to other

On 1/26/20 10:44 PM, Andreas Joseph Krogh wrote: På mandag 27. januar 2020 kl. 03:26:59, skrev Ron <mailto:ronljohnso...@gmail.com>>: [..] I ran *uncompressed* pg_dump on multiple TB+ sized databases from v8.4 servers across the LAN using 9.6 binaries on the remote se

Re: Need support on tuning at the time of index creation

On 1/27/20 5:10 AM, Sandip Pradhan wrote: Dear Sir/Madam, One of our ericsson product used backend db as postgresql 9. We are facing following performance issues where we need some support from your side. We are having 10 tables and we are inserting around 150 million to 250 million records on

Re: temporary data after diskspace error

On 1/27/20 10:05 AM, Willy-Bas Loos wrote: Hi, We have a server with postgresql 9.4.12 on ubuntu. There has been a sudden rise in the amount of disk space used by postgresql, causing a diskspace error: 2020-01-22 17:24:37 CET db: ip: us: PANIC:  could not write to file "pg_xlog/xlogtemp.2334

Re: performance of loading CSV data with COPY is 50 times faster than Perl::DBI

On 2/3/20 12:42 PM, Ravi Krishna wrote: "already suffering from a complex of coding in an unreadable language" hearsay and conjecture I was somewhat facetious. But what finished perl was the reputation it earned that it is a write only language. I don't think that reputation it earned is wit

Re: Cases where alter table set type varchar(longer length) still needs table rewrite

On 2/17/20 9:01 AM, Jeremy Finzel wrote: On Mon, Feb 17, 2020 at 8:21 AM Tom Lane > wrote: Jeremy Finzel mailto:finz...@gmail.com>> writes: > I have a table foo with 100 million rows, and a column: >    - id character varying(20) > The following command

Re: How to fix 0xC0000005 exception in Postgres 9.0

On 2/20/20 4:35 PM, Adrian Klaver wrote: On 2/20/20 2:29 PM, Andrus wrote: Hi!  >Then what changes were done recently, in particular ODBC-related. Same psqlODBC driver 09.00.0101 has worked 10 years. Previously I logged into this server long time ago and then it worked. Windows update history sh

Re: How to fix 0xC0000005 exception in Postgres 9.0

On 2/20/20 4:50 PM, Adrian Klaver wrote: On 2/20/20 2:48 PM, Ron wrote: On 2/20/20 4:35 PM, Adrian Klaver wrote: On 2/20/20 2:29 PM, Andrus wrote: Hi!  >Then what changes were done recently, in particular ODBC-related. Same psqlODBC driver 09.00.0101 has worked 10 years. Previously I log

Re: Can we have multiple tablespaces with in a database.

On 2/20/20 11:46 PM, David G. Johnston wrote: Please pick a single list to post to.  Performance seems like the unnecessary one here. On Thu, Feb 20, 2020 at 10:34 PM Daulat Ram > wrote: Can we have multiple tablespaces with in a database in postgres?

Re: How to get error message details from libpq based psqlODBC driver (regression)

On 2/22/20 5:19 PM, Adrian Klaver wrote: On 2/22/20 2:37 PM, Andrus wrote: Hi! I'm looking for a way to fix psqlODBC driver regression. Starting at psqlODBC 09.05.0100 when psqlODBC driver uses libpq for all operations (earlier versions used libpg only for authentication) ODBC client does not

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