Re: Recreating functions after starting the database server.

On 01/31/2018 14:03, Achilleas Mantzios wrote: > On 31/01/2018 14:45, Konrad Witaszczyk wrote: >> Hi, >> >> I'm considering changing my database schema upgrade routines to recreate >> functions and all objects depending on them (e.g. triggers, views) just after >> the database server is started.

Re: Recreating functions after starting the database server.

On 31/01/2018 15:22, Konrad Witaszczyk wrote: On 01/31/2018 14:03, Achilleas Mantzios wrote: On 31/01/2018 14:45, Konrad Witaszczyk wrote: Hi, I'm considering changing my database schema upgrade routines to recreate functions and all objects depending on them (e.g. triggers, views) just after

Re: Recreating functions after starting the database server.

On 01/31/2018 14:32, Achilleas Mantzios wrote: > On 31/01/2018 15:22, Konrad Witaszczyk wrote: >> On 01/31/2018 14:03, Achilleas Mantzios wrote: >>> On 31/01/2018 14:45, Konrad Witaszczyk wrote: Hi, I'm considering changing my database schema upgrade routines to recreate

Re: pgAdmin 4 loading shapefiles

> On 30 Jan 2018, at 12:32, Findlay, Thomas C > wrote: > > Hello, > > How do you load GIS shapefiles into a pgAdmin database, using pgAdmin 4? > > I have done this in pgAdmin 3 using the PostGIS Shapefile loader, but can’t > seem to find this in version 4. In

Re: [solved] Setting up streaming replication problems

On 01/31/18 13:26, Thiemo Kellner wrote: master by pg_basebackup. This lead to the error of unequal identifier error. Maybe I was not reading carefully enough, however, I was not sure Addendum: The error shows up in the standby log. -- +49 (0)1578-772 37 37 +41 (0)78 947 36 21 SIP/iptel.org:

Re: Equivalent shell script of create user and schema in specific postgres db

On Wed, Jan 31, 2018 at 10:27:53PM +0530, Abhra Kar wrote: > Create a user and schema of same name with in ‘abc’ db through linux shell – > > > > Psql steps--- > > > > 1> [/home]# su postgres > > 2> bash-4.1$ psql > > 3> postgres=# \c abc [ set database abc] > > 4> abc=# create user

Re: ERROR: invalid memory alloc request size 1073741824

> That very much depends on where exactly the failure happens - it might > be both (or relying on an assumption that changed over). It's not clear > if it fails during query execution or formatting the output (I seem to > remember there were/are issues with rows containing multiple large bytea >

Re: Bulk Insert/Update Scenario

On 2018-01-04 13:47:49 -0800, Mana M wrote: > I was thinking about dumping everything into TEMP table and using that > as source for INSERT ... ON CONFLICT. However, I was not sure on how > to get thousands of rows from my Python application into TEMP table in > one shot. Or is there any better

Re: postgres for production

How much data do you have? That’s a fundamental thing to know. Martin. From: Azimuddin Mohammed Date: Wednesday, 31 January 2018 at 16:24 To: , Subject: postgres for production Hello, I have a question

Re: postgres for production

Not really with only that information. There's a lot more to running any database in a virtualized environment. Additionally, 8 cores max? Well, how long does a read or a write take? Are these complex SELECTs with multiple joins of millions of rows that return in 30s or 1m? If so, do you have

Please help me understand unlogged tables

If a table is set to unlogged is it inherently non-durable? That, is any crash or unsafe shutdown _must_ result in truncation upon recovery? I can imagine a table that is bulk loaded in a warehousing scenario and then sitting statically could be safe, but maybe the question becomes how could the

Re: A little RULE help?

On Wed, Jan 31, 2018 at 8:39 AM, Steven Winfield < steven.winfi...@cantabcapital.com> wrote: > > Don't use RULEs. > -- > Vik Fearing +33 6 46 75 15 36 <+33%206%2046%2075%2015%2036> > http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support > > > > > > Repeating this, as if I should

Re: A little RULE help?

On 31/01/2018 18:02, David G. Johnston wrote: On Wed, Jan 31, 2018 at 8:39 AM, Steven Winfield >wrote: Don't use RULEs. -- Vik Fearing +33 6 46 75 15 36

Re: postgres for production

On 2018-01-31 10:23:58 -0600, Azimuddin Mohammed wrote: > I have a question for postgres hardware requirement for production > installation. My org want to use Vms with only 8 cores max + 64Gb RAM max. I > have 4 database out of which 1 Db is write extensive 1 db is read extensive > and >

Re: postgres for production

thanks for the reply scott. The reads are pretty quick, we will use pg for reading/storing metadata information only. not complex joins run, and the 4 dbs are of different size , each db around 200 GB max total On Wed, Jan 31, 2018 at 10:28 AM, Scott Whitney wrote: > Not

Issue with WAL logs temporary not replaying

Hi, We've experienced a DB incident related to WAL. The issue is now somewhat resolved, and I'm trying to understand what could have caused the problem to occur in the first place. Below is a full chronicle of an incident we've ran into. At some point we realized almost no new data was coming in

Re: Information on savepoint requirement within transctions

On Tue, Jan 30, 2018 at 1:40 AM, Robert Zenz wrote: > On 30.01.2018 03:07, David G. Johnston wrote: > > ​So, my first pass at this. > > Nice, thank you. > > > + These are of particular use for client software to use when executing > > + user-supplied SQL statements

RE: PostgreSQL Kerberos Authentication

Thank you Peter!, I will check DNS configuration. Regards Jorge -Original Message- From: EXTERNAL:Peter Eisentraut [mailto:peter.eisentr...@2ndquadrant.com] Sent: miércoles, 31 de enero de 2018 01:33 a.m. To: HIRTZ Jorge Alberto TENARIS ;

Re: Information on savepoint requirement within transctions

On 2018-01-29 06:36:41 -0700, David G. Johnston wrote: > On Mon, Jan 29, 2018 at 1:37 AM, Robert Zenz > wrote: > > Documentation, bug report, mailing list discussions, > something like that. In particular I'm interested in the questions: > >  * Why are

Re: Issue with WAL logs temporary not replaying

Hi, unfortunately your message is missing some pretty important information, like for example which OS you're running, what PostgreSQL version are you using (and if you built it on your own or installed from some package repository). Also, you mention replicas. What type of replication are you

Re: Issue with WAL logs temporary not replaying

On 01/31/2018 09:56 AM, Eugene Pirogov wrote: Hi, We've experienced a DB incident related to WAL. The issue is now somewhat resolved, and I'm trying to understand what could have caused the problem to occur in the first place. Below is a full chronicle of an incident we've ran into. At

Re: ERROR: invalid memory alloc request size 1073741824

On 01/31/2018 09:51 PM, Jan Wieck wrote: > > > On Wed, Jan 31, 2018 at 12:32 PM, Stefan Blanke > > wrote: > > > > > I'll bet you it's not that. It's quite unlikely that would fail with > > exactly 1GB request size.

Re: Recreating functions after starting the database server.

> In my case the upgrade routines run migration scripts which modify a > database schema. Besides that I have a bunch of SQL files with the > schema that can be used to initialize a new database. Why not just update the proc's, etc, that depend on the changes? -- Steven Lembark

Re: Please help me understand unlogged tables

On Wed, Jan 31, 2018 at 8:52 AM, Alexander Stoddard < alexander.stodd...@gmail.com> wrote: > If a table is set to unlogged is it inherently non-durable? That, is any > crash or unsafe shutdown _must_ result in truncation upon recovery? > Yes. > I can imagine a table that is bulk loaded in a

Re: Recreating functions after starting the database server.

On Wed, Jan 31, 2018 at 5:45 AM, Konrad Witaszczyk wrote: > Hi, > > I'm considering changing my database schema upgrade routines to recreate > functions and all objects depending on them (e.g. triggers, views) just > after > the database server is started. It would make the

Unexpected ErrorMessage reply to SSLRequest

Hello everybody, I'm one of the maintainers of postgrex [1] - an Elixir client for Postgresql. We implement the wire protocol and connect directly through tcp. We got a bug report indicating we got an unexpected ErrorMessage packet in reply to SSLRequest. The documentation [2] indicates this

Re: Please help me understand unlogged tables

On Wed, Jan 31, 2018 at 10:52:38AM -0600, Alexander Stoddard wrote: > If a table is set to unlogged is it inherently non-durable? That, is any > crash or unsafe shutdown _must_ result in truncation upon recovery? Yes, they are designed like that. Upon recovery all unlogged tables are

Re: Information on savepoint requirement within transctions

On 2018-01-30 08:40:11 +, Robert Zenz wrote: > On 30.01.2018 03:07, David G. Johnston wrote: > > So, my first pass at this. > > Nice, thank you. > > > + These are of particular use for client software to use when executing > > + user-supplied SQL statements and want to provide try/catch

Re: PG Sharding

On Mon, 29 Jan 2018 15:34:18 +0100 Matej wrote: > Hi Everyone. > > We are looking at a rather large fin-tech installation. But as > scalability requirements are high we look at sharding of-course. > > I have looked at many sources for Postgresql sharding, but we are a >

Re: Issue with WAL logs temporary not replaying

Tomas, Indeed, I haven't put enough detail in the original post. That is a fair point, thank you. Let me follow up on each of your comments. unfortunately your message is missing some pretty important information, > like for example which OS you're running, what PostgreSQL version are you >