Re: [GENERAL] streaming replication not working

On Tue, 2013-09-24 at 08:59 -0500, John DeSoi wrote: > On Sep 24, 2013, at 5:48 AM, Albe Laurenz wrote: > > >> Here is what I have on the standby: > >> > >> postgresql.conf > >> > >> hot_standby = on > >> max_wal_senders = 2 > >> wal_level = hot_standby > > > > You should set the same paramete

Re: [GENERAL] excution time for plpgsql function and subfunction

On Fri, 2014-01-10 at 10:10 +0100, Rémi Cura wrote: > Hey List, > kind of a simple question : > > I'm using the postgis_topology extension, > and I'm trying to figure where the slowness comes from when importing data. > > It involves plpgsql function calling other plpgsql functions, insert, > upd

Re: [GENERAL] Filtering queries by IP

On Mon, 2014-01-20 at 10:21 -0300, Leonardo M. Ramé wrote: > Hi, I'm trying to find the cause of slow performance on some screens of > an application. To do that, I would like to be able to log all the > queries made by an specific IP addres, is this possible?. > Not by default, but you can use t

Re: [GENERAL] Extending Session / Logged User info

On Tue, 2012-01-31 at 04:16 -0800, durumdara wrote: > Dear PGSQL Masters! > > I have a complicated question. > > Is there any way to extend the session information (what visible in > pgadmin's "Server Status")? > > I explain what I want to do: > > We used alternative DB in a place and I need to

Re: [GENERAL] Sequence Ids are not updating after COPY operation in PostgreSQL

On Wed, 2012-02-01 at 12:08 +0530, Siva Palanisamy wrote: > Hi there! > > I'm inserting bulk records using COPY statement in PostgreSQL, and is > successful. When I try to insert a record later manually, it throws duplicate > sequence id error. What I realize is, the sequence ids are not getting

Re: [GENERAL] Server not starting problem

On Wed, 2012-02-01 at 11:44 -0200, Pablo Fulco wrote: > Hi all, im very new to postgres, and im having a problem with postgres 8.1. > > The thing is that the server wont start, when I checked the log it said: > > > > Received fast shutdown request > > Aborting any active transaction > > FATA

Re: [GENERAL] Unable to execute \copy from Client Application

On Thu, 2012-02-16 at 00:07 -0800, sujayr06 wrote: > Hello All, > >My application is a C++ APP. > >I'm executing \copy command from the CPP and its as follows > >strPgSqlQuerybuf<<"\\copy hnb_registration FROM > '/root/Sujay/hnbfile.txt' USING DELIMITERS ','";

Re: [GENERAL] Unable to execute \copy from Client Application

On Thu, 2012-02-16 at 01:05 -0800, sujayr06 wrote: > Hello, > >Please find the usage of \copy and the corresponding API. > >strPgSqlQuerybuf<<"\\copy hnb_registration FROM > '/root/Sujay/hnbfile.txt' USING DELIMITERS ','"; > >pPostGresQ

Re: [GENERAL] running multiple versions

Hi, On Fri, 2012-02-17 at 00:11 +0200, Heine Ferreira wrote: > [...] > Is it possible to run more than one instance of Postgresql on Windows? Yes. > Can you run different versions simultaneously? Yes > If so can you run different minor versions or only different major versions? Only major ver

Re: [GENERAL] running multiple versions

On Thu, 2012-02-16 at 15:00 -0800, Adrian Klaver wrote: > On Thursday, February 16, 2012 2:17:33 pm Guillaume Lelarge wrote: > > Hi, > > > > > > If so can you run different minor versions or only different major > > > versions? > > > > Only

Re: [GENERAL] Allowed DML on replicas?

On Thu, 2012-03-01 at 08:24 -0500, François Beausoleil wrote: > Hi! > > I'm getting ready to build a reporting server, one where long-running queries > and backups will be taken from. This new server will be a slave from the > master where all changes are done. Some reports are better expresse

Re: [GENERAL] FDWs, foreign servers and user mappings

On Thu, 2012-03-08 at 10:04 -0500, Joe Abbate wrote: > On 03/08/2012 12:06 AM, Shigeru Hanada wrote: > > I think that makes, and will make sense. Because SQL/MED standard > > mentions about schema for only foreign table in "4.12 SQL-schemas" section. > > > > FYI, pgAdmin III shows them as a tree

Re: [GENERAL] How to erase transaction logs on PostgreSQL

On Thu, 2012-03-08 at 10:18 +, Frank Church wrote: > How do you purge the postgresql transaction log? > You don't. PostgreSQL does it for you. > I am creating a virtual machine image and I want to erase any transaction > logs that got built up during development. What is the way to do that?

Re: [GENERAL] How to erase transaction logs on PostgreSQL

On Fri, 2012-03-09 at 00:09 +, Frank Church wrote: > > > On 8 March 2012 16:23, Guillaume Lelarge > wrote: > On Thu, 2012-03-08 at 10:18 +, Frank Church wrote: > > How do you purge the postgresql transaction log? > > >

Re: [GENERAL] nice'ing the postgres COPY backend process to make pg_dumps run more "softly"

On Sun, 2012-03-18 at 21:06 -0700, Aleksey Tsalolikhin wrote: > Hi. When pg_dump runs, our application becomes inoperative (too > slow). I was going to ask if nice'ing the postgres backend process > that handles the COPY would help but I just realized probably the > pg_dump takes out locks when i

Re: [GENERAL] pg-admin development snapshots

Hi, On Tue, 2012-03-20 at 16:01 -0400, Andy Chambers wrote: [...] > The link[1] for the development snapshots of pg-admin as advertised > here [2] seems to be broken. Are these snapshots hosted somewhere > else these days or are they no longer produced. They are no longer produced. I'll fix the

Re: [GENERAL] pg-admin development snapshots

On Tue, 2012-03-20 at 17:17 -0400, Andy Chambers wrote: > On Tue, Mar 20, 2012 at 4:53 PM, Guillaume Lelarge > wrote: > > Hi, > > > > On Tue, 2012-03-20 at 16:01 -0400, Andy Chambers wrote: > > [...] > >> The link[1] for the development snapshots of pg-adm

Re: [GENERAL] profiling store procedure

On Fri, 2012-03-23 at 00:16 -0700, Geek Matter wrote: > what tool is suitable for profiling store procedure in postgresql? sql server > has sql profiles, how about postgresql? The EDB PL/pgsql profiler tool is probably the easier tool to work with if you want to profile PL/pgsql functions. That's

Re: [GENERAL] postgresql_fdw_handler

On Fri, 2012-03-23 at 12:26 +0100, Bartosz Dmytrak wrote: > Hi everybody, > is there any fdw_handler for postgresql available (pg to pg)? > I saw thread > http://archives.postgresql.org/pgsql-general/2011-09/msg00525.php, need to > know if something has been changed > Not yet. There is one in the

Re: [GENERAL] can these queries be combined into one?

On Sun, 2012-03-25 at 07:16 +, haman...@t-online.de wrote: > > Hi, > > I am currently doing something like > > select ordercode, descr, codes into temp table x from products where ... > Here codes is a bit-mapped field > update x set codes = codes | 512 from othertable t where ordercode = >

Re: [GENERAL] can these queries be combined into one?

On Sun, 2012-03-25 at 08:41 +, haman...@t-online.de wrote: > Guillaume Lelarge worte: > >> > > >> > Hi, > >> > > >> > I am currently doing something like > >> > > >> > select ordercode, descr, codes into t

Re: [GENERAL] create one function to let other user execute vacuum command. got such an error.

On Tue, 2012-03-27 at 18:51 -0700, leaf_yxj wrote: > create one function to let other user execute vacuum command. got such an > error. Please help. Thanks. Regards . Grace > > rrp=> create function vacuum_f ( tablename char(100)) > > Returns char(100) AS $$

Re: [GENERAL] copy syntax

On Wed, 2012-04-04 at 16:01 -0400, Andy Chambers wrote: > dcm_eob=> copy ar_data from '/tmp/ar-data.csv' with header true; > ERROR: syntax error at or near "true" > LINE 1: copy ar_data from '/tmp/ar-data.csv' with header true; > > I can't figure out what's wrong with the syntax above. Is someth

Re: [GENERAL] Value to long for type ....: Columnname missing

On Fri, 2012-04-13 at 17:19 +0400, Sergey Konoplev wrote: > On Thu, Apr 12, 2012 at 12:16 PM, Thomas Guettler wrote: > > How can you report feature request? > > You can submit it here http://www.postgresql.org/support/submitbug/ > No, this allows you to report a bug, not a feature request. --

Re: [GENERAL] The scope of extensions

On Mon, 2012-04-16 at 16:46 +0100, Roger Leigh wrote: > On Mon, Apr 16, 2012 at 10:22:19AM -0500, Merlin Moncure wrote: > > On Mon, Apr 16, 2012 at 10:05 AM, Roger Leigh wrote: > > > The reason for the above is that I'd very much like to be able to > > > version my entire application's schema usin

Re: [GENERAL] The scope of extensions

On Mon, 2012-04-16 at 21:16 +0200, Guillaume Lelarge wrote: > On Mon, 2012-04-16 at 16:46 +0100, Roger Leigh wrote: > > On Mon, Apr 16, 2012 at 10:22:19AM -0500, Merlin Moncure wrote: > > > On Mon, Apr 16, 2012 at 10:05 AM, Roger Leigh > > > wrote: > > > &g

Re: [GENERAL] Why did pg_relation_filepath does not give a correct path ?

On Fri, 2012-04-20 at 11:35 +0200, F. BROUARD / SQLpro wrote: > Hi, > > according to the documentation, the function pg_relation_filepath > "returns the entire file path name (relative to the database cluster's > data directory PGDATA) of the relation" > > When my table are located in the pg_def

Re: [GENERAL] Why did pg_relation_filepath does not give a correct path ?

On Fri, 2012-04-20 at 14:47 +0200, F. BROUARD / SQLpro wrote: > Le 20/04/2012 12:05, Guillaume Lelarge a écrit : > > On Fri, 2012-04-20 at 11:35 +0200, F. BROUARD / SQLpro wrote: > >> Hi, > >> > >> according to the documentation, the function pg_relation_filepat

Re: [GENERAL] Starnge things with big datas...

On Sat, 2012-04-21 at 16:17 +0200, F. BROUARD / SQLpro wrote: > Hi there, > > "PostgreSQL 9.1.2, compiled by Visual C++ build 1500, 64-bit" > catalog version : PG_9.1_201105231 > > --> the table : > > CREATE TABLE T_TEST_TAILLE > (TTT_IDSERIAL NOT NULL PRIMARY KEY, > TTT_DATAFIX

Re: [GENERAL] Starnge things with big datas...

On Sat, 2012-04-21 at 18:01 +0200, F. BROUARD / SQLpro wrote: > Le 21/04/2012 16:54, Guillaume Lelarge a écrit : > > On Sat, 2012-04-21 at 16:17 +0200, F. BROUARD / SQLpro wrote: > >> Hi there, > >> > >> "PostgreSQL 9.1.2, compiled by Visual C++

Re: [GENERAL] how robust are custom dumps?

On Wed, 2012-04-25 at 10:40 +0200, Willy-Bas Loos wrote: > On Wed, Apr 25, 2012 at 9:51 AM, Magnus Hagander wrote: > > > We used to have a bug/lackoffeature in pg_dump at the 2GB boundary as > > well, IIRC, specifically on Win32. Maybe you were hit by that one.. > > Yes, possibly. I didn't even k

Re: [GENERAL] problems after restoring from a pg_basebackup

On Fri, 2012-04-27 at 16:25 -0700, Lonni J Friedman wrote: > Greetings, > I'm running postgresql-9.1.3 on a Linux-x86_64 (Fedora16, if it > matters) system. I noticed the existence of pg_basebackup starting in > 9.1, and figured I'd try it out and see if it would simplify our > backup & management

Re: [GENERAL] Upgrading from 8.4 and 9.0 to 9.1

On Mon, 2012-05-07 at 15:10 -0400, Scott Briggs wrote: > Hi, so I have a master-slave set of database servers that are running > postgres 9.0 using streaming replication and I'd like to migrate them > to 9.1. My question is, can 9.0 do streaming replication to 9.1? No. > If > not, what's the b

Re: [GENERAL] Upgrading from 8.4 and 9.0 to 9.1

On Mon, 2012-05-07 at 15:37 -0400, Scott Briggs wrote: > On Mon, May 7, 2012 at 3:28 PM, Guillaume Lelarge > wrote: > > On Mon, 2012-05-07 at 15:10 -0400, Scott Briggs wrote: > >> Hi, so I have a master-slave set of database servers that are running > >> postgres 9

Re: [GENERAL] lowercase on columnname using view

On Tue, 2012-05-08 at 04:00 -0700, Chrishelring wrote: > Hi all, > > had some help the other day, but now I´m kinda stuck again. :/ > > I have a table ("virksomhedsdata") with the following columns: > > "MI_STYLE" character varying(254), > "MI_PRINX" integer NOT NULL DEFAULT > nextval('rk_ois."

[GENERAL] PostgreSQL Session #4 : Call for Papers

eSQL, Troubleshooting and PostgreSQL support. Dalibo reserves the right to change the date and location of the event if the situation requires it. -- Guillaume Lelarge Directeur technique http://dalibo.com - http://dalibo.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] Pre-built binary packages of PostgreSQL 9.2 Beta

On Wed, 2012-05-16 at 10:28 -0700, Richard Broersma wrote: > I've seen the following statement made several places. > > "Pre-built binary packages of PostgreSQL 9.2 Beta are available from > the project's downloads page for Windows, Mac OS X, Linux, FreeBSD and > Solaris." > > But I looking in th

Re: [GENERAL] Pre-built binary packages of PostgreSQL 9.2 Beta

On Wed, 2012-05-16 at 10:41 -0700, Richard Broersma wrote: > Okay, should the 9.2 beta announcement and press releases be amended > to show this link rather than the ones posted? > The only one available in the announcement is http://www.postgresql.org/download/ which contains the following parag

Re: [GENERAL] Export and import from one postgres server to another

On Wed, 2012-05-30 at 09:56 +0800, Craig Ringer wrote: > On 05/29/2012 02:27 AM, Alexander Reichstadt wrote: > > Hi, > > > > I am trying to "simply" export my postgres database from one server and > > then import it into another. I thought I could use PhpPgAdmin, but the > > hints on the web don'

Re: [GENERAL] Usability write-up - looking at Pg, especially PgAdmin-III and Pg on Windows, from an inexperienced user PoV

Hi, On Fri, 2012-05-25 at 17:56 +0800, Craig Ringer wrote: > Hi all > > I just had the ... pleasure ... of using Windows with Pg again and was > in a usability review frame of mind. I landed up trying to restore my > database using PgAdmin-III, and was astonished at how difficult and > painfu

Re: [GENERAL] Usability write-up - looking at Pg, especially PgAdmin-III and Pg on Windows, from an inexperienced user PoV

On Fri, 2012-05-25 at 19:15 +0800, Craig Ringer wrote: > On 25/05/2012 6:55 PM, Marti Raudsepp wrote: > > Together with an earlier study about common PostgreSQL pitfalls, I've > > created an article on the wiki: > > https://wiki.postgresql.org/wiki/Usability_reviews > > > > However, I suspect posti

Re: [GENERAL] db alias

On Tue, 2012-06-05 at 18:59 +, Gauthier, Dave wrote: > Hi: I think I know the answer to this, but the desire/need is great enough > to get confirmation here. > > Is there a way to alias a db name for purposes of redirecting connections? > For example, you have 2 DBs, DBX and DBY. The user

Re: [GENERAL] pg_database_size differs from df -s

On Wed, 2012-06-06 at 18:46 +0200, Julien Rouhaud wrote: > On Wed, Jun 6, 2012 at 6:28 PM, Tom Lane wrote: > > > Frank Lanitz writes: > > > Am 06.06.2012 17:49, schrieb Tom Lane: > > >> For me, pg_database_size gives numbers that match up fairly well with > > >> what "du" says. I would not expe

Re: [GENERAL] Is there a way to ask PostgreSQL for the name of the computer it's running on?

On Thu, 2012-06-14 at 04:33 +, Rob Richardson wrote: > My customer has 3 computers. The PostgreSQL service could be running on > either of two of them. There is currently no way in our system to determine > which one it is running on. The third computer sometimes needs to know which > of

Re: [GENERAL] Fine-grained replication?

On Mon, 18 Jun 2012 14:49:32 -0700 (PDT), Paul Jones wrote: > Is anyone aware of other non-trigger-based, fine-grained replication tools > for PostgreSQL along the lines of the XReader > or pgreplay > ? > If you

Re: [GENERAL] meaning of "waiting" column in pg_stat_activity?

On Mon, 2012-07-23 at 16:13 -0400, Chris Curvey wrote: > Just wondering...if a query is "waiting", what is it waiting for? Locks. > Is > this only for locks, or can it be for disk, or a memory buffer? Only locks. > (If > there is a description of the meaning of things in pg_stat_activity >

Re: [GENERAL] Roles with empty password (probably bug in libpq and in psql as well).

On Tue, 2012-07-24 at 16:41 +0400, Dmitriy Igrishin wrote: > Hey all, > > According to http://www.postgresql.org/docs/9.2/static/sql-alterrole.html > > A query: > ALTER ROLE davide WITH PASSWORD NULL; > removes a role's password. > > But it's impossible to pass empty (NULL) password to the backe

Re: [GENERAL] Roles with empty password (probably bug in libpq and in psql as well).

On Tue, 2012-07-24 at 17:36 +0400, Dmitriy Igrishin wrote: > Hey Guillaume, > > 2012/7/24 Guillaume Lelarge > On Tue, 2012-07-24 at 16:41 +0400, Dmitriy Igrishin wrote: > > Hey all, > > > > According to > http://www.p

Re: [GENERAL] postgres maintenance db

On Thu, 2012-07-26 at 15:07 -0700, hartrc wrote: > I'm using postgres 9.1.4 on Suse Linux Enterprise Server 11. > After successful installation I by default have one database installed > called postgres. > > I'm starting the process of migrating some database schemas off Oracle and > mysql onto po

Re: [GENERAL] Question about granting permissions

On Sun, 2012-08-26 at 13:10 +0200, Matvey Teplov wrote: > Hi, > > Sorry to bother with the stupid question guys - I'm new to the Postgres. > I'm having issue allowing user to access the database - the user is > not allowed to access the data. I do the following: > 1) grant all on database testdb

Re: [GENERAL] Hot standby problems: consistent state not reached, no connection to master server.

Le 12 avr. 2015 16:50, "Ilya Ashchepkov" a écrit : > > Hello. > > I'm setting up hot standby slave. > It recovers from wal archive files, but I can't connect to it: > $ psql > psql: FATAL: the database system is starting up > > On master: > # select name,setting from pg_settings where name like '

Re: [GENERAL] Where does vacuum FULL write temp-files?

2015-04-15 10:46 GMT+02:00 Andreas Joseph Krogh : > På onsdag 15. april 2015 kl. 04:34:31, skrev Venkata Balaji N < > nag1...@gmail.com>: > > > >> I'm planning to vacuum FULL a pg_largeobject relation (after vacuumlo'ing >> it). The relation is 300GB large so I'm concerned the operation will write

Re: [GENERAL] schedulers

2015-05-03 16:10 GMT+02:00 Yves Dorfsman : > > I just want to confirm that currently there is no scheduler that isn't > dependent on a crontab (like PgAgent), that could be run entirely from > within > PostgreSQL only. > > Anybody knows of one? > > There's none. -- Guillaume. http://blog.guil

Re: [GENERAL] schedulers

2015-05-03 16:55 GMT+02:00 Pavel Stehule : > > > 2015-05-03 16:40 GMT+02:00 Guillaume Lelarge : > >> 2015-05-03 16:10 GMT+02:00 Yves Dorfsman : >> >>> >>> I just want to confirm that currently there is no scheduler that isn't >>> dependent

Re: [GENERAL] Strange replication problem - segment restored from archive but still requested from master

2015-05-22 18:36 GMT+02:00 Piotr Gasidło : > 2015-05-22 6:55 GMT+02:00 Fujii Masao : > > > > This problem happens when WAL record is stored in separate two WAL files > and > > there is no valid latter WAL file in the standby. In your case, the > former file > > is 00044C4D0090 and the

Re: [GENERAL] Strange replication problem - segment restored from archive but still requested from master

2015-05-25 15:15 GMT+02:00 Piotr Gasidło : > 2015-05-25 11:30 GMT+02:00 Guillaume Lelarge : > > >> I currently have wal_keep_segments set to 0. > >> Setting this to higher value will help? As I understand: master won't > >> delete segment and could stre

Re: [GENERAL] Is my standby fully connected?

Hi, 2015-06-01 19:57 GMT+02:00 Ivann Ruiz : > I just setup my databases and got this LOG: > > LOG: database system was shut down in recovery at 2015-06-01 13:31:21 EDT > LOG: entering standby mode > LOG: redo starts at 0/67000278 > LOG: consistent recovery state reached at 0/67000350 > LOG:

Re: [GENERAL] Is my standby fully connected?

When I ran -> psql -c "SELECT pg_current_xlog_location()" > -h192.168.0.10 (primary host) > Well, you can't execute it on a slave. You can use pg_last_xlog_receive_location() and pg_last_xlog_replay_location() on a slave. > > On Mon, Jun 1, 2015 at 2:

Re: [GENERAL] pg_start_backup does not actually allow for consistent, file-level backup

Le 8 juin 2015 2:48 PM, "otheus uibk" a écrit : > > The manual and in this mailing list, the claim is made that consistent, file-level backups may be made by bracketing the file-copy operation with the postgresql pg_start_backup and pg_stop_backup operations. Many people including myself have fou

Re: [GENERAL] pg_xlog on a hot_stanby slave

Le 16 juin 2015 10:57 AM, "Xavier 12" a écrit : > > Hi everyone, > > Questions about pg_xlogs again... > I have two Postgresql 9.1 servers in a master/slave stream replication > (hot_standby). > > Psql01 (master) is backuped with Barman and pg_xlogs is correctly > purged (archive_command is used).

Re: [GENERAL] pg_xlog on a hot_stanby slave

say on its log files? 2015-06-16 12:41 GMT+02:00 Guillaume Lelarge : > > Le 16 juin 2015 10:57 AM, "Xavier 12" a écrit : > >> > >> Hi everyone, > >> > >> Questions about pg_xlogs again... > >> I have two Postgresql 9.1 servers in a mas

Re: [GENERAL] Backup Method

Le 3 juil. 2015 12:03 PM, "howardn...@selestial.com" < howardn...@selestial.com> a écrit : > > Hi everyone, > > I am reaching the point with my database backups where the backups are taking too long, and starting to interfere with running of the system during the day. So I am looking for a bit of s

Re: [GENERAL] Backup Method

Le 3 juil. 2015 12:31 PM, "howardn...@selestial.com" < howardn...@selestial.com> a écrit : > > > > On 03/07/2015 11:15, Guillaume Lelarge wrote: >> >> >> pg_dumpall is not more efficient than pg_dump. As far as I can tell, you're looking for PIT

Re: [GENERAL] EXCLUDE, Gist and integers

Hi, Le 16 juil. 2015 2:23 AM, "Ken Tanzer" a écrit : > > Hi. I'm looking into adding daterange exclusions to some of my tables. Following the documentation, I can do this no problem to prevent any records from overlapping: > > CREATE TEMP TABLE foo ( > client_id integer, > start_date date NO

Re: [GENERAL] Delete rule does not prevent truncate

2015-07-23 9:06 GMT+02:00 Tim Smith : > So tell me guys, instead of bashing away at the fact I only quoted > half a sentence or whatever, how about you answer the following : > > What exactly is was the design decision that lead to TRUNCATE being > supported by triggers but not by rules ? > > Some

Re: [GENERAL] How to restore

Hi, Le 10 août 2015 7:43 AM, "Sachin Srivastava" a écrit : > > Dear Team, > > If I have taken any backup successfully through pg_dump? How can I restore this pg_dump(Sql file) without use of pg_restore. > > There is any command line option or through psql, kindly inform to me. > If it's an SQL f

Re: [GENERAL] How to restore

Please keep the list in your answers. Le 10 août 2015 7:51 AM, "Sachin Srivastava" a écrit : > > Dear Guillaume, > > What is the syntax of this (psql), kindy confirm. > That can be: psql -f the_file the_database > Regards, > Sachin > > On Mon, Aug 10

Re: [GENERAL] Extension to rewrite queries before execution

Hi, Le 13 août 2015 9:51 PM, "Jeff Janes" a écrit : > > I am looking for an extension or a technique that will allow me to intercept a query by the exact query text, and replace that query with a different one. > > The context is running a third-party app which issues queries I have no control ov

Re: [GENERAL] Grouping sets, cube and rollup

Le 26 août 2015 2:06 AM, "Edson Richter" a écrit : > > Any chance to get those amazing wonderful features backported to 9.4? > No. Only bug fixes are backported. -- Guillaume.

Re: [GENERAL] Buffers: shared hit/read to shared_buffers dependence

2015-09-09 17:06 GMT+02:00 Pavel Suderevsky : > Laurenz, Merlin, > > Thanks a lot for your explanations. > > >Even if postgres does not cache the table, the o/s will probably > > still cache it assuming it has the memory to do so. > > Could you please clarify, do I understand right that there are

Re: [GENERAL] Broken primary key after backup restore.

Le 18 sept. 2015 5:23 AM, "Adrian Klaver" a écrit : > > On 09/17/2015 05:37 PM, Michael Chau wrote: >> >> 1) >> >> In Production, I have a DB2 which is replicated partially using Londiste >> from DB1. >> >> >> Well I think the above needs more explanation to help understand how the >> DB2

Re: [GENERAL] question

2015-10-15 20:40 GMT+02:00 anj patnaik : > It's a Linux machine with 8 CPUs. I don't have the other details. > > I get archive member too large for tar format. > > Is there a recommended command/options when dealing with very large > tables, aka 150K rows and half of the rows have data being inser

Re: [GENERAL] question

2015-10-15 23:05 GMT+02:00 Adrian Klaver : > On 10/15/2015 01:35 PM, anj patnaik wrote: > >> Hello all, >> I will experiment with -Fc (custom). The file is already growing very >> large. >> >> I am running this: >> ./pg_dump -t RECORDER -Fc postgres | gzip > /tmp/dump >> >> Are there any other o

Re: [GENERAL] does pg_dump get delayed if I have a loop that does continuous insertions

2015-10-28 21:09 GMT+01:00 anj patnaik : > I was trying to achieve smallest file possible so tried the xz. Right now > the db size returned from SELECT > pg_size_pretty(pg_database_size('postgres') is 1.4 GB and the size of the > dump with xz is 2.2 GB. > > Is there a limit to the size of the data

Re: [GENERAL] Query regarding

Le 4 nov. 2015 10:23 AM, "M Tarkeshwar Rao" a écrit : > > Hi all, > > We have started to convert some oracle sql scripts and converting them to postgres, but facing some issues to create table. > > I have some common doubts in create table script ie. > > ALTER TABLE employee > DROP PRIMARY KEY CAS

Re: [GENERAL] get this warning from pgAdmin

2015-11-12 19:43 GMT+01:00 Adrian Klaver : > On 11/12/2015 10:02 AM, anj patnaik wrote: > >> I get this warning when trying to fetch data for a postgres db. Does >> this indicate a real issue? Thanks >> > > Well it means the statistics for the table are out of touch with reality. > The database wi

Re: [GENERAL] Does PostgreSQL ever create indexes on its own?

2015-11-12 23:21 GMT+01:00 Doiron, Daniel : > I’m troubleshooting a schema and found this: > > Indexes: > "pk_patient_diagnoses" PRIMARY KEY, btree (id) > "index_4341548" UNIQUE, btree (id) > "idx_patient_diagnoses_deleted" btree (deleted) > "idx_patient_diagnoses_diagnosis_type_id

Re: [GENERAL] Only owners can ANALYZE tables...seems overly restrictive

2016-02-29 14:31 GMT+01:00 Stephen Frost : > * David G. Johnston (david.g.johns...@gmail.com) wrote: > > Given the amount of damage a person with write access to a table can get > > into it seems pointless to not allow them to analyze the table after > their > > updates - since best practices woul

Re: [GENERAL] Only owners can ANALYZE tables...seems overly restrictive

2016-02-29 15:20 GMT+01:00 Vik Fearing : > On 02/29/2016 03:15 PM, Guillaume Lelarge wrote: > > 2016-02-29 14:31 GMT+01:00 Stephen Frost > <mailto:sfr...@snowman.net>>: > > > > Realistically, ANALYZE is a background/maintenance task that > autovacuu

Re: [GENERAL] Re: what's the exact command definition in read committed isolation level?

2016-04-19 5:41 GMT+02:00 Jinhua Luo : > > Does that mean a VOLATILE function runs in a different transaction? > > No, all statements triggered by the outer statement is within the same > transaction. If the trigger fails (without trapping the error), all > affects including changes by outer state

Re: [GENERAL] Types of blocks in the `pg_stat_statements`

2016-04-25 15:06 GMT+02:00 Victor Yegorov : > Greetings. > > I cannot get understanding about what different types of blocks means here: > http://www.postgresql.org/docs/current/interactive/pgstatstatements.html > > > I assume, that `shared` are blocks from the `shared_buffers` > and `temp` are bl

Re: [GENERAL] Allow disabling folding of unquoted identifiers to lowercase

Le 3 mai 2016 7:01 PM, "Evgeny Morozov" a écrit : > > That's an interesting idea! The client users would use is probably pgAdmin. I don't know whether pgAdmin parses the query, though. If it does then it should be relatively easy to add this. If not, I'd imagine it's not going to happen. > The pg

Re: [GENERAL] Timestamp with timezone output

Hi, Le 25 mai 2016 4:50 PM, "Arnaud Inovia Team" a écrit : > > I have some question regarding some timezone behaviour. > > Documentation is saying: > > > When a timestamp with time zone value is output, it is always converted from UTC to the current timezone zone, and displayed as local time in t

Re: R: [GENERAL] Vacuum full: alternatives?

2016-06-20 17:03 GMT+02:00 Scott Mead : > > > On Mon, Jun 20, 2016 at 6:13 AM, Andreas Kretschmer < > andr...@a-kretschmer.de> wrote: > >> >> >> Am 20.06.2016 um 11:43 schrieb Job: >> >>> Hi Andreas, >>> >>> I would suggest run only autovacuum, and with time you will see a not more growing ta

Re: [GENERAL] How sync settings or extensions in streaming replication

Le 6 juil. 2016 4:48 AM, "Michael Paquier" a écrit : > > On Wed, Jul 6, 2016 at 11:37 AM, 苏士涛 wrote: > > I am new to PostgreSQL, and i have a question about streaming > > replication. If i enable some extension on master with or without > > native code(in c), do I need to enable this extension on

Re: [GENERAL] SELECT col INTO TEMP TABLE tab2 ON COMMIT DROP FROM tab1

2016-08-12 11:00 GMT+02:00 Alexander Farber : > Francisco, thanks, but - > > On Fri, Aug 12, 2016 at 10:47 AM, Francisco Olarte > wrote: > >> >> https://www.postgresql.org/docs/9.5/static/plpgsql-statement >> s.html#PLPGSQL-STATEMENTS-SQL-ONEROW >> >> > but the custom function I am trying to call

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-03-08 21:06 GMT+01:00 Andreas Joseph Krogh : > På tirsdag 08. mars 2016 kl. 21:03:01, skrev David G. Johnston < > david.g.johns...@gmail.com>: > > On Tue, Mar 8, 2016 at 9:45 AM, Andreas Joseph Krogh > wrote: > >> På tirsdag 08. mars 2016 kl. 17:38:04, skrev Joshua D. Drake < >> j...@command

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-10-23 20:37 GMT+02:00 Andreas Joseph Krogh : > På søndag 23. oktober 2016 kl. 19:15:17, skrev Andreas Joseph Krogh < > andr...@visena.com>: > > På søndag 23. oktober 2016 kl. 17:06:57, skrev Guillaume Lelarge < > guilla...@lelarge.info>: > > 2016-03-08 21:

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-10-23 20:44 GMT+02:00 Guillaume Lelarge : > 2016-10-23 20:37 GMT+02:00 Andreas Joseph Krogh : > >> På søndag 23. oktober 2016 kl. 19:15:17, skrev Andreas Joseph Krogh < >> andr...@visena.com>: >> >> På søndag 23. oktober 2016 kl. 17:06:57, skrev Guillaume

Re: [GENERAL] Exclude pg_largeobject form pg_dump

u're right. v3 (attached) fixes this. > Apart from this concern patch looks good to me. Thanks > > Thanks. > Regards, > Amul > > The new status of this patch is: Waiting on Author > > On Mon, Oct 24, 2016 at 12:19 AM, Guillaume Lelarge > wrote: > > 2016-

Re: [GENERAL] Exclude pg_largeobject form pg_dump

Hi Amul, 2016-11-04 7:52 GMT+01:00 amul sul : > Hi Guillaume, > > I found following issues with this patch, sorry missed in previous post: > > You don't have to be sorry for me doing shitty things :) > #1 : > 43 @@ -392,6 +393,10 @@ main(int argc, char **argv) > 44 dopt.output

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-11-04 9:35 GMT+01:00 Guillaume Lelarge : > Hi Amul, > > 2016-11-04 7:52 GMT+01:00 amul sul : > >> Hi Guillaume, >> >> I found following issues with this patch, sorry missed in previous post: >> >> > You don't have to be sorry for me doing shi

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-11-07 7:06 GMT+01:00 amul sul : > On Mon, Nov 7, 2016 at 2:03 AM, Guillaume Lelarge > wrote: > >> > >> Agreed. I was afraid of that, but for some reason, didn't find that. > I'll > >> fix this. > > > > > > Fixed in v4. >

Re: [GENERAL] Exclude pg_largeobject form pg_dump

2016-11-08 6:01 GMT+01:00 amul sul : > On Tue, Nov 8, 2016 at 5:36 AM, Andreas Joseph Krogh > wrote: > > > > > > I don't see what you mean. It forces dump of Blobs if we didn't use -B > and > > if we include everything in the dump, which seems good to me. What did > you > > try that didn't work a

Re: [GENERAL] Feature request: separate logging

Le 18 nov. 2016 2:03 PM, "otheus uibk" a écrit : > > A glaring weakness in Postgresql for production systems is that the administrator has no way of controlling what types of logs go where. There are at least two types of logs: errors and statement logs. (I could also add: connection, syntax error

Re: [GENERAL] How to introspect autovacuum analyze settings

2016-11-21 14:44 GMT+01:00 Benedikt Grundmann : > Hello all, > > I have a quick question. I feel like somewhere in section 23.1.6 there > should be the answer but I couldn't find it yet. Namely how can I query > the database for total number of tuples inserted, updated, or deleted since > the la

Re: [GENERAL] pg_restore to a port where nobody is listening?

2016-12-21 20:29 GMT+01:00 Daniel Westermann < daniel.westerm...@dbi-services.com>: > >> postgres@pgbox:/home/postgres/ [PG961] pg_restore -h localhost -p 5439 > -F d -C -j 2 /var/tmp/exp/ > >> > >> This runs fine but where does it connect to? Nothing is listening on > port 5439. > > >Given the la

Re: [GENERAL] createuser: How to specify a database to connect to

2017-03-13 16:29 GMT+01:00 Schmid Andreas : > Hi > > I'm trying to add a new DB user with the following command from my client > machine: > createuser -h my.host.name -U mysuperusername --pwprompt newusername > > I'm getting the following message: > createuser: could not connect to database postgr

Re: [GENERAL] createuser: How to specify a database to connect to

2017-03-13 16:57 GMT+01:00 Adrian Klaver : > On 03/13/2017 08:44 AM, Guillaume Lelarge wrote: > >> 2017-03-13 16:29 GMT+01:00 Schmid Andreas > <mailto:andreas.sch...@bd.so.ch>>: >> >> Hi >> >> I'm trying to add a new DB user wit

Re: [GENERAL] createuser: How to specify a database to connect to

2017-03-13 17:10 GMT+01:00 Tom Lane : > Guillaume Lelarge writes: > > It's not very hard to do. But I really wonder why it's not already done. > I > > fear there was a good idea, but I fail to see which one :) > > The core reason why we haven't co

  1   2   3   4   >