Re: [GENERAL] Recording exceptions within function (autonomous transactions?)

that resides in the same database. When you write to the foreign table, it will be using a 'loopback' connection, and that transaction will be able to commit because it is a separate connection. To be fair, I haven't actually done this since the days of dblink, I *believe* it should work with fdw though. -- Scott Mead Sr. Architect OpenSCG http://openscg.com > Steve Pritchard > British Trust for Ornithology, UK

Re: [GENERAL] How to reduce pg_dump backup time

> On Oct 6, 2015, at 00:52, Sachin Srivastava wrote: > > Dear Team, > > > > I am using PostgreSQL 9.1 on Redhat Linux on my Production environment. My > database size is 680 GB and it take 7 hour for completion the pg_dump backup. > > > > I want that my pg_dump backup should be fast and

Re: [GENERAL] How to reduce pg_dump backup time

You can use a tool like WAL-E or barman to build out a nice strategy. At the end of the day, you'll still want to do a periodic, logical backup (make sure your phyiscal backups are sane), but, using physical backups will open you up to many more options. -- Scott Mead Sr. Architect *OpenS

Re: [GENERAL] backup.old

On Wed, Oct 7, 2015 at 15:38, David G. Johnston wrote: On Wed, Oct 7, 2015 at 3:29 PM, Steve Pribyl < steve.pri...@akunacapital.com [steve.pri...@akunacapital.com] > wrote: Thank you very much. I read someplace if you run pg_start_backup twice the backup.old will be created, but there was not

Re: [GENERAL] Creating Report for PieChart

> On Oct 13, 2015, at 19:56, Alex Magnum wrote: > > Hello, > I need to process some statistics for a pie chart (json) where I only want to > show a max of 8 slices. If I have more data points like in below table I need > to combine all to a slice called others. If there are less or equal 8 i

Re: [GENERAL] Creating Report for PieChart

On Tue, Oct 13, 2015 at 9:14 PM, Scott Mead wrote: > > > On Oct 13, 2015, at 19:56, Alex Magnum wrote: > > Hello, > I need to process some statistics for a pie chart (json) where I only want > to show a max of 8 slices. If I have more data points like in below table I >

Re: [GENERAL] question

mmended command/options when dealing with very large >> tables, aka 150K rows and half of the rows have data being inserted with >> 22MB? >> >> > Don't use tar format? I never understood the interest on this one. You > should better use the custom method. > + 1

Re: [GENERAL] ID column naming convention

> On Oct 13, 2015, at 18:27, droberts wrote: > > Gavin Flower-2 wrote >>> On 14/10/15 06:36, droberts wrote: >>> Hi, is there a problem calling ID's different when used as a FK vs table >>> ID? >>> For example >>> >>> >>> mydimtable () >>> ID >>> name >>> description >>> >>> >>> myfactta

Re: [GENERAL] [BUGS] postgresql table data control

> On Oct 19, 2015, at 04:29, Shulgin, Oleksandr > wrote: > >> On Sat, Oct 17, 2015 at 1:26 AM, 許耀彰 wrote: >> Dear Support Team, >> How can we know each table data increase day by day? It mean how do we get >> how many data produce today,included which data? Thank you. > > > [moving from bu

Re: [GENERAL] trouble downloading postgres 9.4 for RHEL 6.x

> On Oct 21, 2015, at 12:28, Adrian Klaver wrote: > >> On 10/21/2015 09:14 AM, anj patnaik wrote: >> Ok, i am trying to determine why I am getting errors. Is it possible >> that my browser is corrupting the transfer? > > Maybe, though I used FireFox to download also. I would go to wherever the

Re: [GENERAL] trouble downloading postgres 9.4 for RHEL 6.x

> On Oct 21, 2015, at 14:58, anj patnaik wrote: > > With the graphical installer, I had a way to create a user. Does it create > postgres user by default? Yeah, it creates both the OS user and the database super-user. > > Let me know. Thx > >> On Wed, Oct 21,

Re: [GENERAL] Red Hat Policies Regarding PostgreSQL

On Wed, Oct 28, 2015 at 7:10 AM, Mark Morgan Lloyd < markmll.pgsql-gene...@telemetry.co.uk> wrote: > Tom Lane wrote: > >> Michael Convey writes: >> >>> Due to policies for Red Hat family distributions, the PostgreSQL >>> installation will not be enabled for automatic start or have the database >>

Re: [GENERAL] can postgres run well on NFS mounted partitions?

On Tue, Nov 10, 2015 at 6:26 PM, anj patnaik wrote: > Thanks for the feedback. I have setup a second Linux VM (running RHEL > 5.11) and Postgres 9.4. I ran some insertions today from a client running > on Windows. The client does a loop of 30 updates. > > I am seeing about 10-20% increase in late

Re: [GENERAL] Best tool to pull from mssql

On Wed, Nov 11, 2015 at 9:37 AM, taspotts wrote: > Take a look at Pentaho Kettle > . They have a > free community edition. > > +10 > I use it frequently to migrate data from MSSQL to Postgres. It has a nice > GUI for setting everythi

Re: [GENERAL] Checkpoint Err on Startup of Rsynced System

ndation#Physical_Database_Backups will take you to: https://www.postgresql.org/docs/current/static/continuous-archiving.html --Scott --o--o--o--o--o--o--o--o--o--o--o--o-- > Jim Longwill > PSMFC Regional Mark Processing Center > jlongw...@psmfc.org > --o--o--o--o--o--o--o--o--o--o--o--o-- > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- -- Scott Mead Sr. Architect *OpenSCG <http://openscg.com>* http://openscg.com

Re: [GENERAL] Replication

. --Scott > Regards, >> >> Bertrand >> > > > > -- > *Melvin Davidson* > I reserve the right to fantasize. Whether or not you > wish to share my fantasy is entirely up to you. > -- -- Scott Mead Sr. Architect *OpenSCG <http://openscg.com>* http://openscg.com

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

gt; -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- -- Scott Mead Sr. Architect *OpenSCG <http://openscg.com>* http://openscg.com

Re: [GENERAL] dblink authentication failed

> On Jun 27, 2016, at 03:38, Kiss Attila wrote: > > Hello, > I have some problem with using dblink_connect_u() in my function. > When I provide the password in the connection string, there is no problem, > but when I don’t, it says: > ERROR: could not establish connection > DETAIL: fe_senda

Re: [GENERAL] pasting a lot of commands to psql

My personal favorite for this exact thing is to use '\e' When you are in psql, if you \e (on *nix) it will open a temp file in whatever your $EDITOR variable is set ( I use vim). Paste your data, then save-close the file. It will put you back into psql and execute the command for you. --Scott > >> What are you exactly aiming to do? >> >> Have you tried - >> psql < myfile >> >> >> >>> Dmitry Shalashov, surfingbird.ru & relap.io >>> >> -- >> -- >> Best Regards >> Sameer Kumar | DB Solution Architect >> *ASHNIK PTE. LTD.* >> >> 101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533 >> >> T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com >> > > -- -- Scott Mead Sr. Architect *OpenSCG <http://openscg.com>* http://openscg.com

Re: [GENERAL] pasting a lot of commands to psql

On Thu, Jul 7, 2016 at 1:39 PM, Scott Mead wrote: > > > On Thu, Jul 7, 2016 at 1:30 PM, Dmitry Shalashov > wrote: > >> Hi Sameer, >> >> I am trying to copy-paste (and execute) random snippets of SQL to psql >> console. >> >> There is another wa

Re: [GENERAL] Uber migrated from Postgres to MySQL

fully they vectored somewhere in the middle and got themselves a nice sandbox. --Scott > > >> >> Regards, >> Hristo S. >> >> >> >> >> >> > > -- > Achilleas Mantzios > IT DEV Lead > IT DEPT > Dynacom Tankers Mgmt > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- -- Scott Mead Sr. Architect *OpenSCG <http://openscg.com>* http://openscg.com

Re: [GENERAL] Unable to create oracle_fdw (foreign data wrapper) extension

t; two lines: > > t=2016-09-15 11:05:42 PDT d= h= p=23300 a=FATAL: XX000: invalid cache ID: > 41 > t=2016-09-15 11:05:42 PDT d= h= p=23300 a=LOCATION: SearchSysCacheList, > syscache.c:1219 > > Removing oracle_fdw from shared_preload_libraries allows postgres to be > restarte

Re: [GENERAL] Unable to create oracle_fdw (foreign data wrapper) extension

/x86_64-linux-gnu/libaio.so.1 (0x7f4475045000) > libclntshcore.so.12.1 => > /usr/lib/oracle/12.1/client64/lib/libclntshcore.so.12.1 > (0x7f4474af5000) > /lib64/ld-linux-x86-64.so.2 (0x7f447990c000) > > > > On Thu, Sep 15, 2016 at 1:10 PM, Scott Mead wrote: >

Re: [GENERAL] Graphical entity relation model

t; Best regards Johannes -- -- Scott Mead Sr. Architect *OpenSCG <http://openscg.com>* http://openscg.com

Re: [SPAM] [GENERAL] psql 9.3 automatic recovery in progress

ne shot. --Scott > > regards, tom lane > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- -- Scott Mead Sr. Architect *OpenSCG <http://openscg.com>* http://openscg.com

Re: [GENERAL] Postgresql using lxd faild to find address

wn at > 2016-10-10 15:17:32 UTC > 2016-10-10 15:17:33 UTC [2353-2] LOG: MultiXact member wraparound > protections are now enabled > 2016-10-10 15:17:33 UTC [2352-1] LOG: database system is ready to accept > connections > 2016-10-10 15:17:33 UTC [2357-1] LOG: autovacuum launcher started > > Thanks > > > > -- -- Scott Mead Sr. Architect *OpenSCG <http://openscg.com>* http://openscg.com

Re: [GENERAL] ANN: Upscene releases Database Workbench 5.2.4

s. It is a moderated list, but that's the appropriate venue. --Scott > > > > With regards, > > Martijn Tonies > Upscene Productions > http://www.upscene.com > > Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, > SQL Anywhere, My

Re: [GENERAL] Remove Standby (SLAVE) from Primary (MASTER) - Postgres9.1

fter the standby is removed from the primary, both of nodes > are in standalone configuration. " > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > > This message and the information contained herein is proprietary and > confidential and subject to the Amdoc

Re: [GENERAL] deadlock error - version 8.4 on CentOS 6

eported > the error on. > > So I feel pretty confident this is the issue. I guess I should retry > the update in my application. > > Thanks, The problem is that you're doing: 'LOCK TABLE t_unit_status_log' If you were executing normal updates, autovacuum would be fin

Re: [GENERAL] Methods to quiesce PostgreSQL DB without configuring log archival

> On Nov 22, 2016, at 01:23, MEERA wrote: > > Hi all, > > If archive_mode is not configured, and i use snapshot solution for backup of > the server, how can i ensure data consistency? Is there a way to quiesce all > the connections to DB? If your snapshot solution is atomic, then you are *pr

Re: [GENERAL] Disabling inheritance with query.

inheritance counts in pg_attribute, >> and there may be other things I'm not remembering offhand. >> >> Why can't you use the normal ALTER TABLE approach? >> >> regards, tom lane >> > > -- -- Scott Mead Sr. Architect *OpenSCG <http://openscg.com>* http://openscg.com

Re: [GENERAL] Er Data Modeller for PostgreSQL

ack and find the exact command needed to kick it off, it's CLI is a bit over-complicated. --Scott > > Thanks for the reminder, > > > Rich > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://

Re: [GENERAL] Re: Building PL/Perl procedural language without --with-perl configure flag

re and your CFLAGS, LDFLAGS, etc... 3. Re-run configure using the same environment as specified by pg_config, just add --with-perl 4. Build the server 5. Install the binaries Note: After building, you could always run a diff between the existing installation and a new installation and only install

Re: [GENERAL] Selecting newly added column returns empty but only when selecting with other columns in table

> On Nov 26, 2015, at 21:29, mrtruji wrote: > > Sure thing. Below are the results from your query along with the version and > table info. Not sure about the index. I queried the table quite a bit before > adding the new column and didn't have any issues. > > Here is the result from your qu

Re: [GENERAL] 2 questions

> On Nov 30, 2015, at 12:54, anj patnaik wrote: > > 1) directory listing: > > /opt/nfsDir/postgres/9.4/ > /bin > /data > /etc >/pgAdmin3 >

Re: [GENERAL] Loggingt psql meta-commands

On Thu, Dec 10, 2015 at 2:50 PM, oleg yusim wrote: > Thanks John, I realized that and confirmed in my logs. What I'm trying to > determine now, can I only log some SELECT statements, or I should log all > of them or none of them. > You can configure this to multiple levels: Global, per-user, p

Re: [GENERAL] Does PostgreSQL support to write glusterfs by Libgfapi

l since PostgreSQL provides no mechanism to allow for shared-disk clustering (active/active). If you are planning on using active/passive, you must plan carefully so as not to create a split-brain scenario. -- Scott Mead Sr. Architect *OpenSCG* PostgreSQL, Java & Linux Experts http://openscg.c

Re: [GENERAL] Code of Conduct: Is it time?

On Sun, Jan 10, 2016 at 5:09 PM, Adrian Klaver wrote: > On 01/10/2016 02:05 PM, Regina Obe wrote: > >> Gavin, >> >>> I once went out of my way to help someone with Mac. They were so Mac >>> >> centric they did not realize that they were not giving us the right >> information to help them, but th

Re: [GENERAL] How can I use a dynamic column name after NEW. or OLD. in trigger procedure?

; || v_ets_destination || ' VALUES ( ($1).*)'; -- DEBUG --RAISE NOTICE 'SQL: %',sql; BEGIN EXECUTE sql USING NEW; ... -- Scott Mead Sr. Architect OpenSCG PostgreSQL, Java & Linux Experts Desk : (732) 339 3419 ext 116 Bridge: (585) 484-8032 http://open

Re: [GENERAL] How to stop autovacuum for daily partition old tables

> On Jan 20, 2016, at 19:54, AI Rumman wrote: > > But, will it not create transaction wraparound for those table? > > Thanks. > >> On Wed, Jan 20, 2016 at 4:44 PM, Melvin Davidson >> wrote: >> >> ALTER TABLE your_schema.your_table SET (autovacuum_enabled = false, >> toast.autovacuum_enabl

Re: [GENERAL] Catalog bloat (again)

-- Scott Mead via mobile IPhone : +1-607-765-1395 Skype : scottm.openscg Gtalk: sco...@openscg.com > On Jan 27, 2016, at 22:11, Joshua D. Drake wrote: > >> On 01/27/2016 03:37 PM, Ivan Voras wrote: >> >> >> On 28 January 2016 at 00:13, Bill Moran >

Re: [GENERAL] Schema Size

On Tue, Mar 1, 2016 at 6:07 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > You should read the definitions for the functions you are using to > retrieve the sizes. > > ​http://www.postgresql.org/docs/current/static/functions-admin.html​ > > +1, you've gotta be careful with each of th

Re: [GENERAL] Postgresql 9.3.4 file system compatibility

On Fri, Apr 8, 2016 at 9:16 AM, Marllius wrote: > thank you, but i need a link in official postgresql documentation > I'm not sure if that link exists, the general rule is In g if it's POSIX, it'll work. You'll find that most PostgreSQL-ers have strong opinions and preferences in regards to file

Re: [GENERAL] index build faster on 8G laptop than 30G server

On Tue, Apr 19, 2016 at 5:28 PM, Bill Ross wrote: > I've been running an index build for almost an hour on my 30G server that > takes ~ 20 mins on my puny old macbook. > > It seems like I've tuned all I can.. what am I missing? > > Concurrent traffic on the server ? Locks / conflicts with running

Re: [GENERAL] Using both ident and password in pg_hba.conf

On Mon, May 9, 2016 at 5:42 PM, D'Arcy J.M. Cain wrote: > On Mon, 09 May 2016 17:12:22 -0400 > Tom Lane wrote: > > If the same user id + database combinations might be valid in both > > cases (from both PHP and manual connections) I think your only other > > option for distinguishing which auth

Re: [GENERAL] postgresql embedded mode

ou where to explain your design goals for > whatever you are creating. Right now we have a series of disconnected > references to parts of whatever it is. > > +1 One individual's idea of embedded is not the same as another's -- Scott Mead Sr. Architect *OpenSCG <

Re: [GENERAL] mild modification to pg_dump

esql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- -- Scott Mead Sr. Architect *OpenSCG <http://openscg.com>* http://openscg.com

Re: [GENERAL] mild modification to pg_dump

t same data, >>> of course, encripted to the common users). >>> >> >> >> I would just fork pg_dump to do the actual dump rather than try and >> incorporate its source code into your app. >> >> >> > > > -- > Sent via pgsql-general

Re: [GENERAL] Survey on backing up unlogged tables: help us with PostgreSQL development!

On Tue, Nov 16, 2010 at 7:21 PM, Glen Parker wrote: > On 11/16/2010 03:24 PM, Karsten Hilbert wrote: > >> PostgreSQL 9.1 is likely to have, as a feature, the ability to create >>> tables which are "unlogged", meaning that they are not added to the >>> transaction log, and will be truncated (empti

Re: [GENERAL] port warded (iptables) postgres

Make sure that listen_addresses='' or '*' By default, the server only listens on unix sockets. --Scott On Tue, Nov 16, 2010 at 6:41 PM, zhong ming wu wrote: > Hello > > I have successfully used iptables to direct ports for other services. > For example I run apache on 8443 on 127.0.0.1 and

Re: [GENERAL] Survey on backing up unlogged tables: help us with PostgreSQL development!

On Tue, Nov 16, 2010 at 8:15 PM, Tom Lane wrote: > Scott Mead writes: > > +1 -- Is there a technical reason to do a TRUNCATE on restart? I'd feel > > better if I could just have unlogged tables that survive unless something > > like a power-outage etc... I'm in

Re: [GENERAL] Survey on backing up unlogged tables: help us with PostgreSQL development!

On Tue, Nov 16, 2010 at 10:25 PM, Tom Lane wrote: > Man, the number of misunderstandings in this thread is staggering. > Let me try to explain what the proposed feature will and will not do. > > 1. The system catalog entries for all tables will be wal-logged. > So schema (DDL) will survive a cras

Re: [GENERAL] Survey on backing up unlogged tables: help us with PostgreSQL development!

On Wed, Nov 17, 2010 at 10:38 AM, Scott Mead wrote: > On Tue, Nov 16, 2010 at 10:25 PM, Tom Lane wrote: > >> Man, the number of misunderstandings in this thread is staggering. >> Let me try to explain what the proposed feature will and will not do. >> >> 1. The

Re: [GENERAL] Survey on backing up unlogged tables: help us with PostgreSQL development!

On Wed, Nov 17, 2010 at 12:49 PM, Josh Berkus wrote: > > As was already mentioned, application logs. Unlogged tables would be >> perfect for that, provided they don't go *poof* every now and then for >> no good reason. Nobody's going to be too heart broken if a handful of >> log records go missi

Re: [GENERAL] where is pg_stat_activity (and others) in the documentation?

On Mon, Nov 15, 2010 at 10:03 AM, Vick Khera wrote: > On Mon, Nov 15, 2010 at 5:15 AM, Willy-Bas Loos > wrote: > > I was looking for what exactly "waiting" means in pg_stat_activity. > You can find out exactly what you're waiting for by correlating this to the pg_locks table. Grab the 'proc

Re: [GENERAL] monitoring warm standby lag in 8.4?

Yeah, my website is busted. I'll fix it for you. On Thu, Dec 9, 2010 at 2:30 PM, Josh Kupershmidt wrote: > Hi all, > > I'm wondering if there's an accepted way to monitor a warm standby > machine's lag in 8.4. The wiki[1] has a link[2] to a script which > parses the output of pg_controldata, lo

Re: [GENERAL] Tablespace Issue

On Thu, Feb 17, 2011 at 4:08 AM, Adarsh Sharma wrote: > Dear all, > > Today I got to have a strong issue while craeting table in a database. > > pdc_uima=# create table clause2_naxal as select * from clause2 c > ,page_naxal_v3 p where c.source_id = p.crawled_page_id; > ERROR: could not extend re

Re: [GENERAL] Per-session memory footprint (9.0/windows)

On Wed, Mar 2, 2011 at 11:07 AM, Hannes Erven wrote: > Folks, > > > I run a PG (currently 8.4, but will shortly migrate to 9.0) database on > Windows Server 2003 that supports a desktop application which opens a > few long-running sessions per user. This is due to the Hibernate > persistence laye

Re: [GENERAL] .pgpass and root: a problem

udo' model so that they can have *most* of what they need, without allowing identity switches ? I was trying to come up with something clever, but if they're root, they're root. --Scott Mead sco...@openscg.com http://www.openscg.com > > So, by switching from database-s

Re: [GENERAL] PG V9 on NFS

On Mon, Feb 11, 2013 at 5:22 PM, Gauthier, Dave wrote: > Can PG V9.1* support a DB that's on an NFS disk? > > I googled around, but nothing popped out. > > Also, would you happen to know the answer to this for MySQL v5.5*? > > Thanks in Advance. > I've done this before, and I reall

Re: [GENERAL] Re: Causeless CPU load waves in backend, on windows, 9.5.5 (EDB binary).

gt; > this will send a lot of data over the wire, the SQL overhead should be > fairly small. > > You can send more data if you combine that with e.g. generate_series() > > > > > > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgres

Re: [GENERAL] Recover PostgreSQL database folder data

show in full. > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- -- Scott Mead Sr. Architect *OpenSCG <http://openscg.com>* http://openscg.com

Re: [GENERAL] GENERAL : [Can somebody explain about Base directory]

11/postgresql-bloat-estimates/) > -- > Regards : > Venktesh Guttedar. > > -- -- Scott Mead Sr. Architect *OpenSCG <http://openscg.com>* http://openscg.com

Re: [GENERAL] logging of application level user in audit trigger

r/app pair and the number of sessions that were using to the DB at a given time. --Scott > > I am curious how others deal with the same issue , is there better or more > inbuilt solutions > to store the application level user in the audit trail records. > > Regds > mallah. > > ( https://www.redgrape.tech ) > > > > > > > > > > -- -- Scott Mead Sr. Architect *OpenSCG <http://openscg.com>* http://openscg.com

Re: [GENERAL] Unable to install EASM postgre due to error 8023

> > > > *Garry Sim* > > Professional Service Consultant > > > > *NETRUST PTE LTD* > 70 Bendemeer Road #05-03 Luzerne Singapore 339940 > > DID: +65 6212 1393 <+65%206212%201393> | Fax +65 6212 1366 > <+65%206212%201366> |Website http://www.netrust.net > > > -- -- Scott Mead Sr. Architect *OpenSCG <http://openscg.com>* http://openscg.com

Re: [GENERAL] Unable to install EASM postgre due to error 8023

t; > > *Garry Sim* > > Professional Service Consultant > > > > *NETRUST PTE LTD* > 70 Bendemeer Road #05-03 Luzerne Singapore 339940 > > DID: +65 6212 1393 <+65%206212%201393> | Fax +65 6212 1366 > <+65%206212%201366> |Website http://www.netrust.net > &

Re: [GENERAL] Strange case of database bloat

k. >> > > Given the other time I have seen similar behaviour, the question in my > mind is why free pages near the beginning of the table don't seem to be > re-used. > > I would like to try to verify that however, if you have any ideas. > >> >> -- >> PT >> > > > > -- > Best Wishes, > Chris Travers > > Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor > lock-in. > http://www.efficito.com/learn_more > -- -- Scott Mead Sr. Architect *OpenSCG <http://openscg.com>* http://openscg.com

Re: [GENERAL] Logging at schema level

vidual user (tenant) in the system and present the logs that way: From: https://github.com/dalibo/pgbadger -u | --dbuser username : only report on entries for the given user. .... -- Scott Mead Sr. Architect *OpenSCG <http://openscg.com>* http://openscg.com > > On 21-Jul-

Re: [GENERAL] How to get transaction started always in WRITE mode.

ertraulich und ausschließlich für den > bezeichneten Adressaten bestimmt. Wenn Sie nicht der vorgesehene Adressat > dieser E-Mail oder dessen Vertreter sein sollten, so beachten Sie bitte, > dass jede Form der Kenntnisnahme, Veröffentlichung, Vervielfältigung oder > Weitergabe des Inhalts dieser E-Mail unzulässig ist. Wir bitten Sie, sich > in diesem Fall mit dem Absender der E-Mail in Verbindung zu setzen. > > -- -- Scott Mead Sr. Architect *OpenSCG <http://openscg.com>* http://openscg.com

Re: [GENERAL] archive_command fails but works outside of Postgres

> On Aug 19, 2017, at 04:05, twoflower wrote: > > Alvaro Herrera-9 wrote > I saw one installation with "gsutil cp" in archive_command recently. It had > the CLOUDSDK_PYTHON environment variable set in the archive_command itself. > Maybe that's a problem. > After all, this was the solution: >

Re: [GENERAL] Veritas cluster management

ios. Technically however, pg_ctl reload works just fine, just don't break anything :) --Scott > > Thanks > > -- > World Peace Through Nuclear Pacification > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to y

Re: [GENERAL] WAL Archive command.

l with files that are removed from the slave and making sure they get removed from the master appropriately, but, this is fairly straightforward. --Scott > HTH > > > Please assist. > > > > Thanks, > > > > John Britto > > > > > > > >

Re: [GENERAL] Rsync to a recovering streaming replica?

he more parallel threads you use, the harder you'll beat up the disks / network on the master, which could impact production. Good luck --Scott > > > > Thank you > > Igor Polishchuk > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql

Re: [GENERAL] Rsync to a recovering streaming replica?

> > Igor > > On Sep 27, 2017, at 12:48, Scott Mead wrote: > > > > On Wed, Sep 27, 2017 at 1:59 PM, Igor Polishchuk > wrote: > >> Sorry, here are the missing details, if it helps: >> Postgres 9.6.5 on CentOS 7.2.1511 >> >> > On Sep 27, 2017, at

Re: [GENERAL] Using cp to back up a database?

/pgsql/data/* $dumpdir/data/ >> /usr/bin/psql -U postgres template1 -c "SELECT pg_stop_backup();" >> >> >> Should it use rsync or pg_dump instead? >> >> Thanks >> >> -- >> World Peace Through Nuclear Pacification >> >> > > > -- > Darren Douglas > Synse Solutions > dar...@synsesolutions.com > 520-661-5885 <(520)%20661-5885> > > > > -- > World Peace Through Nuclear Pacification > > -- -- Scott Mead Sr. Architect *OpenSCG <http://openscg.com>* http://openscg.com

Re: [GENERAL] Using Variables in Queries

like JDBC, etc..., but from psql it works great. https://www.postgresql.org/docs/9.5/static/app-psql.html#APP-PSQL-VARIABLES --Scott > And if so, what's the reason of not adding this feature? Seems very > useful to me. > > Thanks, > > > Igal Sapir > Lucee Core Developer > Lucee.org <http://lucee.org/> > -- -- Scott Mead Sr. Architect *OpenSCG <http://openscg.com>* http://openscg.com

Re: [GENERAL] Postgres 9.6 fails to start on VMWare

he files I can drop, dump and restore, in which > case how do I ‘drop’ the DB without postgres running? > > Ta, > > Martin. > > > > Was the server you were backing up shut down or in backup mode when you > did the 'dd' copy? > > -- > > Mike Nolan > -- -- Scott Mead Sr. Architect *OpenSCG <http://openscg.com>* http://openscg.com

Re: [GENERAL] Adding the host name to the PgSQL shell

On Mon, Jun 8, 2009 at 12:44 PM, Madison Kelly wrote: > Hi all, > > I work on a development and production server, and I am always > double-checking myself to make sure I am doing something on the right > server. > > Is there a way, like in terminal shells, to change the PgSQL shell's > prompt

Re: [GENERAL] Adding the host name to the PgSQL shell

On Mon, Jun 8, 2009 at 1:30 PM, Madison Kelly wrote: > > > That works like a charm, thank you! No problem :) > > > Next question though; > > How can I get it to save my custom prompt across sessions/server restarts? > It there something equivalent to '.bash_profile'? > ~/.psqlrc --Scott

Re: [GENERAL] running pg_dump from python

On Sun, Jun 14, 2009 at 4:06 PM, Garry Saddington < ga...@schoolteachers.co.uk> wrote: > I ahve the following python file that I am running as an external method in > Zope. > > def backup(): > import os > os.popen("c:/scholarpack/postgres/bin/pg_dump scholarpack > > c:/scholarpack/ancillary/

Re: [GENERAL] nagios -- number of postgres connections

On Tue, Jun 16, 2009 at 11:32 PM, John R Pierce wrote: > Whit Armstrong wrote: > >> anyone know a way to get nagios to monitor the number of postgres >> connections? >> >> > You could also login to the database and run: select count(1) from pg_stat_activity; --Scott

Re: [GENERAL] nagios -- number of postgres connections

On Tue, Jun 16, 2009 at 11:32 PM, John R Pierce wrote: > Whit Armstrong wrote: > >> anyone know a way to get nagios to monitor the number of postgres >> connections? >> >> > You could also login to the database and run: select count(1) from pg_stat_activity; --Scott

Re: [GENERAL] Controlling proliferation of postgres.exe processes

2009/6/23 Radcon Entec > Greetings! > > At the current moment, our customer's computer has 22 instances of > postgres.exe running. When a colleague checked a few minutes ago, there > were 29. Our contract specifies that we cannot consume more than 40% of the > computer's memory, and we're over

Re: [GENERAL] Replication

On Tue, Jun 23, 2009 at 10:07 PM, Craig Ringer wrote: > Thomas Kellerer wrote: > > Mike Christensen wrote on 23.06.2009 19:37: > >> Does anyone actually have that (any node can go down and the others > still > >> replicate amongst themselves?) > > > > I think this is what Oracle promises with thei

Re: [GENERAL] [BUGS] Integrity check

2009/6/23 David Fetter > On Tue, Jun 23, 2009 at 03:38:35PM +0800, Prasad, Venkat wrote: > > Hello, > > > > Please can you assist on following questions. > > This is an issue for pgsql-general, where I'm redirecting this. > > > > * do you any tool to check postgreSQL database integrity check? > >

Re: [GENERAL] masking the code

On Fri, Jun 26, 2009 at 3:37 PM, wrote: > > > I completely agree w/ HArald. Its not something we'd want to see in an open > source product. That said, I saw yesterday that the latest version of > EnterpriseDB has this feature. So if you want to protect your own IP, then > you've got to purchase

Re: [GENERAL] masking the code

On Mon, Jun 29, 2009 at 9:35 AM, Jonah H. Harris wrote: > On Mon, Jun 29, 2009 at 9:31 AM, Scott Mead > wrote: > >> >>It is important to note (as many people have already pointed out) that >> both EnterpriseDB and Oracle's wrap functionality is declared as a 1

Re: [GENERAL] masking the code

On Mon, Jun 29, 2009 at 9:35 AM, Jonah H. Harris wrote: > On Mon, Jun 29, 2009 at 9:31 AM, Scott Mead > wrote: > >> >>It is important to note (as many people have already pointed out) that >> both EnterpriseDB and Oracle's wrap functionality is declared as a 1

Re: [GENERAL] pasting into psql garbles text

On Mon, Jun 29, 2009 at 10:49 AM, Cédric Villemain < cedric.villem...@dalibo.com> wrote: > Le samedi 27 juin 2009, Merlin Moncure a écrit : > > > > > Interestingly, the one platform that tends not to suffer from this is > > windows so I'm guessing this is a readline problem. Has anybody else > >

Re: [GENERAL] permissions / ACLs made easier?

On Mon, Jun 29, 2009 at 1:01 PM, Jeff Davis wrote: > > > CREATE USER read_only_user > GRANT (SELECT ON TABLE, USAGE ON SCHEMA) FROM admin_user; > > "read_only_user" would automatically have SELECT privileges on any table > that admin_user has SELECT privileges on, and automatically have USAGE >

Re: [GENERAL] Postgres online backup and restore

On Thu, Jun 25, 2009 at 9:40 AM, Chris Barnes wrote: > Sorry if posting twice, wasn’t part of general when sent and didn’t see > it received by group. > > I started an online backup of postgres, tar’d my data folder, copy to usb > drive in production > and restored it into my RC environment. H

Re: [GENERAL] Postgres online backup and restore

On Thu, Jun 25, 2009 at 9:40 AM, Chris Barnes wrote: > Sorry if posting twice, wasn’t part of general when sent and didn’t see > it received by group. > > I started an online backup of postgres, tar’d my data folder, copy to usb > drive in production > and restored it into my RC environment. H

Re: [GENERAL] Python client + select = locked resources???

On Wed, Jul 1, 2009 at 12:21 PM, johnf wrote: > On Monday 29 June 2009 09:26:24 am Craig Ringer wrote: > > Try connecting to the database with psql and running > > "select * from pg_stat_activity" > > while the web app is running. You should see only "IDLE" or working > > connections, never idl

Re: [GENERAL] Trying to find a low-cost program for Data migration and ETL

On Tue, Jul 7, 2009 at 11:48 AM, Rstat wrote: > > > Hi, Im building a database for my company. We are a rather small size book > company with a lot of references and still growing. > > We have a Mysql database here and are trying to find some good tools to use > it at its best. Basically we are j

Re: [GENERAL] Trying to find a low-cost program for Data migration and ETL

On Tue, Jul 7, 2009 at 1:26 PM, Scott Mead wrote: > > > > You may have some luck by viewing a similar thread on another mailing list: > > http://www.theserverside.net/discussions/thread.tss?thread_id=54755 > That being said, I would highly recommend using: http://

Re: [GENERAL] Start With... Connect By?

On Mon, Jul 13, 2009 at 2:05 AM, Philippe Lang wrote: > Hi, > > Now that Postgresql 8.4 has a "WITH RECURSIVE" operator (thanks! :)), is > there a chance we can see one day "START WITH... CONNECT BY" in > Postgresql, or is that something 100% oracle-specific? There is a commercial / proprietary

Re: [GENERAL] Start With... Connect By?

On Mon, Jul 13, 2009 at 2:05 AM, Philippe Lang wrote: > Hi, > > Now that Postgresql 8.4 has a "WITH RECURSIVE" operator (thanks! :)), is > there a chance we can see one day "START WITH... CONNECT BY" in > Postgresql, or is that something 100% oracle-specific? There is a commercial / proprietary

Re: [GENERAL] pg_dump of a big table

On Mon, Jul 13, 2009 at 3:29 PM, Sam Mason wrote: > On Mon, Jul 13, 2009 at 06:57:43PM +, Nelson Correia wrote: > > Running pg_dump from another machine needs much space on the DB > > host? Or it just outputs the data as it goes? > > pg_dump should use very little space on the server, it just

Re: [GENERAL] [Q] single image Table across multiple PG servers

On Tue, Jul 14, 2009 at 1:16 AM, V S P wrote: > Hello > > I am researching how to store the data for easy 'user-driven' > reporting (where I do not need to develop application for > every user request). > > The data will typically be number ranges and text strings with > unique Id for each row >

[GENERAL] Log timings on Windows 64

Hey all, I'm looking at windows, and a couple of quick google's didn't give me anything, If I set my log_min_duration_statement < 16 ms, I get one of 2 values for my pgbench runs (pretty quick statements). 0, or 16 ms (sometimes 15.999). If I benchmark some other way (via my app) things l

  1   2   3   >