[GENERAL] pgadmin story...

2010-11-18 Thread andrew
hi all, I've just read that pgadmin team was hired by some company and the project will be closed... It was a post from 2009. I'm just curious what's the story behind that. Did anyone leave? thanks. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your s

Re: [GENERAL] pgadmin story...

2010-11-18 Thread andrew
Chris Browne wrote: andrew writes: hi all, I've just read that pgadmin team was hired by some company and the project will be closed... It was a post from 2009. I'm just curious what's the story behind that. Did anyone leave? thanks. Are you thinking about this annou

Re: [GENERAL] Full Text Search - i18n

2008-06-24 Thread Andrew
Re-reading the documentation, and I have the answer. If adding a tsvector column, then for per row selection, I should also add a second column of type regconfig to specify the language that rows contents are in. Cheers, Andy Andrew wrote: Apologies if this question has been previously

[GENERAL] Full Text Search - i18n

2008-06-24 Thread Andrew
Apologies if this question has been previously covered, but I was not able to find something similar in any of the mailing list archives. With full text search, if you need to support a table where the content of individual tuples/rows may be in different languages with the language of the con

[GENERAL] 0xc3 error Text Search Windows French

2008-06-25 Thread Andrew
I have a feeling that an issue I'm running into is related to this: http://archives.postgresql.org/pgsql-bugs/2008-06/msg00113.php On Windows XP running PgAdmin III 1.8.4 against either PostgreSQL 8.3.0 or 8.3.3 DB, when attempting to do a: select * from ts_debug('french', 'catalogue'); gett

Re: [GENERAL] 0xc3 error Text Search Windows French

2008-06-25 Thread Andrew
Sorry one last detail. All of my databases are in utf-8 format. My Windows XP is en_AU and defaults to ISO-8859-1 character sets. My postgresql.conf is set to the default for the client_encoding setting, which should then default to the database utf-8 format. Andrew wrote: One additional

Re: [GENERAL] 0xc3 error Text Search Windows French

2008-06-25 Thread Andrew
s, which I have not touched in anyway and it is also occurring with the portuguese catalogue. Cheers Andy Andrew wrote: I have a feeling that an issue I'm running into is related to this: http://archives.postgresql.org/pgsql-bugs/2008-06/msg00113.php On Windows XP running PgAdmin

[GENERAL] hibernate nativequery and uuid

2008-07-31 Thread Andrew
I'm currently using JPA with Hibernate as my ORM and have been able to convince hibernate to play nicely with the Postgresql UUID. Most of my queries have been in EJBQL using the JPA entity manager's createQuery. However when I try to do a UNION, JPA only returned the results of the first que

Re: [GENERAL] hibernate nativequery and uuid

2008-07-31 Thread Andrew
Yeah, tried that, but get the following: org.hibernate.MappingException: No Dialect mapping for JDBC type: Thanks for the suggestion though. Douglas McNaught wrote: On Thu, Jul 31, 2008 at 5:57 PM, Andrew <[EMAIL PROTECTED]> wrote: The only relevant thing I have been able t

Re: [GENERAL] hibernate nativequery and uuid

2008-07-31 Thread Andrew
iated though. A.M. wrote: On Jul 31, 2008, at 5:57 PM, Andrew wrote: I'm currently using JPA with Hibernate as my ORM and have been able to convince hibernate to play nicely with the Postgresql UUID. Most of my queries have been in EJBQL using the JPA entity manager's createQuery.

Re: [GENERAL] hibernate nativequery and uuid

2008-07-31 Thread Andrew
Oh, I see what you mean. Use EJBQL on a view. That would probably work. Have to get going, so will try that when I get back in several hours. I'll let you know how I go. Andrew wrote: I have given it consideration, but haven't tried it as I have concluded that I would still hav

Re: [GENERAL] hibernate nativequery and uuid

2008-08-01 Thread Andrew
oops, forgot to cc the mailing list again... Andrew wrote: I know none of this relates directly to postgresql and on reflection is probably more appropriate for the hibernate forums. So apologies for having raised the topic here. Also, thanks for the suggestions that I have received on the

Re: [GENERAL] Oracle and Postgresql

2008-09-25 Thread Andrew
For an alternative view of the security argument, which may be a little off topic... One consideration in regard to arguments for additional security, whether column and row level security or the divergent thread on obfuscated stored procedures is whether postgresql currently supports PCI (in

Re: [GENERAL] Adding Arabic dictionary for TSearch2.. to_tsvector('arabic'...) doesn't work..

2009-01-09 Thread Andrew
Hi Mohammed, See my answers below, and hopefully they won't lead you too far astray. Note though, it has been a long time since I have done this and there are doubtless more knowledgeable people in this forum who will be able to correct anything I say that may be misleading or incorrect. Ch

Re: [GENERAL] Adding Arabic dictionary for TSearch2.. to_tsvector('arabic'...) doesn't work..

2009-01-10 Thread Andrew
Mohamed wrote: Thank you for you detailed answer. I have learned alot more about this stuff now :) Your welcome :-) As I see it accordingly to the results it's between Hunspell and Aspell. My Aspell version is 0.6 released 2006. The Hunspell was released in 2008. When I run the Postgres c

Re: [GENERAL] INSERT OR UPDATE?

2005-10-09 Thread andrew
I think is almost the same that in many other languages, and like in many other with the time you can have function's libraries, or more likely class libraries with the usefull stuff. In desktop programming environments you have components, here you have classes that are the same thing using it in

[GENERAL] PostgreSQL 8.1 - SSL:Required

2006-10-02 Thread Andrew
Hi,I am using the binary install for postgresql 8.1 Win32 on Windows XP. I know how to intstall SSL if I was installing from source, --with-openssl, but I am installing onto Windows XP for the first time, so my question is: 1. How do I install the SSL module via the install wizard?Blessings Andrew

Re: [GENERAL] user defined function

2006-01-25 Thread andrew
I use 7.3 and use RECORD as the input data type of the function by "create function foo(record) returns int4 as '$libdir/bar' language C". But I got this error msg:" ERROR: parser: parse error at or near "record" at character". What is the problem? I look up the 7.3 manual. it seems record is a

Re: [GENERAL] user defined function

2006-01-25 Thread andrew
in Warn_restart code What is the problem here? Did you test it on 7.3? On 1/25/06, Tom Lane <[EMAIL PROTECTED]> wrote: > andrew <[EMAIL PROTECTED]> writes: > > I use 7.3 and use RECORD as the input data type of the function by > > "create function foo(record) re

Re: [GENERAL] user defined function

2006-01-25 Thread andrew
Function complete(person) does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts On 1/25/06, Tom Lane <[EMAIL PROTECTED]> wrote: > andrew <[EMAIL PROTECTED]> writes: > > ERROR: parser:

[GENERAL] filtering after join

2006-01-25 Thread andrew
les generated by the join operation. How can I do that? Thanks! -- andrew ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] user defined function

2006-01-25 Thread andrew
sorry, mistakenly leave out another try: backend> select *, complete(CAST (Person AS record)) from Person QUERY: select *, complete(CAST (Person AS record)) from Person ERROR: Relation reference "person" cannot be used in an expression On 1/25/06, andrew <[EMAIL PROTECTED]>

Re: [GENERAL] user defined function

2006-01-26 Thread andrew
Thanks, Tom. It is done by modifying coerce_type() and can_coerce_type(). The reason I have to keep to verson 7.3 is I am working on a research prototype that is built over pgsql 7.3. I need the extra functions provided by that prototype. On 1/25/06, Tom Lane <[EMAIL PROTECTED]> wrote: &g

[GENERAL] stateful UDF?

2006-02-14 Thread andrew
Hi Can I implement a stateful UDF in C? i.e. storing the state of the previous run of the function and access them in the succeeding runs. Is it supported? How do I implement it? Thanks. -- andrew ---(end of broadcast)--- TIP 4: Have you searched

Re: [GENERAL] stateful UDF?

2006-02-15 Thread andrew
this function is computed based on this information and the current input tuple. On 2/15/06, Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Tue, Feb 14, 2006 at 11:47:49PM +0100, andrew wrote: > > Can I implement a stateful UDF in C? i.e. storing the state of the > > previous ru

Re: [GENERAL] stateful UDF?

2006-02-15 Thread andrew
100, andrew wrote: > > Within the same query. The function takes a tuple as its input > > parameter. It will be used in the where clause. So I think it will be > > called one time for each read tuple, right? I want to maintain a > > structure to store the information about the tup

[GENERAL] disjunctive queries

2006-08-04 Thread andrew
Hi, What are the techniques used by PostgreSQL to optimize disjunctive queries? Treat every disjunct separately? Or special optimization is performed to save the cost? Could any one give me some general ideas? Thanks! -- andrew ---(end of broadcast

[GENERAL] pg_dump and circular dependency

2004-02-17 Thread andrew
Table A has a CHECK constraint testing boolean function F. Function F has a SELECT from Table A. In my manual build script, I create the table, then the function, and then at the very end of the script to I do an ALTER TABLE ADD CHECK. pg_dump appears to put the CHECK constraint as a clause in t

Re: [GENERAL] That movie

2003-08-20 Thread andrew
Please see the attached file for details. ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] Local Users "su'ing" (REPOST)

2000-08-26 Thread andrew
Hi, Don't think this made it the first time... Thanks, Andrew -- Forwarded message -- Date: Sat, 26 Aug 2000 15:45:55 +1000 (EST) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Local Users "su'ing" Hi, I'm running postgresql 7.0.2 under Free

Re: [GENERAL] table count limitation

2000-08-27 Thread andrew
, motor boats etc as you store different attributes. As postgresql is an OORBMS it should be able to handle it without any nasty squash into the relational model tricks. I've never used an OO database in production mind you...perhaps there is some catch I'm not aware of. Andrew

[GENERAL] Making changes visible to other connections

2000-10-09 Thread andrew
Hi, If I run an UPDATE operation from one connection the changed data is only visible form that connection. How do make the change visible from other connections? Do I have to wrap everything in a transaction? I'm using libpq if that makes a difference. Thanks, Andrew

[GENERAL] Making changes visible to other connections

2000-10-09 Thread andrew
Hi, If I run an UPDATE operation from one connection the changed data is only visible from that connection. How do make the change visible from other connections? Do I have to wrap everything in a transaction? I'm using libpq if that makes a difference. Thanks, Andrew

Re: [GENERAL] Basic Question on Point In Time Recovery

2015-03-11 Thread Andrew Sullivan
don't know whether Bucardo or Londiste (two alternative systems that work on roughly the same principle) have this functionality, but I kind of doubt it since both were designed to get rid of several of the complexities that Slony presented. (Slony had all those complexities because it w

Re: [GENERAL] Basic Question on Point In Time Recovery

2015-03-11 Thread Andrew Sullivan
ure it does the thing requested in this case. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Reg: PostgreSQL Server "base/data" recovery

2015-03-19 Thread Andrew Sullivan
corruption fixes since 9.0.4. You should always try to stay on the latest minor release of your version of Postgres. Best regards, A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.p

Re: [GENERAL] 9.4+ partial log-shipping possible?

2015-03-27 Thread Andrew Sullivan
ring and are > consuming by far the most disk space (still somewhat expensive on SSD)! This doesn't actually solve your problem, but you could mitigate the cost by putting those tables on spinning-rust disks using tablespaces or symlinks or whatever. Best regards, A -- Andrew Sullivan

[GENERAL] ecpg rejects input parameters

2015-04-08 Thread Andrew Pennebaker
":db" Is there a flag I can give to ecpg to ignore input parameters? Is there a patch we could make to ecpg to accept input parameters? Is there another way to write my input parameters to work around this error? -- Cheers, Andrew Pennebaker www.yellosoft.us

Re: [GENERAL] ecpg rejects input parameters

2015-04-08 Thread Andrew Pennebaker
Could you be more specific? I can't find a relevant section to address my specific problem: ecpg complaining when I try to check the syntax of my .sql files that use input parameters. On Wed, Apr 8, 2015 at 9:34 AM, Adrian Klaver wrote: > On 04/08/2015 07:22 AM, Andrew Pennebak

Re: [GENERAL] ecpg rejects input parameters

2015-04-09 Thread Andrew Pennebaker
Makes sense. Yes, it would be great if psql offered a flag for validating syntax. Other programming languages do this, for example, bash -n, ruby -c, and php -l. On Wed, Apr 8, 2015 at 3:53 PM, Tom Lane wrote: > Andrew Pennebaker writes: > > I can't find a relevant section

Re: [GENERAL] database migration question between different ubuntus and different postgresql server versions

2015-04-16 Thread Andrew Sullivan
systems to move all the data from one to the other. Depending on your uptime requirements and the size of the database, this approach can either be a life saver or a total waste of time and will to live. More often the latter, please be aware. A -- Andrew Sullivan a...@crankycanuck.ca -- Sen

Re: [GENERAL] database migration question between different ubuntus and different postgresql server versions

2015-04-16 Thread Andrew Sullivan
b from the old machine and restore locally, you could do pg_dump -U postgres -h 192.0.2.1 -C egdb | psql -U postgres I recommend reading the pg_dump (and if you like, pg_dumpall) manuals before proceeding. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list

Please not on this list (was Re: [GENERAL] Fwd: [pgsql-jobs] PostreSQL Engineer and DBA! Atlanta, GA)

2015-05-06 Thread Andrew Sullivan
ty's time with crowdsourced editing of job postings is in any way appropriate for the pgsql-general list. Best regards, A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql

Re: [GENERAL] odbc to emulate mysql for end programs

2015-06-02 Thread Andrew Sullivan
onvention. This case is no different. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] advocating LTS release and feature-train release cycles

2015-06-02 Thread Andrew Sullivan
emed developer claimed something and maybe should have relinquished sooner given his workload. That happens; nobody's perfect. It's frustrating, but this is not the only community to have had that issue (cf. Linux kernel, for an approximately infinite series of examples of this). I am not su

Re: [GENERAL] [PERFORM] pg bouncer issue what does sv_used column means

2015-06-12 Thread Andrew Dunstan
Please do not cross-post on the PostgreSQL lists. Pick the most appropriate list to post to and just post there. cheers andrew -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Error prone compilation of stored procedure

2015-07-06 Thread Andrew Sullivan
st, I found that to be useful when talking to Oracle partisans. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Creating a user for pg_start_backup

2015-07-21 Thread Andrew Beverley
Dear all, I'm setting up hot backups on my database server. As such, I'd like to set up a Postgres user that has access to only pg_start_backup and pg_stop_backup. I'm unable to work out how to do this with the various GRANT options. Can someone point me in the right direction please? Or is ther

Re: [GENERAL] Creating a user for pg_start_backup

2015-07-21 Thread Andrew Beverley
On Tue, 2015-07-21 at 16:54 +0900, Michael Paquier wrote: > On Tue, Jul 21, 2015 at 4:47 PM, Andrew Beverley wrote: > > Dear all, > > > > I'm setting up hot backups on my database server. As such, I'd like to set > > up a > > Postgres user

Re: [GENERAL] Creating a user for pg_start_backup

2015-07-21 Thread Andrew Beverley
On Tue, 2015-07-21 at 01:46 -0700, John R Pierce wrote: > On 7/21/2015 1:31 AM, Andrew Beverley wrote: > > I had to specify a database name when connecting: > > > > psql -U backup -c "select pg_start_backup('Daily backup')" -d postgres > >

Re: [GENERAL] Creating a user for pg_start_backup

2015-07-21 Thread Andrew Beverley
On Tue, 2015-07-21 at 03:00 -0700, John R Pierce wrote: > On 7/21/2015 1:51 AM, Andrew Beverley wrote: > > Thanks John. The backup script is running as root, so presumably I'd have > > to > > use > > sudo? Or should I run a separate cron job as postgres to do

Re: [GENERAL] Delete rule does not prevent truncate

2015-07-23 Thread Andrew Sullivan
e all the data in the table. I don't know what rewriting such a query would mean. Best regards, A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Delete rule does not prevent truncate

2015-07-23 Thread Andrew Sullivan
ut you asked what was behind the design decision and I told you. But in general, the experience seems to be that triggers are easier to get right (novice or no, _pace_ section 38.7). Best regards, A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-genera

Re: [GENERAL] Delete rule does not prevent truncate

2015-07-24 Thread Andrew Sullivan
lly sure why you think the manual is misleading. Best regards, A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Very puzzling sort behavior

2015-09-10 Thread Andrew Sullivan
hacks, but if you need a bugfix prior to a real solution they'd give you a path. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Where do I enter commands?

2015-10-24 Thread Andrew Sullivan
I. But do consider trying out the command line. You'll be surprised at the power you get once the initial learning curve is over. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: h

Re: [GENERAL] Where do I enter commands?

2015-10-25 Thread Andrew Sullivan
m MySQL already. Consistency and rigour are the changes ;-) A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Actual rows significantly more than estimated during many joins

2016-06-04 Thread Andrew Beverley
Dear all, I'm performing a query with many joins, with a WHERE condition on the "root" table. As far as I am aware, each join is indexed, as is the WHERE clause. To my simple mind, this is just a case of taking a set of conditional indexed values, and then "adding on" the relevant indexed data. W

Re: [GENERAL] Actual rows significantly more than estimated during many joins

2016-06-04 Thread Andrew Beverley
On Sat, 4 Jun 2016 Andrew Beverley wrote: > When I run EXPLAIN ANALYZE, I see that the actual query is scanning > significantly more rows for the join than was estimated. There is also > a huge number of loops for the joins. Why is this, and is there an > easy fix? I should have said

Re: [GENERAL] Actual rows significantly more than estimated during many joins

2016-06-04 Thread Andrew Beverley
On Sat, 4 Jun 2016 Andrew Beverley wrote: > I'm performing a query with many joins, with a WHERE condition on the > "root" table. As far as I am aware, each join is indexed, as is the > WHERE clause. To my simple mind, this is just a case of taking a set > of condition

[GENERAL] Optimise OR condiditions across multiple joins

2016-06-08 Thread Andrew Beverley
Dear all, Is there a way to efficiently perform OR conditions across multiple joins? For example, I have the following statement: SELECT RECORD.id FROM RECORD left join string ON string.record_id = RECORD.id AND string.layout_id = 6 left join DATE

[GENERAL] Looking for a good programming reference

2016-06-15 Thread Andrew Kerber
So, I am a decent oracle SQL and PL/SQL programmer looking to expand into PostgreSQL. Can someone point me to a decent programming book on the topic? I have looked Amazon and Apress and not found much, so I am not sure where to turn. Or perhaps I am looking the wrong places. -- Andrew W

Re: [GENERAL] MediaWiki + PostgreSQL is not ready for production?

2016-07-19 Thread Andrew Sullivan
s to MySQL, MySQL always wins, what you teach them is "Postgres performance sucks." Best regards, A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] MediaWiki + PostgreSQL is not ready for production?

2016-07-19 Thread Andrew Sullivan
this mysql2pgsql conversion rather than N dedicated small teams for > every mysql client out there. …I don't think anyone is telling you, "Don't build this." You should do what you like with your time :) A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailin

[GENERAL] gin index operator class functions in sql?

2016-07-21 Thread Andrew Geery
function signature be? Thanks Andrew [1] https://www.postgresql.org/docs/9.5/static/xindex.html

Re: [GENERAL] Uber migrated from Postgres to MySQL

2016-07-27 Thread Andrew Sullivan
27;t deserve while > they treat customers and employees with similar levels of arrogance. Nothin' for nothin', but I don't think it helps Postgres to attack others' business plans -- whatever one thinks of them -- as part of an argument about why Postgres is the right tool fo

Re: [GENERAL] Uber migrated from Postgres to MySQL

2016-07-27 Thread Andrew Sullivan
mpatibility historically was the basis for something becoming a major version upgrade. (I can recall a couple bugs where you had to tickle the catalogues, so it's not exactly true that they're never incompatible, but it's incredibly rare.) Best regards, A -- Andrew Sullivan a...@crankycanu

Re: [GENERAL] Uber migrated from Postgres to MySQL

2016-07-27 Thread Andrew Sullivan
m. But one has to face the critique in its own terms. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

pg_upgrade and not working (was Re: [GENERAL] Uber migrated from Postgres to MySQL)

2016-07-27 Thread Andrew Sullivan
ason we're still using 9.2. -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] consolidating data with window functions

2016-08-01 Thread Andrew Geery
dd to get the next logical row number; the "x" table actually computes the logical row number; finally we group by the logical row number and use string_agg to get a single name for each row. Is there an easier way to write this query, using some window function functionality that I

Re: [GENERAL] fun fact about temp tables

2016-08-05 Thread Andrew Sullivan
to some other place later, and it'd suck if the transaction failed half way through because it turns out there's nowhere to put the data I've just staged. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Online course for those who want tot contribute

2016-10-06 Thread Andrew Borodin
Hi everyone! From time to time I teach at Ural Federal University. Currently university wants me to make up online course. They are going to put it to platform like edX or something. I do not want to do another general programming course, so I made up my mind to do a “postgres-hacker” course. But

Re: [GENERAL] Online course for those who want tot contribute

2016-10-06 Thread Andrew Borodin
Cutting ties by my own interest: I want better Postgres. I want to teach those who probably will push patches. Best regards, Andrey Borodin. четверг, 6 октября 2016 г. пользователь Joshua D. Drake написал: > On 10/06/2016 10:39 AM, Andrew Borodin wrote: > >> Hi everyone! >> &g

[GENERAL] Largepages in Windows

2017-01-17 Thread Andrew Kerber
Does PostgreSQL 9.4 support large pages in windows? The setting is there in the postgresql.conf, but I cant tell if it is supported in windows? -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'

Re: [GENERAL] Largepages in Windows

2017-01-17 Thread Andrew Kerber
Thats what I needed, thank you. Windows generally calls them large pages, AIX also calls them large pages, really they are typically only called hugepages on Linux. On Tue, Jan 17, 2017 at 9:28 AM, Adrian Klaver wrote: > On 01/17/2017 07:20 AM, Andrew Kerber wrote: > >> Does Po

Re: [GENERAL] Largepages in Windows

2017-01-17 Thread Andrew Kerber
Oh, I can answer that. The owner of the postgreSQL executable must have the privilege to lock pages in memory. On Tue, Jan 17, 2017 at 9:38 AM, Tom Lane wrote: > Andrew Kerber writes: > > Does PostgreSQL 9.4 support large pages in windows? The setting is there > > in the postg

Re: [GENERAL] postgres zeroization of dead tuples ? i.e scrubbing dead tuples with sensitive data.

2015-11-18 Thread Andrew Sullivan
ssibly be exfiltrated, you need to know the state of all of it. For realistic cases, I expect that deleted data is usually more important than updated data. But a threat modeller needs to understand all these variables anyway. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-g

Re: [GENERAL] postgres zeroization of dead tuples ? i.e scrubbing dead tuples with sensitive data.

2015-11-18 Thread Andrew Sullivan
metimes people delete data from a system because it's been archived somewhere else or something like that -- not all databases have the totality of all the relevant data in them, but can often represent just "current" data. Best regards, A -- Andrew Sullivan a...@crankycanuck.ca

Re: [GENERAL] postgres zeroization of dead tuples ? i.e scrubbing dead tuples with sensitive data.

2015-11-18 Thread Andrew Sullivan
al risk to be mitigated is. It might, sure. The security profiler would still need to make a list of this fact and then ask how countermeasures mitigate it. Best regards, A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresq

Re: [GENERAL] Loggingt psql meta-commands

2015-12-10 Thread Andrew Sullivan
uditor, this might be enough to satisfy the condition. Also, of course, there is the application_name (string) parameter. In principle, you ought to be able to filter on this. Again, won't help you if your application login is somehow compromised. I agree that all of this depends on logging

Re: [GENERAL] Practical Application

2015-12-14 Thread Andrew Sullivan
e you can! There are also some firms that can help with migration if you like. Best regards, A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Session Identifiers

2015-12-20 Thread Andrew Sullivan
losing the shell so that the session hangs around). Eventually, the Postgres backend will try to talk to the session and discover it isn't there, and you'll get a termination logged (assuming you have loging turned up that high). A -- Andrew Sullivan a...@crankycanuck.ca -- Sent

[GENERAL] Efficiently selecting single row from a select with window functions row_number, lag and lead

2016-01-01 Thread Andrew Bailey
e the query as a single select and if so how? Thanks in advance Andrew Bailey

What another group does (was Re: [GENERAL] Code of Conduct: Is it time?)

2016-01-06 Thread Andrew Sullivan
urage those who think there is a problem to be solved to make a scratch proposal and see whether it flies. It's always easier to discuss a concrete proposal than to try to figure out whether something is a good idea in the abstract. The shorter and easier to understand the proposal is, I

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

2016-01-10 Thread Andrew Sullivan
children of slaves. If someone did that, it would fall under (2), no? (I note that a recent RFC, of which I am a co-author, about DNS terminology did say that "primary" and "secondary" were to be preferred over "master" and "slave". I didn't personally

Things to notice (was Re: [GENERAL] Code of Conduct: Is it time?, broken thread I hope)

2016-01-10 Thread Andrew Sullivan
an we can do something about it by writing down rules. Still, the exercise of writing down rules may help to notice things one wouldn't say to a friend. And I hope we're all friends here. Best regards, A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list

Re: Things to notice (was Re: [GENERAL] Code of Conduct: Is it time?, broken thread I hope)

2016-01-11 Thread Andrew Sullivan
tended in the generic sense. I apologise in case that wasn't clear. > It is the perceived intention of what one says that is important, not what > one actually says! I think that is perhaps a false dichotomy. But I also think I have said enough on this topic, so I shall stop now. B

Re: [GENERAL] Auotmated postgres failover

2016-01-21 Thread Andrew Sullivan
that you actually want to fail over. I've seen an awful lot of people want automatic failover who also can't afford for the already-committed transactions on the master to be lost. Unless you're running synchronous, be sure you have the workload that can actually accept lost w

Re: [GENERAL] Let's Do the CoC Right

2016-01-22 Thread Andrew Sullivan
at stuff about what the IETF does some while ago. There is definitely more than one way to do this. Best regards, A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Catalog bloat (again)

2016-01-27 Thread Andrew Sullivan
at can be done about it? You may end up taking an outage in effect, because you need to compact them at least once. If you can flip to a replica, that is the easiest way to fix it. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.o

Re: [GENERAL] database corruption

2016-02-12 Thread Andrew Sullivan
to recover after a restart. It may not be the hardware. Depending on how vmware is configured, it could just be a setting. Also, something in the OP's message made me think that this was _actually_ a network-attached disk, which can also have such problems. (But in general, I agree.) A

[GENERAL] Why is my database so big?

2016-02-21 Thread Andrew Smith
verhead involved in getting this data into the internal storage format used by PostgreSQL. But even if I triple the number of bytes stored for each record, I only end up with 51 MB or so. Am I missing something obvious? Cheers, Andrew

Re: [GENERAL] json function question

2016-02-24 Thread Andrew Dunstan
s: they are essentially one-dimensional heterogenous lists, not multi-dimensional homogeneous matrices. So while a Postgres array that's been converted to a json array should in principle be convertible back, an arbitrary json array could easily not be. cheers andrew -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] json function question

2016-02-24 Thread Andrew Dunstan
On 02/24/2016 09:11 AM, David G. Johnston wrote: On Wednesday, February 24, 2016, Andrew Dunstan <mailto:and...@dunslane.net>> wrote: Having json(b)_populate_record recursively process nested complex objects would be a large undertaking. One thing to consider is that js

Re: [GENERAL] json function question

2016-02-24 Thread Andrew Dunstan
he json array to produce a Postgres array literal. But if we're handling nested composites as well that probably won't pass muster and we would need to decompose all the objects fully and reassemble them into Postgres objects. Maybe it won't take as long as I suspect. If anyone

Re: [GENERAL] regarding table migration from sql to postgres with runmtk.sh

2016-03-09 Thread Andrew Sullivan
fork. But … > Exception in thread "main" java.lang.NoClassDefFoundError: > org/postgresql/Driver … since it can't find the driver, I'd bet that your classpath doesn't contain /opt/postgresplus/edbmtk/lib. Best regards, A -- Andrew Sullivan a...@crankycanuck.ca

Re: [GENERAL] enum bug

2016-03-14 Thread Andrew Sullivan
Best regards, A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How to Qualifying or quantify risk of loss in asynchronous replication

2016-03-19 Thread Andrew Sullivan
receive a message that data is committed before any replication of the data has commenced," would that help? Best regards, A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Proper relational database?

2016-04-23 Thread Andrew Sullivan
card number gets lost in an eventually-consistent system, and people suddenly understand viscerally why transactions semantics are so hard. Best regards, A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subs

On the right tool (was Re: [GENERAL] Proper relational database?)

2016-04-23 Thread Andrew Sullivan
hors intended. Doesn't matter for these purposes! :) [2] Apparently, Marshall McLuhan didn't say this; instead, his tribune John Culkin, SJ said it. It's still an excellent point, whoever made it. Best regards, A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

  1   2   3   4   5   6   7   8   9   10   >