Re: [GENERAL] Postgres 10.1 fails to start: server did not start in time

On 11/10/2017 01:01 PM, Adam Brusselback wrote: >> You might want to increase pg_ctl's wait timeout for this situation, >> since the default's evidently too little. However ... > Got it, thanks. > >> ... pg_ctl itself wouldn't decide to forcibly shut down the server >> if the timeout expired.

Re: [GENERAL] [HACKERS] OpeSSL - PostgreSQL

On 11/09/2017 05:52 PM, chiru r wrote: > If OpenSSL apply any patches at OS level, Is there any > changes/maintenance we need to perform at PostgreSQL end? > > On Thu, Nov 9, 2017 at 5:46 PM, Joe Conway wrote: >> Assuming you mean that you need only FIPS 140-2 compliant ciphers,

Re: [GENERAL] [HACKERS] OpeSSL - PostgreSQL

On 11/09/2017 01:59 PM, chiru r wrote: > I am using PostgreSQL version *9.5.7* on Red hat enterprise Linux *7.2.* > > *OpenSSL version : * OpenSSL 1.0.1e-fips 11 Feb 2013. > > I have a requirement to enable the SSL in my environment with specific > cipher suites,we want to restrict weak cipher

Re: [GENERAL] How to find out extension directory

On 10/20/2017 02:10 PM, Tom Lane wrote: > "David G. Johnston" writes: >> On Fri, Oct 20, 2017 at 1:12 PM, rakeshkumar464 >> wrote: >>> How do I know beforehand where the dir path is ? > >> I think pg_config ( >>

Re: [GENERAL] Audit based on role

n you can do something like: SELECT ro.rolname, ro.rolcanlogin, ro.rolparents FROM roletree ro WHERE 'module_dml' = ANY (rolparents); rolname | rolcanlogin |rolparents -+-+-- bob | t | {module_dml,joe} joe | t | {module_dml} (2 rows

Re: [GENERAL] Audit based on role

On 08/07/2017 04:47 PM, anand086 wrote: > Only Insert/Update/Delete sqls are to be audited. You could get close to what you want, I think, by setting log_statement = mod for the users of interest, e.g. by doing: ALTER USER whomever SET log_statement = mod; See:

Re: [GENERAL] Limiting DB access by role after initial connection?

On 06/09/2017 02:16 PM, Ken Tanzer wrote: > FWIW, it would be clearer at least to me if you took the two statements > in the description: > > * log_statement setting is set to "all", meaning every SQL statement > executed while in this state will also get logged. > * If

Re: [GENERAL] Limiting DB access by role after initial connection?

On 06/09/2017 08:56 AM, Ken Tanzer wrote: > On Fri, Jun 9, 2017 at 6:42 AM, Joe Conway wrote: > See set_user for a possible solution: https://github.com/pgaudit/ > > Thanks! Looking at the README, it seems like the intended use case is > the opposite (escalating privil

Re: [GENERAL] Limiting DB access by role after initial connection?

On 06/08/2017 10:37 PM, Ken Tanzer wrote: > My approach was to have the initial connection made by the owner, and > then after successfully authenticating the user, to switch to the role > of the site they belong to. After investigation, this still seems > feasible but imperfect. Specifically, I

Re: [GENERAL] Unable to connect to Postgresql

On 04/09/2017 12:37 PM, John Iliffe wrote: >> > Thanks Joe. I Changed the pg_connect line in the script to: >> > $db_handle = pg_connect('dbname=yrarc host=192.168.1.6 port=5432 >> > user= password=xx'); > If I may be permitted a rant at this point, the Fedora documentation is >

Re: [GENERAL] Unable to connect to Postgresql

On 04/09/2017 11:33 AM, John Iliffe wrote: > On Saturday 08 April 2017 18:10:35 Joe Conway wrote: >> On 04/08/2017 01:23 PM, John Iliffe wrote: >> > On Saturday 08 April 2017 09:38:07 Adrian Klaver wrote: >> >> So what if you change the connection to use -h localh

Re: [GENERAL] Unable to connect to Postgresql

On 04/08/2017 01:23 PM, John Iliffe wrote: > On Saturday 08 April 2017 09:38:07 Adrian Klaver wrote: >> So what if you change the connection to use -h localhost? > > Can you please expand on that request? I'm not sure where you want me to > put that directive. I'm using the mod_php module in

Re: [GENERAL] Unable to connect to Postgresql

On 04/08/2017 06:31 AM, John Iliffe wrote: > On Saturday 08 April 2017 00:10:14 Adrian Klaver wrote: >> On 04/07/2017 07:45 PM, Joe Conway wrote: >> > On 04/07/2017 05:35 PM, Adrian Klaver wrote: >> >> On 04/07/2017 05:03 PM, John Iliffe wrote: >> >

Re: [GENERAL] Unable to connect to Postgresql

On 04/07/2017 05:35 PM, Adrian Klaver wrote: > On 04/07/2017 05:03 PM, John Iliffe wrote: Running on Fedora 25 with SELinux in PERMISSIVE mode. The audit log shows no hits on Postgresql. >> My going in position was/still is, that this is a SELinux security >> problem >> but I am

Re: [GENERAL] PostgreSQL and Kubernetes

On 03/31/2017 01:58 AM, Moreno Andreo wrote: > Il 30/03/2017 14:38, Vick Khera ha scritto: >> >> On Thu, Mar 30, 2017 at 6:10 AM, Moreno Andreo >> > wrote: >> >> Since I'm on Google Cloud Platform, I thought it would be a good >>

Re: [GENERAL] Conferences for a DBA?

On 02/27/2017 03:25 PM, Nathan Stocks wrote: > What worthwhile conferences should a PostgreSQL DBA consider going to? > > There have been some good sessions at OSCON in the past, but I was > wondering about more DBA-specific events. In North America the bigger ones are:

Re: [GENERAL] Recursive row level security policy

On 12/17/2016 02:04 PM, Stephen Frost wrote: > Note that RLS won't be applied for the table owner either (unless the > relation has 'FORCE RLS' enabled for it), so you don't have to have > functions which are run as superuser to use the approach Joe > recommended. Good point, thanks, I should

Re: [GENERAL] Recursive row level security policy

On 12/17/2016 01:01 PM, Simon Charette wrote: > Thanks a lot Joe, that seems to work! Good to hear. > I suppose this works because PostgreSQL cannot introspect the > get_owner_id procedure to detect it's querying the "accounts" table > and thus doesn't warn about possible infinite recursion?

Re: [GENERAL] Recursive row level security policy

On 12/16/2016 01:02 AM, Simon Charette wrote: > Unfortunately this will only return accounts matching the current_user's name. > > I would expect "SET ROLE foo; SELECT name FROM accounts" to return "foo" and > "bar" and not only "foo" like your proposed solution would do. Perhaps:

Re: [GENERAL] Backup "Best Practices"

On 11/23/2016 02:50 PM, Israel Brewster wrote: > On Nov 23, 2016, at 10:31 AM, John R Pierce > there's a tool, barman, I've never used but its supposed to greatly >> simplify this whole process... >> >> http://www.pgbarman.org/ > > Definitely looks like something to try.

Re: [GENERAL] Uber migrated from Postgres to MySQL

On 07/28/2016 03:16 PM, Bruce Momjian wrote: > On Thu, Jul 28, 2016 at 12:35:23AM -0700, Jeff Janes wrote: >> On Wed, Jul 27, 2016 at 9:48 PM, John R Pierce wrote: >>> On 7/27/2016 9:39 PM, Jeff Janes wrote: That depends on how how many objects there are consuming

Re: [GENERAL] CStringGetTextDatum and other conversions in server-side code

On 03/02/2016 04:20 PM, da...@andl.org wrote: > (please do not post HTML to these lists; see: > https://wiki.postgresql.org/wiki/Mailing_Lists) > [dmb>] I checked the list first: it looks like about 25-50% HTML. > Happy to oblige, but I think you've got your work cut out. Understood, but you

Re: [GENERAL] CStringGetTextDatum and other conversions in server-side code

(please do not post HTML to these lists; see: https://wiki.postgresql.org/wiki/Mailing_Lists) On 03/02/2016 03:06 PM, da...@andl.org wrote: > Writing a language handler: pl_language_handler. Need to do a variety of > data conversions. One of them is char* C-string to and from Text/Varchar. > >

Re: [GENERAL] RLS on catalog tables would be helpful

On 03/02/2016 12:14 PM, Julien Rouhaud wrote: > On 02/03/2016 20:56, Joe Conway wrote: >> I thought there was once a link somewhere on the mail archives to get a >> specific email resent, but for the life of me I cannot find it today :-/ >> > > It's only available in ma

Re: [GENERAL] RLS on catalog tables would be helpful

On 03/02/2016 11:53 AM, Joshua D. Drake wrote: > On 03/02/2016 11:37 AM, Joe Conway wrote: > >> http://www.postgresql.org/message-id/flat/CA+Tgmoa=4vti1hb1hta0+qbzlojkpjbd5dkvw3zmp-kdwje...@mail.gmail.com#CA+Tgmoa=4vti1hb1hta0+qbzlojkpjbd5dkvw3zmp-kdwje...@mail.gmail.com >> &

Re: [GENERAL] RLS on catalog tables would be helpful

On 03/02/2016 11:29 AM, Alan Droege wrote: > I have removed SELECT rights from the pg_proc.prosrc column so that > I can hide the source code of stored functions. This is working OK, > however I would really like to just hide certain functions via RLS. > I understand that great damage could be

Re: [GENERAL] Privileges granted on dblink extension function do not survive database dump and restore

On 02/26/2016 07:12 AM, David G. Johnston wrote: > pg_dump emits a "CREATE EXTENSION" statement to the dump file and then > pg_restore executes the "CREATE EXTENSION". None of the actual schema > objects are dumped and thus any changes to those objects in the current > database, including their

Re: [GENERAL] Privileges granted on dblink extension function do not survive database dump and restore

On 02/25/2016 03:42 PM, Bryan Ellerbrock wrote: > Hi, I'm first time mailing-list user with a problem. I'm working on a > UTF8 encoded database using psql (9.5.1, server 9.4.6) > > I've implemented a very large materialized view to speed up certain > search queries. I need to give users the

Re: [GENERAL] Failing to known state

On 01/05/2016 04:32 PM, John R Pierce wrote: > On 1/5/2016 4:12 PM, oleg yusim wrote: >> I meant a scenario, when user is trying to connect to database >> (doesn't matter what interface) and database fails at this moment. If >> all authentication/authorization/validation functions are written to

Re: [GENERAL] Efficiently Triggering Autovacuum Analyze?

On 12/30/2015 11:09 AM, Cory Tucker wrote: > We have a performance problem accessing one of our tables, I think > because the statistics are out of date. The table is fairly large, on > the order of 100M rows or so. > The fix I have employed to restore the speed of the query after I notice > it

Re: [GENERAL] dblink_connect fails

On 12/16/2015 04:53 PM, James Sewell wrote: > No it is not. > > Just in case I tried setting it to 'postgres', logged in without -U > (doesn't work without PGUSER set) and tried the operation again. > > DETAIL: FATAL: role "PRDSWIDEGRID01$" does not exist That "PRDSWIDEGRID01$" is

Re: [GENERAL] Fwd: dblink_connect fails

17 December 2015 > Subject: dblink_connect fails > To: Joe Conway <m...@joeconway.com <mailto:m...@joeconway.com>> > > > On Thu, Dec 17, 2015 at 12:11 PM, Joe Conway <m...@joeconway.com > <javascript:_e(%7B%7D,'cvml','m...@joeconway.com'

Re: [GENERAL] dblink_connect fails

On 12/15/2015 06:24 PM, James Sewell wrote: > I have a Windows PostgreSQL server where dblink_connect fails to pick up > the current user as follows: > ffm=# SELECT dblink_connect('master', 'dbname=ffm'); > ERROR: could not establish connection > DETAIL: FATAL: role

Re: [GENERAL] Unable to select a table as postgres user

On 10/30/2015 10:27 AM, rajan wrote: > The function is created as postgres user. > > And I get a permission denied error. If you want help solving this, I suggest you post a minimal, self contained test case (i.e. SQL statements) which anyone can run to reproduce your issue. HTH, Joe --

Re: [GENERAL] Configure with Openssl fails

On 10/21/2015 07:31 AM, Michael Hartung wrote: > being on OS X 10.11 (El Capitain) and trying a VPATH build with plain > "configure" and "make" works fine. > > /Users/me/Documents/workspace/postgres/configure --with-openssl > --with-includes=/usr/local/ssl/include/openssl >

Re: [GENERAL] postgres function

On 10/15/2015 07:05 AM, Ramesh T wrote: > '123-987-123' it is not fixed some times it may be '1233-9873-123-098' > as you said it's fixed, > > changes the values in middle of the - > > sometimes times i need 1233 and 098 or 9873,first position i'll find > direct for second variable we don't

Re: [GENERAL] Very puzzling sort behavior

On 09/10/2015 03:03 PM, Andrew Sullivan wrote: > On Thu, Sep 10, 2015 at 02:54:31PM -0700, Ken Tanzer wrote: >> Thanks, but I guess I should have been clearer. Thanks to y'all wonderful >> mailing list folks, I get it now as to why the two sorts are not the same. >> I'm hoping for practical

Re: [GENERAL] Any experiences running PostgreSQL 9.3.5 on compressed Btrfs on Linux?

://no0p.github.io/postgresql/2014/09/06/benchmarking-postgresql-btrfs-zlib.html Joe - -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support -BEGIN PGP SIGNATURE- Version: GnuPG v1

Re: [GENERAL] Pairwise array sum aggregate function?

, Joe - -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support -BEGIN PGP SIGNATURE- Version: GnuPG v1 Comment: Using GnuPG with Thunderbird - http://www.enigmail.net

Re: [GENERAL] arrays of rows and dblink

- --- {(1,\2014-04-30 00:00:00\,a),(2,\2014-04-29 00:00:00\,b)} (1 row) HTH, Joe - -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support

Re: [GENERAL] Return and sql tuple descriptions are incompatible

. In other words, help us help you. Joe - -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.14 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http

Re: [GENERAL] Return and sql tuple descriptions are incompatible

); warehousename | p_279140414 | p_279140421 - ---+-+- OFFICE| 10 | STORE2| 45 | 10 (2 rows) HTH, Joe - -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open

Re: [GENERAL] Optimizing CartoDB's JenksBins function

optimizations? Not exactly what you asked, but you might try PL/R with the R classInt package: http://cran.at.r-project.org/web/packages/classInt/classInt.pdf HTH, Joe - -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7

Re: [GENERAL] How can I correctly handle sparse crosstabs?

/3rds down the page. HTH, Joe - -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.14 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net

Re: [GENERAL] levenshtein_less_equal does not work

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/24/2014 12:50 PM, alexandros_e wrote: For some reason levenshtein_less_equal does not work, Define does not work, i.e. cut and paste exact SQL and output so we can see and reproduce your issue. Joe - -- Joe Conway credativ LLC: http

Re: [GENERAL] levenshtein_less_equal does not work

- -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.14 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net

Re: [GENERAL] levenshtein_less_equal does not work

levenshtein_less_equal List of functions Schema | Name | Result data type | Argument data types | Type +--+--+-+-- (0 rows) routing_nw2=# Hmm, can we see: \dx and \df levenshtein* Joe - -- Joe Conway credativ LLC: http://www.credativ.us Linux

Re: [GENERAL] levenshtein_less_equal does not work

and distance between strings plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language (2 rows) Joe - -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support -BEGIN PGP SIGNATURE- Version: GnuPG

Re: [GENERAL] levenshtein_less_equal does not work

). But your method works too ;-) Joe - -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.14 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http

Re: [GENERAL] Question(s) about crosstab

list until query execution time, which I also doubt is possible. Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] Question(s) about crosstab

On 12/18/2013 05:14 PM, John Abraham wrote: On Dec 18, 2013, at 3:52 PM, Joe Conway m...@joeconway.com wrote: 3) Not possible -- reason was given down thread. Column definition must be known/determinable by the parser prior to query execution. No, wait, I think you misunderstood my idea

Re: [GENERAL] Using PL/R with 9.3beta2

://github.com/jconway/plr Joe - -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.12 (GNU/Linux) Comment: Using GnuPG with undefined - http://www.enigmail.net

Re: [GENERAL] search_path for database vs user vs session

to foobar; select * from pg_db_role_setting ; setdatabase | setrole | setconfig - -+-+-- 0 | 16401 | {search_path=bar} 16384 | 0 | {search_path=foobar} (2 rows) Is that what you are looking for? HTH, Joe - -- Joe Conway credativ

Re: [GENERAL] problem with lost connection while running long PL/R query

a cursor. Not all forms of analysis lend themselves to these approaches, but perhaps yours does. Ultimately I would like to implement a form of R data.frame that does the paging with a cursor transparently for you, but I have not been able to find the time so far. Joe - -- Joe Conway credativ

Re: [GENERAL] PL/R etc.

transparently beneath the dataframe object, but have not gotten around to it. Apparently the Oracle connector to R is able to do that, so I'm sure it is a SMOP. Joe - -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7

[GENERAL] SCALE goes to 11, and so does PostgreSQL!

hall, all Saturday/Sunday speaker tracks, and evening events (excludes the Linux Training Class). Schedule: http://www.socallinuxexpo.org/scale11x/schedule/friday Register: https://reg.socallinuxexpo.org/reg6/ -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open

Re: [GENERAL] evaluating expressions stored in table

://www.joeconway.com/presentations/LISA2012-PredSrvAnalytics.pdf beware sql injection. good point! Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] crosstab

. But certainly if you can do all your work on the reshaped table within the R environment, PL/R will be easier to use. Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support -- Sent via pgsql-general mailing

Re: [GENERAL] crosstab

in the result, and therefore it needs you to provide a column definition either at function creation time (via OUT params or by explicit composite return type) or at execution time via AS(...) clause. Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source

Re: [GENERAL] crosstab

convenient if your goal is to get a CSV file in the end anyway. Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] crosstab

along with the basic experimental info. Then later if you pass the serialized object back into another PL/R function as a bytea argument, it gets reconstituted as the original R object. Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service

Re: [GENERAL] crosstab

interpreter when R is first initialized. http://www.joeconway.com/plr/doc/plr-module-funcs.html Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] need substring based on delimiter

( ( string_to_array ( 'aaa,bbb,ccc,ddd,eee,fff,ggg',',' ) )[1:3],',' ); array_to_string - aaa,bbb,ccc (1 row) HTH, Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service

Re: [GENERAL] PLR Help

. Assuming it is in the above location, place that location in your /etc/ld.so.conf and run ldconfig. HTH, Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] PLR Help

On 05/02/2012 10:59 AM, Joe Conway wrote: First, go find lib.R.so. Assuming it is in the above location, place ^-- oops, I meant libR.so Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7

Re: [GENERAL] PL/R install, no pgxs available

that the R development package is missing as well (needed for R headers and libR.so I believe...) Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support -- Sent via pgsql-general mailing list (pgsql-general

[GENERAL] Southern California PostgreSQL Day

details see: http://www.socallinuxexpo.org/scale10x/events/los-angeles-postgresql-day Hope to see you there! Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support -- Sent via pgsql-general mailing list (pgsql

[GENERAL] PGDay.SoCal @ SCALE 10X

-- Regards, Joe Conway Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug San Diego PostgreSQL Users Group (SDPUG) http://www.meetup.com/SD-PUG/ -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting

[GENERAL] PGDay.SoCal @ SCALE 10X

This message has been digitally signed by the sender. _GENERAL__PGDay_SoCal___SCALE_10X.eml Description: Binary data - Hi-Tech Gears Ltd, Gurgaon, India -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

[GENERAL] Call For Talks: PGDay.SoCal @ SCALE 10X

Name *Speaker Bio *E-mail *Cell Phone *Title of Talk *Description of Talk *Notes for Committee For more information visit: https://sites.google.com/site/pgdayla/ -- Regards, Joe Conway Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug San Diego

Re: [GENERAL] Mac OS X shared_buffers not same as postgresql.conf file

'; setting - 4096 (1 row) postgres=# select 4096 * 8 / 1024 as MB; mb 32 (1 row) HTH, Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] create table as select... with auto increment id ?

setval('twserid_id_seq', (select max(id) from like_twserid)); HTH, Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] Finding Errors in .csv Input Data

+-+-+ 1 | testing 123,456 | hello world | 42 (1 row) HTH, Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support signature.asc Description: OpenPGP digital signature

Re: [GENERAL] Subquery for column names of tablefunc crosstab queries

| test3 ||| 49 (3 rows) --- You might need some adjustments to get this to do exactly what you want. Also please test it for correctness ;-) HTH, Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL

Re: [GENERAL] Subquery for column names of tablefunc crosstab queries

-03-02 | 2003-03-03 ---+++ test1 | 42 || test2 || 53 | test3 ||| 49 (3 rows) HTH, Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source

Re: [GENERAL] dblink_get_result issue

response. I think this issue was fixed by that patch only as a side effect of significant restructuring. The attached one liner against 8.4 seems to fix it. Objections? Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting

Re: [GENERAL] The first dedicated PostgreSQL forum

with sipx-us...@list.sipfoundry.org Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support signature.asc Description: OpenPGP digital signature

Re: [GENERAL] Libpq is very slow on windows but fast on linux.

platforms. Just a guess, but maybe DNS lookup time? Try using IP address instead of FQDN. HTH, Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support signature.asc Description: OpenPGP digital signature

Re: [GENERAL] Problem with Crosstab (Concatenate Problem)

) HTH, Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support signature.asc Description: OpenPGP digital signature

Re: [GENERAL] Database INNOVATION

is available via PL/R as well. See: http://cran.r-project.org/web/views/gR.html Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support signature.asc Description: OpenPGP digital signature

Re: [GENERAL] Problem with Crosstab - Allocating value to wrong column

to specific categories of data, and some groups might not have data for some of the categories, that doesn't work well. The two-parameter form of crosstab handles this case by providing an explicit list of the categories corresponding to the output columns. HTH, Joe -- Joe Conway credativ

Re: [GENERAL] return setof : alternatives to holder table

a := 1; b := 2; return next; end; $pgsql$ language plpgsql; contrib_regression=# select * from te(); a | b ---+--- 1 | 2 (1 row) HTH, Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support

Re: [GENERAL] Redirect sequence access to different schema

'); nextval - 2 (1 row) Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support signature.asc Description: OpenPGP digital signature

Re: [GENERAL] locating cities within a radius of another

a viable solution, or should I be looking at a different approach? Thanks for any suggestions or RTFM pointers. If you want something simple, and not requiring PostGIS, but plpgsql instead, see: http://archives.postgresql.org/pgsql-sql/2003-12/msg00193.php HTH, Joe -- Joe Conway credativ LLC: http

Re: [GENERAL] Create table if not exists ... how ??

better to do: DROP TABLE IF EXISTS post_codes; CREATE TABLE post_codes(...); See: http://www.postgresql.org/docs/8.4/interactive/sql-droptable.html HTH, Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support

Re: [GENERAL] Create table if not exists ... how ??

- Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support signature.asc Description: OpenPGP digital signature

Re: [GENERAL] Create table if not exists ... how ??

), and then create it anew - what if there is already data in the table? Read on -- we are way past that already... Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting, 24x7 Support signature.asc Description: OpenPGP digital

Re: [GENERAL] Fedora 13 killed dblink this week...

looks like your libldap and liblber are out of sync somehow. FWIW, I just tested on fedora 13 and sure enough, I started with the same error, and fixed it with a postgres restart. Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training

[GENERAL] San Diego PostgreSQL Users Group - first meeting scheduled

there are a lot of PostgreSQL users in the San Diego metropolitan area, and getting a PUG going here is long overdue. Please join up, spread the word, and attend if you can! Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux, PostgreSQL, and general Open Source Training, Service, Consulting

Re: [GENERAL] Redundant database objects.

of the performance hit and rapidly growing log though. Another idea would be to modify a copy of 8.3.x source code (I think that's what you said you were on in an earlier post) to emit a NOTICE with a name whenever a function is called if it meets some criteria. Joe -- Joe Conway credativ LLC: http

Re: [GENERAL] Redundant database objects.

Is there an effective way to identify these objects using the stats tables? Something like a last accessed/used or some such column? Maybe pg_statio* views? http://www.postgresql.org/docs/8.3/interactive/monitoring-stats.html Joe -- Joe Conway credativ LLC: http://www.credativ.us Linux

Re: [GENERAL] C-functions using SPI Missing Magic Block Error

On 07/02/2010 08:13 AM, saitenhe...@web.de wrote: Thanks for reply Tom! I've tried several version: #define _USE_32BIT_TIME_T #include postgres.h #include fmgr.h #include executor\spi.h /* #ifdef PG_MODULE_MAGIC PG_MODULE_MAGIC; #endif */ but still the same error occurs. You

Re: [GENERAL] C-functions using SPI Missing Magic Block Error

On 07/02/2010 08:36 AM, saitenhe...@web.de wrote: Thanks, I've already tried that. I doesn't make any difference. Still the same error. in Visual C++ I can't even compile it, although I set all links and compiler directories like it was told in this post:

Re: [GENERAL] Query inside a C-Function

On 03/19/2010 12:26 PM, Enzo Cappa wrote: Hello! I have to make a c function for determining if some point its inside a set of elliptical geometries (I'm talking about a shared library, used like a function in the queries ). The geometries are defined in a table, so the function should

Re: [GENERAL] Many-to-many problem

On 03/18/2010 03:50 PM, Raymond O'Donnell wrote: I can do it easily enough for one user; my problem is doing it for all users in one fell swoop. I'm sure this is a very common problem, but I just can't see the solution, so any pointers would be greatly appreciated. Is this what you want?

Re: [GENERAL] select t.name from tbl t (where name is not a column name)

On 02/24/2010 07:16 AM, Igor Neyman wrote: Joe, What PG version are running? 8.2 here complains when running your example: ERROR: column foo.name does not exist LINE 6: select foo.name from foo; ^ ** Error ** ERROR: column foo.name does not exist

Re: [GENERAL] select t.name from tbl t (where name is not a column name)

On 02/23/2010 05:07 PM, raf wrote: i've just noticed the following behaviour and was wondering if there's any documentation to explain what it's for. create table tbl(id serial primary key, a text, b text, c text); insert into tbl(a, b, c) values ('abc', 'def', 'ghi'); insert into

[GENERAL] Anyone interested in a San Diego Postgres Users Group (SD-PUG)?

Anyone out there interested in a San Diego PostgreSQL Users Group? If so, I created a meetup here: http://www.meetup.com/SD-PUG/ Please sign up and contact me off list. Thanks, Joe signature.asc Description: OpenPGP digital signature

Re: [GENERAL] Performance Tuning - Any easy things that I can do ?

On 02/04/2010 10:32 AM, Scott Marlowe wrote: On Thu, Feb 4, 2010 at 8:54 AM, Wang, Mary Y mary.y.w...@boeing.com wrote: Hi, I restored my database. However, I noticed performance is poor as compared to before. Are there some easy things that I can do to improve the performance (besides

Re: [GENERAL] Is it necessary to have index for child table in following case?

On 02/03/2010 05:02 PM, Yan Cheng Cheok wrote: Are you using INSERT or COPY to insert your data? COPY tends to be a lot faster than separate INSERTs, especially if you don't wrap the INSERTs in a transaction block and COMMIT them in batches. But I do not use File or Stdio. The data is

  1   2   3   >