in production, but rather as a teaching tool. It taught me rather nicely,
too. :)
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
pgpc2KfpMpMGx.pgp
Description: PGP signature
is welcome.
ps: sorry for late reply
I don't have any good answers beyond what was already presented here:
http://archives.postgresql.org/pgsql-hackers/2011-05/msg00784.php
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
postgres build uses --enable-debug, cube should use it as well. It
determines this either through pg_config, or by referring to makefiles in the
postgres source directory contrib/cube lives in.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital
sufficient for some use cases.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
: http://www.cpan.org/modules/INSTALL.html
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
On Thu, May 05, 2011 at 08:13:55PM -0700, John R Pierce wrote:
On 05/05/11 8:05 PM, Joshua Tolley wrote:
Actually, Bucardo doesn't do statement replication. It, like Slony for
instance, replicates data, not SQL statements. And as you pointed out, it
does
do bidirectional replication in a way
issue, and depends on things like how stable your user expects the objects in
xyz to be.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
I'm hunting opinions on Compellent (http://www.compellent.com) storage devices
and postgres. Comments, anyone? Experiences? Case studies? Success or horror
stories? Thanks in advance.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital
to use. I can't
guarantee that writing my own was the best way to do it, or that it's free of
bugs. See pg_array.c and pg_array.h at
http://git.postgresql.org/gitweb?p=pgsnmpd.git;a=summary
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital
://bucardo.org/wiki/Check_postgres
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
do this for you. PLPython
caches a procedure's input and return types, and a compiled representation of
the procedure's source.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
SQL functions, beyond what gets
loaded anyway.
If you have problems with hundreds of connections using too much memory when
each loads an interpreter, you ought to consider getting more memory, using a
connection pooler, changing how you do things, or some combination of the
above.
--
Joshua Tolley
needing to look up or calculate that information again when
you run the function next time.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
/architect
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
On Fri, Oct 01, 2010 at 11:27:11AM -0700, Aleksey Tsalolikhin wrote:
How to see what SQL queries are associated with pg_locks, please?
Look at the pid column in pg_locks. It will match the procpid column in
pg_stat_activity.
--
Joshua Tolley / eggyknap
End Point Corporation
http
On Sat, Aug 07, 2010 at 08:34:12AM +0100, Richard Huxton wrote:
On 07/08/10 01:13, Joshua Tolley wrote:
Is there some justification for this behavior that I should know already? It
seemed awfully strange when some folkds here stumbled on it:
[snip]
The key point seems to be that the owner
, but in general the conclusion was
it's bad to have lots of partitions, where lots is probably 100 or more.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
of the referenced table has no
permissions on the table, although the referencing user does.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
('some_sequence'), this worked for me:
select
attrelid::regclass || '.' || attname,
adsrc
from
pg_attrdef ad
join pg_attribute pa
on (ad.adrelid = pa.attrelid and pa.attnum = ad.adnum)
where
adsrc ~* 'nextval'
--
Joshua Tolley / eggyknap
End Point Corporation
http
-transaction.html
If I may be allowed to toot my own horn, may I suggest this as an example:
http://blog.endpoint.com/2010/07/distributed-transactions-and-two-phase.html
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
see doing this by
having separate connection pools. The higher priority users have a
larger connection pool.
That's entirely reasonable.
Is there a problem with using connection pooling and traditional
connections to connect to the same database?
Nope.
--
Joshua Tolley / eggyknap
End
is that any language running
on Parrot will be usable with PL/Parrot. Whether that pans out in real life is
an open question, probably, but it's part of the plan.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
afterward?
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
that!
useless noise
PL/LOLCODE doesn't support running triggers, 'cuz no one has written that bit
yet
/useless noise
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
off integrating with some external authentication provider, as has been
suggested elsewhere in this thread.
--
Josh
Thanks
Deepak
On Fri, Jun 11, 2010 at 10:30 AM, Joshua Tolley eggyk...@gmail.com
wrote:
On Thu, Jun 10, 2010 at 06:01:24PM -0700, DM wrote:
How
useful ...
5432 j...@josh# SHOW search_path;
search_path
$user,public
(1 row)
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
On Thu, Jun 10, 2010 at 06:01:24PM -0700, DM wrote:
How to force postgres users to follow password standards and renewal
policies?
Thanks
Deepak
9.0 will ship with a contrib module called passwordcheck which will enforce
some of these things, FWIW.
--
Joshua Tolley / eggyknap
End
of postgresql.conf, or not restarting PostgreSQL after
editing
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
was wrong in my original
assertion that they wouldn't be replanned. So now I'm thinking don't bother
manually refreshing your prepared statements, because postgresql will do it
for you :)
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital
://www.postgresql.org/docs/8.4/interactive/auth-methods.html
You might also refer to this PGCon 2010 talk:
http://www.fosslc.org/drupal/content/secure-postgresql-deployment
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
even longer to change
sufficiently to suggest one plan is better than another. Explicitly replanning
sounds like it's probably more work than it's worth, unless you see specific
plan problems.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description
that would make the plan fail to execute.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
PostgreSQL closed the connection on purpose. Any JDBC
driver people reading this, with ideas?
--
Joshua Tolley / eggyknap
End Point Corporation
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
and some others i get
an exception of
org.postgresql.util.PSQLException: An I/O error occured while sending to
the backend.
java.net.SocketException: Socket closed
Do the PostgreSQL logs include any useful information?
--
Joshua Tolley / eggyknap
End Point Corporation
--
Sent via pgsql
.
For some workloads the columnar storage is a win, and for some workloads,
row-based storage is the best bet.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
and other objects. In this case it's called
dblink.sql. Find that file -- in my case it's part of the postgresql-contrib
package -- and execute it in your database to create that function.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description
the dblink contrib module to get one database to
talk to another.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
?
Bucardo should handle the disconnection problems you described just fine.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
://www.postgresql.org/docs/current/static/runtime-config-logging.html
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
That depends on what you mean by compare. check_postgres[1] has a schema
comparison action you can use.
[1] http://bucardo.org/wiki/Check_postgres
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
Bucardo is released under the BSD license (see htt://bucardo.org for more
details). It's actively developed, and we at End Point have found it very
useful and reliable. But we wrote it :)
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
On Tue, Dec 15, 2009 at 03:05:34PM
any excuse ;) Anyway, I can confirm you're
not the only one having this problem.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
a working
database, current up to the last WAL file you recovered.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
between two hosts, unless
perhaps you can assure that only certain primary keys will be updated on
certain hosts, or do some other trickery. Syncing from one master to multiple
slaves is straightforward, if all you need is master-slave.
--
Joshua Tolley / eggyknap
End Point Corporation
http
those statistics) for the
moment they're queried, but when those values are updated, the old values are
lost.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
might be able to get the same or
a similar condition by executing those queries against the restored system.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
a reporting package rather than trying to write
your own query interface and provide for user-friendly error reporting, decent
security constraints, etc.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
On Fri, Aug 21, 2009 at 11:43:49AM -0700, David Kerr wrote:
Is there a default/standard (free) schema diff tool that's in use in the
community?
check_postgres.pl will compare schemas and report on results.
http://bucardo.org/check_postgres/
--
Joshua Tolley / eggyknap
End Point Corporation
to reduce bloat.
You could possibly use UNION or UNION ALL to consolidate your 5 passes into
one pass. You could also possibly use UPDATE FROM to avoid having to return
the primary keys at all, and get the whole thing done in one query.
--
Joshua Tolley / eggyknap
End Point Corporation
http
be helpful in this
case:
http://www.postgresql.org/docs/8.4/interactive/functions-trigger.html
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
Since no one else seems to have sent it yet, I'll do the obligatory annual
Happy Birthday email. Happy Birthday, PostgreSQL. You're a teenager now. The
pimples will go away, in time.
- Josh / eggyknap
signature.asc
Description: Digital signature
On Mon, Jun 29, 2009 at 09:02:30AM +0300, Sim Zacks wrote:
The first is easy; simply configure data sources pointed at the PostgreSQL
database. Note that the JDBC drivers that ship with Pentaho are, in my
experience, of inconsistent version, and you might want to update them to
the
On Sat, Jun 27, 2009 at 02:04:13PM -0700, Michal Szymanski wrote:
I've used Pentaho with pgsql and it worked pretty well. I'm pretty
sure jasper as well can work with pgsql.
Where can I find information how to install Pentaho on Postgres? Do
you use free edition?
We also both the free
On Wed, Jun 24, 2009 at 01:43:20PM +0200, Marko Pahić wrote:
Hello,
I have two databases, and I want the same structure, and if I change the
structure of one database it changes the structure of the other. In
documentation I saw that the syntax goes something like this: CREATE
On Mon, Jun 01, 2009 at 04:21:27PM +0100, Shak wrote:
When RETURNING from a DELETE statement (or similar), how do you access the
results being returned?
Something like:
SELECT COUNT(*) FROM (DELETE FROM a RETURNING *) ;
sounds reasonable but results in a syntax error. I am able to return
On Wed, Jun 03, 2009 at 09:36:18AM -0400, Esneiker wrote:
I'm trying to build a cursor for postgres but I have some problems. Can
anybody send me an example of cursor in postgres?
What about these examples?
http://www.postgresql.org/docs/8.3/interactive/plpgsql-cursors.html
- Josh /
On Wed, May 27, 2009 at 01:21:40PM +0530, Anirban Pal wrote:
Can any body tell me how to fetch directory path for lib or data directory
for postgres installation in windows using registry. Solution using Java
language will be highly solicited.
Some PL/Java or PL/J function might do
On Mon, May 25, 2009 at 12:10:21AM -0700, Scara Maccai wrote:
is there any chance to get the Planner Cost Constants right enough to get a
good estimate in seconds of how long a query is supposed to run?
The rowcount estimates are always good (there is no skew data at all in the
db, values
On Fri, May 08, 2009 at 11:25:30AM -0700, John R Pierce wrote:
Mag Gam wrote:
Is it possible to tweak (easily) Postgresql so the storage is column
oriented versus row-oriented? We would like to increase read
optimization on our data which is about 2TB.
you read your tables by column,
On Tue, May 05, 2009 at 10:04:15AM +, Glyn Astill wrote:
I'm looking at building an olap reporting environment and I came across this
project on pgfoundry. However it was last updated over 3 years ago, am I
correct in assuming that this probably isn't something I should be looking at?
I've
On Sat, Apr 25, 2009 at 04:01:20PM -0400, Kenneth Tilton wrote:
Given constraint:
ALTER TABLE provider_input.common
ADD CONSTRAINT common_pin_file_load_sid_fkey FOREIGN KEY
(pin_file_load_sid)
REFERENCES provider_input.file_load (sid) MATCH FULL
ON UPDATE NO ACTION ON DELETE
On Sat, Apr 25, 2009 at 04:21:06PM -0400, Kenneth Tilton wrote:
But I am inheriting from the parent, so everything about the parent
should be true for me unless overridden. I mean in the usual sense of
inherit I know from OO.
This is from the current docs
On Mon, Apr 20, 2009 at 02:14:00PM +0200, Stefano Nichele wrote:
Do you think that it could useful mounting two different EBS to handle
data and pg_xlog ?
Testing I've participated in suggests that it helps to split pg_xlog
elsewhere. Your mileage may vary.
- Josh / eggyknap
signature.asc
On Thu, Mar 12, 2009 at 03:13:13PM +0100, A. Kretschmer wrote:
In response to Kynn Jones :
Is there a reliable way to find out the (Unix) PID associated with a
database
handle generated by Perl DBI's database connection?
You can ask the pg_stat_activity - View, column procpid.
The
On Wed, Mar 11, 2009 at 12:26:35PM -0700, SHARMILA JOTHIRAJAH wrote:
It is just 1 way synchronization... replication with slony sounds pretty
good... ill try that out
Thanks
There are options other than Slony, each with their pros and cons. Some
that come to mind include Bucardo[1],
On Thu, Mar 05, 2009 at 04:50:09AM -0800, paulo matadr wrote:
I need to procedure to kill users in idle,anybody have this made?
thanks
See pg_cancel_backend.
http://www.postgresql.org/docs/8.3/static/functions-admin.html
- Josh / eggyknap
signature.asc
Description: Digital signature
On Tue, Mar 03, 2009 at 10:25:17AM -0500, Tom Lane wrote:
Adrian Klaver akla...@comcast.net writes:
Nothing. I have created a Postgres instance on an EC2 virtual machine with
attached EBS(Elastic Block Storage). I only got as far as creating in it
and
verifying it would run, no
On Thu, Feb 12, 2009 at 02:17:03AM +0300, Igor Katson wrote:
PostgreSQL does not provide a transaction manager.
When you are dealing with multiple databases, the transaction manager
needs to make decisions like this transaction failed on one node,
therefore we need to roll all the other
On Thu, Nov 13, 2008 at 06:39:47PM -0800, Eus wrote:
Isn't that something like this is better handled at the application level
instead of the DB level?
IOW, isn't that the cost of doing the query above far more expensive than
doing a little coding at the application level?
That's
On Sat, Nov 01, 2008 at 02:24:37PM +0100, Michelle Konzack wrote:
Du I need to create a SEQUENCE for each table or do I need only ONE of
if and can use it independant on differnt tables?
If you just create a bunch of tables with SERIAL or BIGSERIAL columns,
it will create one sequence for
On Fri, Oct 31, 2008 at 06:57:25PM -0400, Eric Schwarzenbach wrote:
My problem with GEQO using a random number generator is that
non-deterministic behavior is really hard to debug, and problems can go
undiagnosed for ages. Frankly I would rather something fail all the
time, than it work most
On Wed, Nov 05, 2008 at 08:34:55PM +0530, Shashank Mujumdar wrote:
After installing dspace when I tried to connect it to the postgresql
server it gave the following error.
psql -U postgres -h localhost ( command used )
the error was
psql: could not connect to server: Connection refused
On Wed, Oct 15, 2008 at 10:42 AM, Bill Thoen [EMAIL PROTECTED] wrote:
Does PG (8.1) ever use existing indexes when executing an UPDATE?
I've got some tables with millions of records and whenever I update a column
that involves most or all the records the EXPLAIN command seems to indicate
that
On Mon, Oct 13, 2008 at 1:02 AM, Ivan Sergio Borgonovo
[EMAIL PROTECTED] wrote:
snip
Anyway I don't find myself comfortable with replies in these 2 lines
of reasoning:
1) default configuration of PostgreSQL generally doesn't perform well
2) PostgreSQL may be slower but mySQL may trash your
On Thu, Oct 9, 2008 at 2:37 AM, Galland Gregoire [EMAIL PROTECTED] wrote:
Hi all!
I would like to run all my databases in a readonly mode just for a few
hours (migration plan).
Is it a way to tell the postgresql engine to run in readonly?
Sincerly
G.Galland
This comes up periodically
76 matches
Mail list logo