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
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
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
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
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.
--
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
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 &
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
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
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
() 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
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
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
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
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
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
16 matches
Mail list logo
