e would
use 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
ror.
> Any idea 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
signa
ug?
If your 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
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
>&
nstructions here: http://www.cpan.org/modules/INSTALL.html
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
replication in a way that's sufficient for some use cases.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
r user will
recreate the xyz objects each time you replace abc. That's kinda a religious
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
g one for pgsnmpd, which you're welcome 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:
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: Di
ely-used is check_postgres, found here:
http://bucardo.org/wiki/Check_postgres
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
t it does indeed 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
anything special you have to load to run 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
://www.sqlpower.ca/page/architect
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
irst time you run them in a
session, to avoid 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
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
h
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 po
x"
The key point seems to be that the owner 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
I can't find it right now, 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
lue of nextval('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
http://www.postgresql.org/docs/current/static/sql-prepare-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
caching effects, and the different client
hosts are confusing the issue. If you issue the query from one machine
multiple times, does it reliably take forever the first time, and go quickly
afterward?
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
ing on it. The idea 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
hen another. I can 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 da
a trigger
> running PL/LOLCODE to do that!"
PL/LOLCODE doesn't support running triggers, 'cuz no one has written that bit
yet
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
al), you're better
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
>wrote:
>
> On Thu, Jun 10, 2010 at 06:01:24PM -0700,
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, F
that? I couldn't find anything 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
returned? It might be you're
editing the wrong copy of postgresql.conf, or not restarting PostgreSQL after
editing
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
cation:
http://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
terday, and think I 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
my connections in the pool from time to time to force
> replanning of my prepared statements.
I'm not sure this is a great idea, but it would depend on your application.
With caching and pooling and such, a prepared statement might live a really
long time, but your database's statist
, though I may be wrong. The change you refer to replans such
things when the actual objects change, such as when you remove a column or
something that would make the plan fail to execute.
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
SQL 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-general
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
umns read from
various parts of the disk, effectively identical to doing a bunch of joins.
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
k comes with a SQL script you need to run to create
the necessary functions 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 Toll
>Regards
You'll need something like 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
avoid
them?
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
r PostgreSQL logs. The
logging documentation might be useful to you here.
http://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
p://bucardo.org/check_postgres/check_postgres.pl.html#basic_filtering
--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
signature.asc
Description: Digital signature
u please advice?
>
>regards
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
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
lem, too, though I hate to admit that I haven't actually
filed a bug already SUSE. I was fairly far removed from the actual
installation in that case, if it's 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
l fix any weirdness in your base backup, and you'll get 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
aster replication works only 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 / eggy
st guesses about 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
ways, so if you have logs of
the queries you were running at the time, you 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
, Pentaho translates their input into SQL.
Anyway, you might try using 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
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:
rigger() could 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
> >
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 t
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 T
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 r
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 / eg
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,
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 b
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'
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
(http://www.postgresql.org/doc
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
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.
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], Londist
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 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 benchmarking. EC2
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 th
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 some
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
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
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 ea
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
On Mon, Oct 13, 2008 at 1:02 AM, Ivan Sergio Borgonovo
<[EMAIL PROTECTED]> wrote:
> 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 da
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 pe
76 matches
Mail list logo
