Django, Caching and PostgreSQL replication

2010-06-10 Thread Simon Riggs
online at http://www.char10.org/ Please register in next two weeks to avoid late booking fees. See you there! -- Simon Riggs www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Training and Services -- You received this message because you are subscribed to the Google Groups

Re: Database systems

2010-07-16 Thread Simon Riggs
On Fri, 2010-07-16 at 20:33 +0530, Venkatraman S wrote: > I thought South was DB agnostic. It is, but databases provide different feature sets. If databases were all the same there would not be so many to choose from. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Development, 2

Re: Could not connect postgresql database

2011-08-23 Thread Simon Riggs
problem with the socket directory. Permissions? > Here is my pg_hba.conf file  settings: That looks correct. --  Simon Riggs   http://www.2ndQuadrant.com/  PostgreSQL Development, 24x7 Support, Training & Services -- You received this message because you are subscribe

Re: Trouble expressing a query in the ORM

2011-09-09 Thread Simon Riggs
() opportunity. Not sure I understand the limitation to 10-15 entries. Please explain? Or EXPLAIN? --  Simon Riggs   http://www.2ndQuadrant.com/  PostgreSQL Development, 24x7 Support, Training & Services -- You received this message because you are subscribed to the Google Group

Re: Newbee question about PostgreSQL

2011-10-17 Thread Simon Riggs
same username as the OS user. This can be modified to allow whatever authentication rule you wish, per the manual. http://developer.postgresql.org/pgdocs/postgres/client-authentication.html or other docs depending upon your db version. --  Simon Riggs   http://www.2ndQuad

Re: Newbee question about PostgreSQL

2011-10-17 Thread Simon Riggs
TAL:  Ident authentication failed for user "george" > > find pg_hba.conf and change 'ident' to 'password' on the lines at the > end of the file Changing the rules in that way would break all existing connections. You should always use md5 rather than pa

Re: Multiple database Router

2011-10-26 Thread Simon Riggs
s are the engines, and yes, you do find engine specialists in car forums because cars are the raison d'etre. If Django was a badly designed car, you wouldn't find such people, that's true. I'm sure the Red Bull team have similar discussions about whose piece of the car is most

Re: cannot connect to postgresql database

2011-11-23 Thread Simon Riggs
ld i ask for help to connect django to > postgresql?   i follow the tutorial on djangobook.com We need to know more before anybody can help you, no matter where the problem lies. --  Simon Riggs   http://www.2ndQuadrant.com/  PostgreSQL Development, 24x7 Support, Training &

Re: new to Django and building web applications. Advice with postgresql

2013-05-21 Thread Simon Riggs
g a major architectural component in your stack is not a trivial thing. Major changes affect the quality of your deliverables. The most important thing is that a database is a shared resource. If you write all your programs assuming you'll be the only user then it likely won't work very well

Re: new to Django and building web applications. Advice with postgresql

2013-05-21 Thread Simon Riggs
te isn't good practice, whether that be Postgres, sqlite or any other component. Whatever you plan to use, please use it from the start. If you can. If there are blockers to doing that for Postgres, please mention it to me, other community members or on the Postgres lists, so we can help. --

Re: data transfer between databases

2013-07-01 Thread Simon Riggs
a m2m relationship. >>> >>> You can use direct access via "foreign tables" the name of the Postgres distributed database feature. http://www.postgresql.org/docs/devel/static/sql-createforeigntable.html -- Simon Riggs http://www.2ndQuadrant.com/ Postgr

Re: data transfer between databases

2013-07-01 Thread Simon Riggs
base. But I have no idea why I would choose one over the other. Can you > suggest? > Distributed access is more dynamic but likely somewhat slower when access required. Replication could be thought of as pre-cacheing the data you want to see. > In any case, I'm 99% sure I should &q

Re: Representing infinity or "no limit" in an integer field?

2013-08-20 Thread Simon Riggs
table statistics to determine are NULL values indexed or not. Postgres stats include number of values NULL. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- You received this message because you are subscribed to

Re: How to configure pgAdminIII

2011-07-15 Thread Simon Riggs
e to differentiate it easily in pgAdmin and then supply user/password details for the database. Whoever installed the database server should know that. --  Simon Riggs   http://www.2ndQuadrant.com/  PostgreSQL Development, 24x7 Support, Training & Services -- You received this me

Re: Postgresql transaction error

2011-03-22 Thread Simon Riggs
hrows an error then you must explicitly rollback the transaction before you continue. This is a requirement of the SQL standard, not just a PostgreSQL issue. I can see it would be fairly hard to Google an answer for. I would guess you started a transaction and then didn't check for success

Re: Postgres and backup/restore

2014-02-06 Thread Simon Riggs
g it to another machine but I haven't done that yet. > > One day real soon now. Today is good. Streaming replication does exactly that. http://www.postgresql.org/docs/9.3/static/warm-standby.html#STREAMING-REPLICATION -- Simon Riggs http://www.2ndQuadrant.com/ Post