Re: [GENERAL] mild modification to pg_dump

. (My apps are using that 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. >> >> >> > > > -- >

Re: [GENERAL] mild modification to pg_dump

g 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] Postgres 9.6 fails to start on VMWare

ich was converted and loaded into VMWare. > > I ‘believed’ that this should keep the low level disk structure the same, > but if this has corrupted the files I can drop, dump and restore, in which > case how do I ‘drop’ the DB without postgres running? > > Ta, > > Martin. > > > &g

Re: [GENERAL] Using Variables in Queries

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 > Luc

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] Rsync to a recovering streaming replica?

to happen. > > > Igor > > On Sep 27, 2017, at 12:48, Scott Mead <sco...@openscg.com> wrote: > > > > On Wed, Sep 27, 2017 at 1:59 PM, Igor Polishchuk <ora4...@gmail.com> > wrote: > >> Sorry, here are the missing details, if it helps: >

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

member, it's all about I/O. The 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 mail

Re: [GENERAL] WAL Archive command.

ow you have to deal 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] Veritas cluster management

o 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] 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,

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

E-Mail ist vertraulich 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] Logging at schema level

arse reports for each individual 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

Re: [GENERAL] Strange case of database bloat

s to do its work. >> > > 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 <wmo...@potentialtech.com> >> > > > > -- > 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] 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

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

ott > > > *Regards, * > > > > *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&g

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

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] GENERAL : [Can somebody explain about Base directory]

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

Re: [GENERAL] Recover PostgreSQL database folder data

o 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] Re: Causeless CPU load waves in backend, on windows, 9.5.5 (EDB binary).

; 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@postgresql.org)

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

new installation and only install the differences. -- -- Scott Mead Sr. Architect *OpenSCG <http://openscg.com>* http://openscg.com

Re: [GENERAL] Er Data Modeller for PostgreSQL

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://www.postgres

Re: [GENERAL] Disabling inheritance with query.

inkages, not to mention attribute 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] 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

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

t; 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 fine. Remove the exclusive

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

: > > " ... > 2. After 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 > confid

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

erated 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, MySQL, InterBase, Nexu

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

down 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: [SPAM] [GENERAL] psql 9.3 automatic recovery in progress

kend for you in one 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] Graphical entity relation model

.ca/page/architect > Best regards Johannes -- -- Scott Mead Sr. Architect *OpenSCG <http://openscg.com>* http://openscg.com

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

gt; libaio.so.1 => /lib/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 P

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

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 > res

Re: [GENERAL] Uber migrated from Postgres to MySQL

ewhere 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] pasting a lot of commands to psql

On Thu, Jul 7, 2016 at 1:39 PM, Scott Mead <sco...@openscg.com> wrote: > > > On Thu, Jul 7, 2016 at 1:30 PM, Dmitry Shalashov <skau...@gmail.com> > wrote: > >> Hi Sameer, >> >> I am trying to copy-paste (and execute) random snippets of SQL to psql

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

t 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] 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

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

t; Andreas > > > -- > 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

is recovery.conf. --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: [GENERAL] Checkpoint Err on Startup of Rsynced System

uous-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

Re: [GENERAL] postgresql embedded mode

of this might be easier if you 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 *

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

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 /

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

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

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 <j...@commandprompt.com> wrote: > >> On 01/27/2016 03:37 PM, Ivan Voras wrote: >> >> >> On 28 Ja

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

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

estination || ' 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://openscg.com > Peter

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

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

to be careful 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 Exp

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:

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 >

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

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

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

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

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.

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

t; >> On Wed, Oct 21, 2015 at 1:43 PM, Scott Mead <sco...@openscg.com> wrote: >> >> > On Oct 21, 2015, at 12:28, Adrian Klaver <adrian.kla...@aklaver.com> wrote: >> > >> >> On 10/21/2015 09:14 AM, anj patnaik wrote: >> >> Ok, i am tr

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

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

Re: [GENERAL] question

format. >> >> Is there a recommended 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

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

Re: [GENERAL] Creating Report for PieChart

On Tue, Oct 13, 2015 at 9:14 PM, Scott Mead <sco...@openscg.com> wrote: > > > On Oct 13, 2015, at 19:56, Alex Magnum <magnum11...@gmail.com> wrote: > > Hello, > I need to process some statistics for a pie chart (json) where I only want > to show a max of 8 slices

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

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

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

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

Re: [GENERAL] How to reduce pg_dump backup time

s. *Much* faster. 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. Archi

Re: [GENERAL] PG V9 on NFS

On Mon, Feb 11, 2013 at 5:22 PM, Gauthier, Dave dave.gauth...@intel.comwrote: 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

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

* 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-stored passwords to LDAP, we open a security problem that currently

Re: [GENERAL] OpenSCG 9.0.10 package

Hey Ian, On Thu, Oct 11, 2012 at 10:52 AM, Ian Harding harding@gmail.com wrote: I know this is the wrong place, but I tried creating an account on their site to contact them and it does not work. I'll take a look at that right away, sorry it happened! The 9.0.10 package throws an

Re: [GENERAL] Visualize database schema

On Tue, Aug 14, 2012 at 5:24 AM, Robert Gravsjö robert.grav...@imano.sewrote: Can anyone advice about a tool to visualize a database schema? Ideally, I would like something that takes the SQL definition of a schema or database (essentially the output of pg_dump) and produces a graphical

Re: [GENERAL] Two instances show same databases

On Wed, Apr 18, 2012 at 7:45 PM, Jose Hales-Garcia jose.halesgar...@stat.ucla.edu wrote: Hello, I'm setting up a second instance on a server. The instance versions are 8.3.5 (original instance) and 9.1.3 (the new instance I'm attempting to set up). I believe I have followed the steps in

Re: [GENERAL] Why warm-standby doesn't work using file-based log shipping method?

On Tue, Feb 21, 2012 at 5:09 AM, sunpeng blueva...@gmail.com wrote: I try to setup warm-standby using file-based log shipping method: Master: 5432 port Standby:6432 port at same machine Master's : - wal_level = archive - archive_mode = on - archive_command = 'cp %p

Re: [GENERAL] Database system identifier via SELECT?

On Thu, Dec 8, 2011 at 4:27 PM, Bruce Momjian br...@momjian.us wrote: Joshua D. Drake wrote: On 12/08/2011 12:57 PM, Bruce Momjian wrote: Chris Redekop wrote: Is there any way to get the database system identifier via a select statement? I have a primary/secondary async

Re: [GENERAL] Extending the volume size of the data directory volume

On Wed, Nov 30, 2011 at 4:19 PM, panam pa...@gmx.net wrote: Had to restart the import. This time, I tried with a smaller initial disk size (1GB) and extended it dynamically. It did not cause any problems. A different reason might be, that I remounted the volume in between during the last

Re: [GENERAL] Recommended Protocol: Adding Rows to Table

On Fri, Nov 25, 2011 at 11:05 AM, Rich Shepard rshep...@appl-ecosys.comwrote: The data originated in a spreadsheet and, based on my experience, contains duplicate records. After reformatting there are 143,260 rows to insert in the table. The approach I tried seems to have problems (explained

Re: [GENERAL] Installed. Now what?

On Sun, Nov 20, 2011 at 6:21 AM, Marko Kreen mark...@gmail.com wrote: On Sun, Nov 20, 2011 at 8:32 AM, Phoenix Kiula phoenix.ki...@gmail.com wrote: The password I am entering in the terminal is right for sure. I've tried it a few times, checked the caps lock, etc. Also, if the log carries

Re: [GENERAL] Using the internal data dictionary

, but knowing pg_catalog is a great way to step-it-up. -- Scott Mead OpenSCG, http://www.openscg.com - Bill On 11/17/2011 8:34 PM, David Johnston wrote: On Nov 17, 2011, at 22:17, Bill Thoen bth...@gisnet.com bth...@gisnet.com wrote: I need to assemble a complete data dictionary

Re: [GENERAL] monitoring sql queries

On Thu, Nov 17, 2011 at 11:46 AM, Tomas Vondra t...@fuzzy.cz wrote: On 17 Listopad 2011, 17:32, hubert depesz lubaczewski wrote: On Thu, Nov 17, 2011 at 09:29:11AM -0700, J.V. wrote: I am in need of a tool or method to see each/every SQL query that hits the PostgreSQL database. By query I

Re: [GENERAL] monitoring sql queries

On Thu, Nov 17, 2011 at 4:32 PM, J.V. jvsr...@gmail.com wrote: How is this accomplished? Is it possible to log queries to a table with additional information? 1) num rows returned (if a select) This isn't logged 2) time to complete the query This is logged 3) other info? Take a

[GENERAL] Re: [GENERAL] Need Help Installing Dblink…(Desperately…)

On Sat, Nov 12, 2011 at 1:02 PM, Jerry Levan jerry.le...@gmail.com wrote: I think I have somehow botched my installation of 9.1.1 on Mac OSX 10.7.2 I have a mac running 9.1.1. I then built dblink from the contrib directory and I did not see an install option in the make file. The

Re: [GENERAL] Regarding the shared disk fail over cluster configuration

. You will corrupt your entire database. The only way to run postgres with shared disk clustering is in Active/Passive mode. -- Scott Mead OpenSCG http://www.openscg.com Thanks, Debasis -- View this message in context: http://postgresql.1045698.n5.nabble.com/Regarding-the-shared-disk-fail

Re: [GENERAL] Error On Slony Replication

not translate host name If you want to connect to an instance on the local machine with unix sockets, don't include the host= -- Scott Mead OpenSCG http://www.openscg.com The host is missing from the above. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgsql

Re: [GENERAL] Server hitting 100% CPU usage, system comes to a crawl.

On Thu, Oct 27, 2011 at 2:39 PM, Brian Fehrle bri...@consistentstate.comwrote: Hi all, need some help/clues on tracking down a performance issue. PostgreSQL version: 8.3.11 I've got a system that has 32 cores and 128 gigs of ram. We have connection pooling set up, with about 100 - 200

Re: [GENERAL] Extraneous Files

On Thu, Oct 20, 2011 at 1:12 PM, Ian Harding harding@gmail.com wrote: If someone happened to accidentally end up with a lot of files that were NOT part of their database in the data/base/X directory, how could they go about getting a reliable list of files they could safely delete?

Re: [GENERAL] pg_dump with select command

On Wed, Sep 14, 2011 at 5:31 AM, Adarsh Sharma adarsh.sha...@orkash.comwrote: Any update on below issue. Someone already responded to you with the answer, don't top-post. Thanks Adarsh Sharma wrote: Dear all, Today I need some part ( subset ) of some tables to another database to a

Re: [GENERAL] COPY failure on directory I own

On Tue, Aug 30, 2011 at 1:20 PM, Scott Ribe scott_r...@elevated-dev.comwrote: On Aug 30, 2011, at 11:14 AM, Rich Shepard wrote: The permissions on that directory are 755 and it's owned by me. Since I have no problems writing other files to that directory I must have the command syntax

Re: [GENERAL] Indexes on inheriting tables

2011/8/24 Ondrej Ivanič ondrej.iva...@gmail.com Hi, On 25 August 2011 11:17, Toby Corkindale toby.corkind...@strategicdata.com.au wrote: Do I need to make sure I re-create every index on every child table I create? That would be.. annoying, at best. Yes, it is little bit annoying but

Re: [GENERAL] dblink() from GridSQL

On Thu, May 5, 2011 at 1:40 PM, Merlin Moncure mmonc...@gmail.com wrote: On Thu, May 5, 2011 at 12:13 PM, Sam Nelson s...@consistentstate.com wrote: Hi List, We have a customer who is trying to migrate a few PostgresPlus instances to GridSQL clusters. They have a process that pulls data

Re: [GENERAL] pg_reorg

On Tue, Apr 19, 2011 at 9:48 AM, Jens Wilke j...@wilke.org wrote: On Tue, Apr 19, 2011 at 04:02:01AM +0530, Vibhor Kumar wrote: IIRC vacuum full mode rewrites the indexes as well. Till 8.4 no. From 9.0 onwards yes. However VACUUM FULL still locks the table. Don't be confused with the

Re: [GENERAL] pg_reorg

On Mon, Apr 18, 2011 at 4:39 PM, Merlin Moncure mmonc...@gmail.com wrote: ...is an amazing tool! I've seen it, but catalog hacks always make me nervous. Anybody else have good / bad experience to share? --scott merlin -- Sent via pgsql-general mailing list

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

On Wed, Mar 2, 2011 at 11:07 AM, Hannes Erven han...@erven.at 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

Re: [GENERAL] Tablespace Issue

On Thu, Feb 17, 2011 at 4:08 AM, Adarsh Sharma adarsh.sha...@orkash.comwrote: 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:

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 schmi...@gmail.com 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

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

On Mon, Nov 15, 2010 at 10:03 AM, Vick Khera vi...@khera.org wrote: On Mon, Nov 15, 2010 at 5:15 AM, Willy-Bas Loos willy...@gmail.com 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

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

On Tue, Nov 16, 2010 at 10:25 PM, Tom Lane t...@sss.pgh.pa.us 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

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

On Wed, Nov 17, 2010 at 10:38 AM, Scott Mead sc...@scottrmead.com wrote: On Tue, Nov 16, 2010 at 10:25 PM, Tom Lane t...@sss.pgh.pa.us 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

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

On Wed, Nov 17, 2010 at 12:49 PM, Josh Berkus j...@agliodbs.com 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

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

On Tue, Nov 16, 2010 at 7:21 PM, Glen Parker glene...@nwlink.com 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

Re: [GENERAL] port warded (iptables) postgres

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

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

On Tue, Nov 16, 2010 at 8:15 PM, Tom Lane t...@sss.pgh.pa.us wrote: Scott Mead sc...@scottrmead.com 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

Re: [GENERAL] creating a table based on a table in stored in another database

On Tue, May 18, 2010 at 4:45 AM, Malm Paul paul.m...@saabgroup.com wrote: I can add that I would like to do this in my java application. E.i. just create an empty table in database1 which has the same column names and types as a table stored in database2. I tried this for a start: stmnt =

  1   2   3   >