On 10/15/2012 01:22 AM, John Nash wrote:
Hi,
There is no reason to email all the lists. Removing ones that aren't
required. You are just going to irritate everyone.
Our IT Company systems architecture is based on IBM Websphere
Application Server, we would like to migrate our databases
On 10/10/2012 02:18 AM, Sim Zacks wrote:
2) I run MySQL from a USB stick.
There is no installation required (on WinXP.). (not tried on Ubuntu)
Is it the same for pgsql?
To use postgres on a USB stick, see
to keep DB
servers in Linux and Windows plpython compatible?
Because you are using non .Org packages. It is up to the distribution
whether linux or Windows to determine what is packaged, not .Org.
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support
don't know if I would call it formal, but it is still a productive
project.
Sincerely,
Joshua D. Drake
Thanks and Regards,
Kumar Rajeev Rastogi
Cell No - +91 8971367787
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services
Hey,
Just a small reminder that the CFP for PgNext in Denver is still open.
Let's get those talks in!
https://www.postgresqlconference.org/
JD
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL
is not a community product. You may want to check with
EDB support.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http://www.postgresqlconference.org/
@cmdpromptinc - @postgresconf
On 03/07/2012 06:27 PM, Aleksey Tsalolikhin wrote:
SELECT relname as Table, pg_size_pretty(pg_total_relation_size(relid))
As Size from pg_catalog.pg_statio_user_tables
ORDER BY pg_total_relation_size(relid) DESC;
)
I ran VACUUM FULL on this table, but it is still over 500 GB in
On 02/25/2012 08:13 AM, Scott Ribe wrote:
What I'm trying to determine is: should I plan on using pgbouncer?
With Rails Passenger, do the app server processes take and hold connections to
the db? Or take release with queries/connections?
This is not a scalability question; given the
On 12/08/2011 03:24 AM, Craig Ringer wrote:
- shared-storage clustering. Dunno if anyone still cares about this one
though.
This one seems to be moving into the legacy category over the next 3-5
years.
JD
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support,
On 12/08/2011 10:54 AM, John R Pierce wrote:
On 12/08/11 10:14 AM, Joshua D. Drake wrote:
- shared-storage clustering. Dunno if anyone still cares about this one
though.
This one seems to be moving into the legacy category over the next 3-5
years.
um, I believe this is referring
On 12/08/2011 11:24 AM, John R Pierce wrote:
On 12/08/11 11:16 AM, Joshua D. Drake wrote:
um, I believe this is referring to Oracle RAC clustering, not HA
active/standby. I seriously doubt Oracle is dropping RAC.
I meant worrying about it for Pg.
the odds of Postgres developing something
On 12/08/2011 12:57 PM, Bruce Momjian wrote:
Chris Redekop wrote:
Is there any way to get the database system identifier via a select
statement? I have a primary/secondary async replication setup, and I'd
like be able to verify from the client side that the provided primary and
secondary
On 12/08/2011 03:12 PM, Raymond O'Donnell wrote:
On 08/12/2011 23:07, sharmi...@yahoo.com wrote:
http://happenenstappengroningen.nl/news.html?r5h1h5
Just wondering, and without intending to cast any aspersions on the
poster - is this spam or legit? I didn't take the risk of actually
On 11/23/2011 01:54 PM, Bill Thoen wrote:
Am I digging too deep here, or what am I missing? Is there a better way
to tranfer info between my database and the web than by using a generic
account? It sure seems like I'm granting too much access to too little a
player. Any advice would be
On 10/27/2011 04:24 PM, Chris Travers wrote:
On Thu, Oct 27, 2011 at 9:44 AM, Martijn van Oosterhout
klep...@svana.org wrote:
I note in the OPs case they are relying on the customer to install
PostGIS. The GPL only applies to *redistribution* not usage. So if
you're not supplying your
coming out with connection limit exceed.
Yes you need a pooler. Initiating connections like that is expensive.
The use of PgBouncer is your friend here.
http://wiki.postgresql.org/wiki/PgBouncer
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL
and/or recommendations
for how to graphically display sensor data over time.
I would suggest importing it into Google Docs and charting it as you
would a spreadsheet and then sharing that.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training
both async and sync, are you
working on multi-master replication? *excited* Or what's the
roadmap?
I would take a look at postgres-r. It is under active and supported
development.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training
Hello,
We are in the final 48 hours of the CFP for PgWest. Let's get those
talks in.
https://www.postgresqlconference.org/talk_types
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
creating a table.
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http://www.postgresqlconference.org/
@cmdpromptinc - @postgresconf - 509-416-6579
--
Sent via pgsql-general
Hey .Org,
The PgWest CFP has been extended until the 12th. Let's get those talks in!
https://www.postgresqlconference.org/talk_types
JD
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference -
On 07/23/2011 10:55 AM, Tomas Vondra wrote:
On 23 Červenec 2011, 18:14, Yan Chunlu wrote:
thanks for the help!
are there any other possible reasons?
both system are using Debian amd64, as uname -a shows:
Linux washington 2.6.26-2-amd64 #1 SMP Tue Mar 9 22:29:32 UTC 2010
x86_64 GNU/Linux
It
Hey folks,
As a reminder, PgWest is in a few months and the CFP closes in two
weeks. Get those talks in!
https://www.postgresqlconference.org/talk_types
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services
On 07/01/2011 02:00 PM, Rich Shepard wrote:
I've examined the 9.0 manual page on alter table without seeing how to add
a foreign key constraint to a column.
I needed to make changes on a couple of existing tables which could be
accomplished only by dropping the foreign key constraint. That, and
constantly wastes cpu cycles and memory. I want to turn it off until I
actually have my postgreSQL server running.
I think this belongs over at one of EnterpriseDB's support forums.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training
Hello,
The CFP for #PgWest is now open. We are holding it at the San Jose
Convention Center from September 27th - 30th. We look forward to seeing
your submissions.
http://www.postgresqlconference.org/
Joshua D. Drake
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support
On 5/3/2011 7:33 AM, Simon Riggs wrote:
Pleased to meet you Mark.
If you post here, the above disclaimer is not effective. Right now
your words are being copied across the internet...
I believe our community needs to move past posting replies like this. It
isn't even relevant to the
On 04/29/2011 10:01 PM, Greg Smith wrote:
On 04/29/2011 06:13 PM, Jeff Davis wrote:
I'm not sure which reference you found, but SFPUG is certainly active
with meetings every month.
http://pugs.postgresql.org/sfpug ; last meeting listed there is
January 2009.
Yeah, that site is kind of.
On 04/28/2011 10:29 AM, Jim Irrer wrote:
A colleague of mine insists that using surrogate keys is the
common practice by an overwhelming margin in relational databases and
that they are used in 99 percent of large installations. I agree that
many
situations benefit from them, but are they
help you.
As someone mentioned previously, there is also pl/secure. It certainly
isn't perfect but it will deal with the low hanging fruit.
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training
options should I have selected when building this version so the PHP
application can connect to the back end?
This seems more like a question for the adodb list.
SIncerely,
Joshua D. Drake
Rich
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com
On Sat, 2 Apr 2011 19:26:56 +0200, Henry C. he...@cityweb.co.za wrote:
On Sat, April 2, 2011 14:17, Jens Wilke wrote:
Nevertheless since at least 8.4 IMO there's no need to bother with
manual vacuum any more.
Uhh, this is entirely untrue. There are plenty of cases where 8.4
autovacuum can't
that gear is much of an obstacle.
No, gear is not the obstacle. It is man power.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc
database running and answering queries while it's WAL'ing. I'd have to
log in and switch it to normal mode and start the webapp, and that's
what I may not be able to do if the backup server were needed.
You can if you are using 9.x, take a look at the HS stuff.
Joshua D. Drake
? That is a lot of resources. Simply put, we would have needed a
minimum of 21 volunteers just for video (assuming we each volunteer was
dedicated for only a day). The conferences just aren't that big yet.
Sincerely,
Joshua D. Drake
--
Jon
--
PostgreSQL - XMPP: jdrake(at)jabber(dot
On Mon, 2011-03-14 at 16:03 +, Raymond O'Donnell wrote:
On 14/03/2011 15:56, Raymond O'Donnell wrote:
On 14/03/2011 15:35, Allan Kamau wrote:
CREATE SEQUENCE hy3_pack_seq MINVALUE 1000;
CREATE TABLE hy3_pack
(
hy3_id INTEGER NOT NULL DEFAULT nextval('hy3_pack_seq') -- or hy3_id
to the new
cluster. Your existing cluster will not be usable once you do this.
Joshua D. Drake
--
Bruce Momjian br...@momjian.ushttp://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
PostgreSQL.org
Hey,
The schedule for #PgEast is up. It can be found here:
https://www.postgresqlconference.org/files/east_2011_schedule.html
As usually we have a increasingly wide selection of content.
Sincerely,
JD
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ -
On Thu, 2011-03-03 at 20:03 -0700, Gauthier, Dave wrote:
Hi:
I have to update all the records of a table. I'm worried about what
the table will look like in terms of fragmentation when this is
finished. Is there some sort of table healing/reorg/rebuild measure I
should take if I want the
On Wed, 2011-03-02 at 13:45 -0500, Andrew Sullivan wrote:
On Wed, Mar 02, 2011 at 06:31:57PM +, Michael Black wrote:
Ok. I have been working with databases a few years but my first real
venture in to PostgreSql. I just want a plain simple index regardless if
there are duplicates
Hey folks,
The training (not sessions) schedule is up for trainings. You can get it
right off the front page: https://www.postgresqlconference.org/ . We are
running 7 sessions in parallel with a total of 9 trainings.
Sincerely,
JD
--
PostgreSQL.org Major Contributor
Command Prompt, Inc:
Hey folks,
The training (not sessions) schedule is up for trainings. You can get it
right off the front page: https://www.postgresqlconference.org/ . We are
running 7 sessions in parallel with a total of 9 trainings.
Sincerely,
JD
--
PostgreSQL.org Major Contributor
Command Prompt, Inc:
On Tue, 2011-03-01 at 15:57 -0500, Bill Moran wrote:
In response to Magnus Reftel magnus.ref...@gmail.com:
I'm working on a database that will have a very large number of users, and
I'm running in to a problem: when I grant more than about 2500 users access
to a schema, I get
Hey folks,
The training (not sessions) schedule is up for trainings. You can get it
right off the front page: https://www.postgresqlconference.org/ . We are
running 7 sessions in parallel with a total of 9 trainings.
Sincerely,
JD
--
PostgreSQL.org Major Contributor
Command Prompt, Inc:
On Mon, 2011-02-28 at 18:16 -0500, Gary Fu wrote:
It is set to 12GB.
Do you recommend to set fsync to off ? It needs to restart the server.
Not in production.
JD
Thanks,
Gary
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Hello,
Per the customary URL:
https://www.postgresqlconference.org/
JD
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc |
-General
How did we get the duckbill platypus? Cross Pollination of course and
today is the last day to get your content in for PostgreSQL Conference
East. A conference that is cross pollinating with MongoDB, one of those
NoSQL technologies. Now, we have experience, lots of experience on our
side
Hello hackers,
Just FYI, the CFP for PgEast in NYC closes in three days.
https://www.postgresqlconference.org/talk_types
Sincerely,
JD
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development,
On Wed, 2011-02-02 at 11:08 -0800, John R Pierce wrote:
On 02/02/11 10:32 AM, Carlos Mennens wrote:
I would create a seperate database for each thing that has nothing to do
with the other things.I doubt mediawiki and phpbb will ever share
any data, they are totally different
. You can't sum text. You need to
change the data type to a proper numerical type.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc
commands.
You can use psql (text based), pgadmin, navicat, and about 4 dozen
others.
Sincerely,
Joshua D. Drake
Thank you.
-Robert
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom
Hey folks,
PgEast is being held in NYC this year from 03/22-03-25. Get your papers
in, the deadline is soon!
http://www.postgresqlconference.org/
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support
On Tue, 2011-01-04 at 11:07 -0800, Dennis Gearon wrote:
I haven't been able to find anywhere, easily, in the documentation using
google
where a list of allowed data types for primary keys is.
Anything that can be UNIQUE NOT NULL
So, UUIDs can be primary keys?
Yes.
JD
--
On Fri, 2010-12-24 at 14:09 -0800, Rich Shepard wrote:
On Fri, 24 Dec 2010, John R Pierce wrote:
I'd check the permisisons on /usr/local/pgsql and /usr/local/pgsql/lib
too.
if that directory is not o+r, you'll have problems too.
John,
Bingo! The subdirectories in
December 16th, 2010: Celebrating 15 years of PostgreSQL, early.
Following on the smashing success of PostgreSQL Conference West,
PostgreSQL Conference West, The PostgreSQL Conference for Developers,
End Users and Decision Makers, is being held at the Hotel Pennsylvania,
in New York City from
Gnome and KDE and OpenOffice all have free simple query tools
On Wed, 2010-12-15 at 11:12 +1300, Brent Wood wrote:
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
SQL of course)
Sincerely,
Joshua D. Drake
-Carlos
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt
--
Sent
On Tue, 2010-12-07 at 08:31 -0500, Vick Khera wrote:
On Mon, Dec 6, 2010 at 2:31 PM, Joshua D. Drake j...@commandprompt.com
wrote:
Command Prompt is currently considering writing a patch to provide
synonyms to PostgreSQL. Is this something the community is interested
in? Do we have use
On Tue, 2010-12-07 at 09:14 -0500, Michael C Rosenstein wrote:
I won't press the issue for Postgres any further, but I will attest that
synonyms work quite elegantly in Oracle, provide valuable functionality,
and do not generally sow confusion among skilled developers. It sounds
like the
On Tue, 2010-12-07 at 19:54 +0100, Pavel Stehule wrote:
Hello
2010/12/7 Joshua D. Drake j...@commandprompt.com:
On Tue, 2010-12-07 at 09:14 -0500, Michael C Rosenstein wrote:
I won't press the issue for Postgres any further, but I will attest that
synonyms work quite elegantly in Oracle
still 32bit. You would have a problem
if one was 64bit. So you should be fine there.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com
On Wed, 2010-12-08 at 00:56 +, Jonathan Tripathy wrote:
Hi Everyone,
What does PG do with data that has been inserted into a table, but was
never committed? Does the data get discarded once the connection dies?
Yes, the transaction will rollback.
Thanks
--
PostgreSQL.org Major
/msg02043.php
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt
--
Sent via pgsql-general mailing list
On Mon, 2010-12-06 at 13:57 -0600, Andy Colson wrote:
On 12/6/2010 1:31 PM, Joshua D. Drake wrote:
Hey -general,
Command Prompt is currently considering writing a patch to provide
synonyms to PostgreSQL. Is this something the community is interested
in? Do we have use cases
On Mon, 2010-12-06 at 15:27 -0500, Tom Lane wrote:
Joshua D. Drake j...@commandprompt.com writes:
On Mon, 2010-12-06 at 13:57 -0600, Andy Colson wrote:
I dont understand the need for it. Dont view's do the exact same thing
(plus even more)? What does a synonym offer that a view does
On Wed, 2010-12-01 at 09:55 -0500, Vick Khera wrote:
On Wed, Dec 1, 2010 at 12:57 AM, Dann Corbit dcor...@connx.com wrote:
The ctid is not permanent. An alternative is to create tables with OID
values.
Creating OIDs gives you zero benefit over having a PK. They would be
roughly
On Mon, 2010-11-29 at 15:57 -0500, Vick Khera wrote:
On Mon, Nov 29, 2010 at 1:23 PM, Tom Lane t...@sss.pgh.pa.us wrote:
hubert depesz lubaczewski dep...@depesz.com writes:
straced postmaster when the problem was happening, and I was opening new
connections. strace looks like this:
[
On Mon, 2010-11-22 at 10:40 +1100, Elliot Chance wrote:
I would argue that if the person wants to use a forum, aren't they
saying they don't want to be contacted via email. I think we just throw
it only to the forum (that is the user) and leave it that. Forum users
don't get the _rich_
On Fri, 2010-11-19 at 17:45 -0500, Tom Lane wrote:
Adrian Klaver adrian.kla...@gmail.com writes:
Now I understand. I wonder if this would be a good time to ask about
whether pg_restore could be made to work with plain-text files:)
Not in any particularly useful way --- the plain text dump
On Thu, 2010-11-18 at 16:18 -0500, andrew wrote:
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.
What are you talking about? Source
On Thu, 2010-11-18 at 07:37 +0300, Allan Kamau wrote:
Hi,
I am experiencing the row is too big error (with postgreSQL-9.0.1)
when populating a table having a tsquery and tsvector fields.
Are fields of tsquery and tsvector datatypes affected by this row size
restriction?
Uhh... what index
On Mon, 2010-11-15 at 21:06 +0100, Magnus Hagander wrote:
I do think that the PostgreSQL lists are available there. And other
than that, they are on markmail.org, Nabble, etc. AFAIK several of
those allow both reading and posting. Is there actually something
about these interfaces that people
On Sat, 2010-11-13 at 19:21 +0100, Guillaume Lelarge wrote:
Le 13/11/2010 17:43, Raymond O'Donnell a écrit :
On 13/11/2010 03:43, Elliot Chance wrote:
Hi everyone,
This is my first post on the mailing list :)
As of today I have started the first dedicated postgres forum at:
On Fri, 2010-11-12 at 15:47 -0500, akp geek wrote:
Hi all -
I am trying to create an index on character varying field.
The
column is just character varying with no limit. I am getting the
following
error index row requires 10040 bytes, maximum size is 8191
What can I do the
On Sat, 2010-11-13 at 09:48 +0800, Craig Ringer wrote:
Thoughts, folks? Does this matter in practice, since anything you'd want
to index will in practice be small enough or a candidate for full-text
indexing?
I have run into this problem maybe 3 times in my whole career, precisely
On Fri, 2010-10-29 at 15:02 -0600, Rob Sargent wrote:
Not saying this excuses the crash necessarily or more importantly the
poor error message. One might find a stack trace in the system error log?
Think probably ran out of memory. 16M records? Really?
JD
--
PostgreSQL.org Major
transfer the data to postgresql.
Sure.
As I recall paradox just uses the dbf file format. So write an interface
with a dbf driver (perl, python, etc...) and use your native postgresql
interface.
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http
Hey,
Based on the discussion here:
http://www.commandprompt.com/blogs/joshua_drake/2010/10/users_versus_customers_-_you_dont_need_no_stinking_replication/
http://thebuild.com/blog/2010/10/28/small-postgresql-installations-and-9-0-replication/
stop service...
I know that a in a similar db where there is a lot of update the problem was
solved but I don't know how...
Some one Know this problem?
You are not vacuuming enough. If you vacuuum more often you should be
able to keep bloat down.
Joshua D. Drake
Thank's :)
--
View
On Tue, 2010-10-26 at 18:53 -0500, Martin, Brian D. (JSC-OD)[UNITED
SPACE ALLIANCE LLC] wrote:
Can a 32 bit PostgreSQL v. 9.0 db be copied from a 32 bit machine and
overwrite the db on a 64 bit PostgreSQL machine? I'm trying to get a good
initial starting point before performing hot standy
Hello,
As a reminder, PgWest 2010 is only 8 days away. Registrations are coming
in quickly so I suggest you get moving, if you are coming :D
Main site:
https://www.postgresqlconference.org/
Talks:
https://www.postgresqlconference.org/2010/west/talks
Registration:
Hey folks,
As a gentle reminder PgWest 2010 is two weeks away. In case you missed
it, Sun Microsystems Founder Scott McNealy will be presenting the
keynote. Here are the relevant links:
Agenda:
https://www.postgresqlconference.org/2010/west/agenda
Registration:
should possibly be rephrased to
indicate it's the OS not the physical hardware that is the issue.
No. Because PostgreSQL itself must also be the same architecture.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting
Hey,
Just an FYI -- the talk descriptions for PostgreSQL Conference West are
now up: https://www.postgresqlconference.org/2010/west/talks
JD
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development,
On Wed, 2010-09-29 at 14:21 -0700, David Kerr wrote:
Howdy,
Does anyone know of any tools or methods to handle centralized user
management within postgres?
I've got about 20 DB servers (and growing) each requiring a different number
and level of user access
(think dev, qa, staging,
not exist for Postgresql.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt
--
Sent via pgsql-general
that mammoth is basically gone?
Oh it's alive. We are down to the last feature of the 1.9 release before
going into the wild again. That said, no -- what we offer would not help
you.
We offer Master-N-Slave replication.
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt
On Fri, 2010-09-24 at 13:15 -0400, Carlos Mennens wrote:
I am using PostgreSQL to hold my entire I.T. inventory for my company.
I am manually entering the data in via hand through the Linux command
line and the 'psql' utility which is great for me but other co-workers
in I.T. have no
On Fri, 2010-09-24 at 22:55 +0200, Leif Biberg Kristensen wrote:
On Friday 24. September 2010 20.04.26 Lincoln Yeoh wrote:
Then again, does Tom ever sleep? Maybe he sleeps in the afternoon? Or
is that when he does intensive coding?
Once there was a suggestion on this list to give Tom
and then replicate the data to the new server.
Is there anyway to reclaim the space (the space used up by the tables
themselves are less than 20G).
Not without an outage on the relation.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com
On Tue, 2010-09-21 at 14:56 -0500, Rhys A.D. Stewart wrote:
hey all,
I think versioned pl/[pgsql|python|perl|bash|java] functions would be
a great addition to 9.1. Imagine that instead of CREATE OR REPLACE
FUNCTION you could do CREATE AND VERSION FUNCTION and then all
modifications to the
On Tue, 2010-09-14 at 17:01 -0700, David Fetter wrote:
On Wed, Sep 15, 2010 at 05:30:51AM +0530, tamanna madaan wrote:
I know upgrading postgres will resolve the problem permanently .
But I wanted some workaround for now before I actually upgrade.
I want a pony, but I'm not getting one.
take an LVM (or similar) snapshot of an application that can't
be paused in a way to provide a consistent filesystem.
You need to read up on things like WAL and MVCC.
Joshua D. Drake
--
Joost
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com
On Fri, 2010-09-10 at 13:39 -0400, Merlin Moncure wrote:
IDK...functions do everything 'DO' does, and support returning data,
which is necessary to support RETURNING. Rules are already fairly
capricious and problematic and I doubt any proposal that doesn't fix
or work around their basic
that. We missed the push to the repo on RC13. They should be
up in the next hour.
Joshua D. Drake
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, 2010-09-02 at 14:04 +1200, Phil Jackson wrote:
Does anyone have any suggestions?
What does the ODBC log say?
What does the PostgreSQL Log (or event viewer) say?
JD
Cheers
Phil Jackson
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ -
while restoring.
if command contains any compress option, it won't work
Compress will not work in plaintext format for restore. You need to use
-Fc and then pg_restore.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
On Tue, 2010-08-31 at 20:17 -0400, Merlin Moncure wrote:
This is where the interesting thing happens: On MySQL the query actually
works as intended, but it doesn't on PostgreSQL. As I said, I'm sure this is
not a bug in PostgreSQL, but the lack of a stupid user trick. While my
project is
On Mon, 2010-08-30 at 15:42 -0400, Vick Khera wrote:
On Mon, Aug 30, 2010 at 10:08 AM, Marco Colombo pg...@esiway.net wrote:
Well, my idea was more along the line of automatically try to acquire a
reasonable amount of the available resources.
I challenge you to defined reasonable in a
for MacOS
per:
http://www.postgresql.org/docs/8.4/static/kernel-resources.html
And then initdb.
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http
301 - 400 of 2121 matches
Mail list logo