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

> > 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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: [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] Graphical entity relation model

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

/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] 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] 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] 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] 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] 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: 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] 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: [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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] [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] 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] 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] 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] 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] 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] 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] 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] 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] 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] .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] OpenSCG 9.0.10 package

Hey Ian, On Thu, Oct 11, 2012 at 10:52 AM, Ian Harding 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 error when I try to

Re: [GENERAL] Visualize database schema

On Tue, Aug 14, 2012 at 5:24 AM, Robert Gravsjö wrote: > > > 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 > representation of t

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

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

On Tue, Feb 21, 2012 at 5:09 AM, sunpeng 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 /home/postgres/archive/%f'

Re: [GENERAL] Database system identifier via SELECT?

On Thu, Dec 8, 2011 at 4:27 PM, Bruce Momjian 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 replic

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

On Wed, Nov 30, 2011 at 4:19 PM, panam 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 update to deac

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

On Fri, Nov 25, 2011 at 11:05 AM, Rich Shepard wrote: > 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 below) > and > I would

Re: [GENERAL] Installed. Now what?

On Sun, Nov 20, 2011 at 6:21 AM, Marko Kreen wrote: > On Sun, Nov 20, 2011 at 8:32 AM, Phoenix Kiula > 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 this "FATAL password authenticat

Re: [GENERAL] Using the internal data dictionary

---+- public | joe | table | scott | 8192 bytes | public | mike | table | scott | 8192 bytes | (2 rows) postgres=# It's a pretty quick way to get familiar with how the catalogs are structured. I agree that when it comes to 'getting things done', information_sch

Re: [GENERAL] monitoring sql queries

On Thu, Nov 17, 2011 at 4:32 PM, J.V. 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 look at th

Re: [GENERAL] monitoring sql queries

On Thu, Nov 17, 2011 at 11:46 AM, Tomas Vondra 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 mean

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

On Sat, Nov 12, 2011 at 1:02 PM, Jerry Levan 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 Makefile should be inc

Re: [GENERAL] Error On Slony Replication

bname=XYZ host= user=cls password=1) failed - could > > 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.

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

tion. DO NOT under ANY circumstances try to run both primary and secondary on the same data directory simultaneously. 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 > Tha

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

On Thu, Oct 27, 2011 at 2:39 PM, Brian Fehrle wrote: > 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 persistent connections ope

Re: [GENERAL] Extraneous Files

On Thu, Oct 20, 2011 at 1:12 PM, Ian Harding 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? The files were ther

Re: [GENERAL] pg_dump with select command

On Wed, Sep 14, 2011 at 5:31 AM, Adarsh Sharma wrote: > 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 >> remot

Re: [GENERAL] COPY failure on directory I own

On Tue, Aug 30, 2011 at 1:20 PM, Scott Ribe wrote: > 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 incorrect but I don't s

Re: [GENERAL] Indexes on inheriting tables

2011/8/24 Ondrej Ivanič > Hi, > > On 25 August 2011 11:17, Toby Corkindale > 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 I like it. You don't need any index > on parent

Re: [GENERAL] dblink() from GridSQL

On Thu, May 5, 2011 at 1:40 PM, Merlin Moncure wrote: > On Thu, May 5, 2011 at 12:13 PM, Sam Nelson > 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 from another > server > > using d

Re: [GENERAL] pg_reorg

On Tue, Apr 19, 2011 at 9:48 AM, Jens Wilke 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 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 (pgsql-general@postgresql.org) > To make

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] 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] 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] 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] 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] 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 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 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] 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 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] pg_restore to log file

On Tue, May 18, 2010 at 12:15 PM, Thom Brown wrote: > On 18 May 2010 17:11, akp geek wrote: > > pg_restore -h 10.xx.xx.xxx -d dbName -n schemaName -v -U postgres > > testDB_20100414.txt-f outputifile > > > > I got the following error "pg_restore: options -d/--dbname and -f/--file > > cann

  1   2   3   >