robjsarg...@gmail.com (Rob Sargent) writes:
On 03/04/2011 04:54 AM, Vibhor Kumar wrote:
On Mar 4, 2011, at 5:17 PM, Andrew Sullivan wrote:
On Thu, Mar 03, 2011 at 08:03:59PM -0700, Gauthier, Dave wrote:
Hi:
I have to update all the records of a table. I'm worried about
what the table
prabakara...@zohocorp.com (prabakaran.a) writes:
Dear All,
In Mysql, If we create a directory under mysql/data, mysql treated as
database instance without starting mysql server.
Is there any similar provision in postgres where we can create a
database instance without starting postgresql
li...@serioustechnology.com (Geoffrey Myers) writes:
Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
cut and paste:
set ON_ERROR_ROLLBACK;
Should be
\set ON_ERROR_ROLLBACK on
You can also set this when calling psql like so:
psql --set
atsaloli.t...@gmail.com (Aleksey Tsalolikhin) writes:
Situation: Disk usage on production server root filesystem is at 68%
utilization (80 GB used), on DR is at 51% (56 GB used). We use
SlonyII-1.2.x to keep the DR up to date. I would like to account for
the 24 GB difference.
It's more
peter.geoghega...@gmail.com (Peter Geoghegan) writes:
On 1 February 2011 03:52, Scott Marlowe scott.marl...@gmail.com wrote:
You can reclaim that space by doing a cluster or vacuum full on the
subject table.
Yes, but this is a fairly bad idea, particularly prior to PG 9.0 . 9.0
has a new
carlos.menn...@gmail.com (Carlos Mennens) writes:
I was sitting down thinking the other day about when is it good to
generate a new database or just use an existing one. For example, lets
say my company name is called 'databasedummy.org' and I have a
database called 'dbdummy'. Now I need
hero...@unicell.co.il (Herouth Maoz) writes:
As a result of my recent encounter with table bloat and other tuning
issues I've been running into, I'm looking for a good resource for
improving my tuning skills.
My sysadmin ran into the following book:
PostgreSQL 9.0 High Performance, by
guilla...@lelarge.info (Guillaume Lelarge) writes:
Le 26/01/2011 23:13, Tom Lane a écrit :
Guillaume Lelarge guilla...@lelarge.info writes:
Le 26/01/2011 22:29, Lawrence Cohan a écrit :
All I need is to at least be able and save a userid(current_user),
timestamp, action, and the name of the
Robert Paresi firstn...@lastname.net writes:
Hello,
We have 700 user install base using Sybase SQL Anywhere 9.02
We are looking at migrating these installations over to PostGres
1. Very Very Short Answer Please - why should we?
Cheaper? Perhaps faster? It's tough to guess, absent of
m...@smogura.eu (Radosław Smogura) writes:
In any approach preventing gaps, locking is required. This is real life
situation; imagine you have two coworkers and then they need to create
invoices, so they looks in ledger (or a last day copy of ledger in their
offices; international company,
wmo...@potentialtech.com (Bill Moran) writes:
If the chance of a duplicate is 1 in a hundred gazillion, then I can
still hit a dupe the VERY FIRST TIME I USE IT.
I'm writing software that is intended to be used to save lives in the
event of an earthquake or flood or cosmic ray flipping bits
dennis.jenkins...@gmail.com (dennis jenkins) writes:
The UUID itself is 128 bits. Some of those bits are pre-determined.
I don't recall, but I think that a normal UUID has 121 bits of
randomness.
That doesn't match RFC 4122 very well...
It indicates 5 forms of UUIDs:
1) Time-based, where
dal...@solfertje.student.utwente.nl (Alban Hertroys) writes:
On 6 Jan 2011, at 17:51, Chris Browne wrote:
wmo...@potentialtech.com (Bill Moran) writes:
If your system is sufficiently negligently designed that this particular
conflict causes it to kill people, then I wouldn't be too inclined
dal...@solfertje.student.utwente.nl (Alban Hertroys) writes:
From wikipedia, only after generating 1 billion UUIDs every second for
the next 100 years, the probability of creating just one duplicate would
be about 50%. The probability of one duplicate would be about 50% if
every person on
a...@crankycanuck.ca (Andrew Sullivan) writes:
On Wed, Jan 05, 2011 at 12:41:43PM -0700, Scott Ribe wrote:
I'm not sidestepping the point at all.
You may be missing it, however, because. . .
The point is that the finiteness of the space is a red herring. The
space is large enough that
d.w...@computer.org (David Wall) writes:
We're using UUID for primary keys in PG 8.4 without any issues. I
have no real insights into the details or performance issues, but
always figured it was stored as a binary 128-bit value, but with added
benefits of being able to enter and view them
gvi...@gmail.com (gvim) writes:
If a table representing contact details can have 2 but no more than 2 email
addresses is it really worth factoring-out email addresses to a separate
table. Technically it's a 1-to-many relationship so should be done this way
but what is the general practice
gvi...@gmail.com (gvim) writes:
I'm putting together a database for a web project which has a lot of
HR components which I imagine are fairly standardised so, to avoid
re-inventing the wheel, is there a source of standard, downloadable
schemas for common projects?
One might imagine so...
The
gwch...@gmail.com (Gary Chambers) writes:
What is the best tool of data modeling and ER diagram for PostgreSQL.
http://wiki.postgresql.org/wiki/GUI_Database_Design_Tools
Although it may not be considered a tool for use in the design (per
se) of a database, I would highly recommend that
andrew and...@mytrashmail.com writes:
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.
Are you thinking about this announcement?
kamaual...@gmail.com (Allan Kamau) writes:
I agree with Merlin, There is a surprising big number of good
technology companies (including Google) out there using MySQL. For
sometime I have been wondering why and have come up with a few
(possibly wrong) theories. Such as: these companies are
matthieu.h...@wallix.com (Matthieu Huin) writes:
Greetings,
Does anyone here have any experience with tags schemas on postgresql ?
I am struggling with a schema inspired by scuttle described here :
http://www.pui.ch/phred/archives/2005/04/tags-database-schemas.html
Performances drop
mgo...@intermodalsoftwaresolutions.net (Michael Gould) writes:
What and why should I look at certain distributions? It appears from
what I read, Ubanta is a good desktop but not a server.
There are Ubuntu versions that don't promise support (e.g. - ongoing bug
security fixes, and such) for
te...@chosen-ones.org (Terry Lee Tucker) writes:
Lately, I've begun using views quite often especially when queries for
various
reports, etc. become complicated. I am now wondering if there is a price to
pay in terms of overhead for this. In truth, I don't really understand how a
view
dp...@pgadmin.org (Dave Page) writes:
On Tue, Oct 12, 2010 at 2:58 AM, Peter C. Lai pe...@simons-rock.edu wrote:
On 2010-10-11 05:57:37PM -0600, David Boreham wrote:
On 10/11/2010 5:46 PM, Carlos Mennens wrote:
Just wondering how you guys feel about NoSQL and I just wanted to
share the
mcham...@gmail.com (Mauricio Chamati) writes:
Postgree is the most amazing DB, even more it will be the only one that will
remain free (the good ones) as MySQL has been taken. In order to move on with
this project, as an Java Senior Architect, I am recomming to you guys to have
an special
carlos.menn...@gmail.com (Carlos Mennens) writes:
Just wondering how you guys feel about NoSQL and I just wanted to
share the following article...
http://www.linuxjournal.com/article/10770
Looking to read your feedback and / or opinions.
There's a lot there to agree with, and a lot to not
johnlich...@gmail.com (John Cheng) writes:
Congrats on the 9.0 release of PostgreSQL. One of the features I am really
interested in is the built-in binary replication.
Our production environment has been using PostgreSQL for more than 5 years
(since this project started). We have been using
yasinma...@gmail.com (paladine) writes:
Hi all
I prefer doing pg_dump - psql restore to vacuum full and
is there anyone know whether postgresql can insert data concurrently while
restoring a table for not losing any data.
thanks in advance...
The problem scenario that I'd expect is with
m...@tplus1.com (Matthew Wilson) writes:
Just recently I discovered the listen/notify feature in postgresql.
Now I don't have external processes polling tables, watching for new
inserted rows.
Anyhow, I'm curious if there is some other feature that will help me out
with a new puzzle.
I
passionate_program...@hotmail.com (RP Khare) writes:
Is there any way to schedule PGSQL databases backups? I want to
take hourly dumps of my production database.
Sure.
You can use whatever tool you already have to schedule running
pg_dump.
On Unix-like systems, you almost always have a
jsmg...@numericable.fr (John Gage) writes:
Is there an equivalent of svn/git etc. for the data in a database's
tables?
Can I set something up so that I can see what was in the table two
days/months etc. ago?
I realize that in the case of rapidly changing hundred million row
tables this
shik...@air.co.jp (Iwao Shikase) writes:
If I mount the database cluster with caching in my environment, What kind of
problem I will meet? Please give the information about the problem you met.
If you use NFS, and are not absolutely certain of the semantics of the
implementation, then you are
cr...@postnewspapers.com.au (Craig Ringer) writes:
OpenLDAP is a pretty solid LDAP server these days, and I highly
recommend it for use as an authentication database. By default it uses
Berkeley DB as a backend, which is quite acceptable with newer versions
of Berkeley DB that provide decent
bnich...@ca.afilias.info (Brad Nicholson) writes:
Scott Marlowe wrote:
As with phrases like, the quickest way to grill a unicorn steak,
that it can be stated in a few words does not make in possible.
Exactly. The big issue here is that nobody's saying what kind of app
they want to write.
avbid...@fortytwo.ch (Adrian von Bidder) writes:
Heyho!
(Ok, seems to be feature wish day ...)
I was wondering if others would find an IMMUTABLE (or whatever) column
constraint useful as well. Semantics would (obviously?) be to disallow
changing the value of this column after insert.
I
t...@sss.pgh.pa.us (Tom Lane) writes:
Peter Eisentraut pete...@gmx.net writes:
On lör, 2010-06-12 at 11:18 +0200, John Gage wrote:
A one file html version would be a godsend.
I've committed a build target for that now. Use 'make postgres.html' in
doc/src/sgml/.
Huh, is that actually
jus...@magwerks.com (Justin Graf) writes:
Its also available in chm windows help file format. Which i find allot
more useful
http://www.postgresql.org/docs/manuals/
you could print chm to a text file.
also it not hard to dump a PDF document into a text file.
I wish I could find a
dm.a...@gmail.com (DM) writes:
It is not real time, updates every 5 mins should be fine.
But the DB2 database is real busy and its real performance based.
The book Scalable Internet Architectures (by Theo Schlossnagle) has
an example of how to build a trigger-based replication system copying
Michal Szymanski dy...@poczta.onet.pl writes:
Hi,
Currently we use Debian, but it chosen by our OS admnistrator. Now we
can change our OS and it is question what Linux edition will be the
best. We would like have access to new versions of Postgres as soon
as possible, for Debian sometimes we
len.wal...@gmail.com (Len Walter) writes:
I need to populate a new column in a Postgres 8.3 table. The SQL would be
something like update t set col_c = col_a +
col_b. Unfortunately, this table has 110 million rows, so running that query
runs out of memory.
Unnecessary. On Oracle, the
Chris Browne cbbro...@acm.org writes:
len.wal...@gmail.com (Len Walter) writes:
I need to populate a new column in a Postgres 8.3 table. The SQL would be
something like update t set col_c = col_a +
col_b. Unfortunately, this table has 110 million rows, so running that
query runs out
m...@kitchenpc.com (Mike Christensen) writes:
I have a table that stores a user ID and a subscription type, and this is
really all it needs to store and any pair of values will always be unique. In
fact, I think this pair should be the primary key on the table. However, I'm
using Castle
dcor...@connx.com (Dann Corbit) writes:
(Commercial use of MySQL without paying a license fee requires that
projects using the database are also GPL, IIRC).
I know I've seen Monty say this sort of thing a lot of times, and his
most recent rant
thomas.granv...@gmail.com (Thomas Løcke) writes:
There's a new series of PostgreSQL books available:
PostgreSQL 8.4 Official Documentation - Volume I
PostgreSQL 8.4 Official Documentation - Volume II
And so on, up to volume V I think.
Would I be supporting the PostgreSQL project by buying
paul_t...@fastmail.fm (Paul Taylor) writes:
If instead you have to run a database standalone, then you do hit
configurations problems, not only platform specific issues but also
people bloody mindness about creating databases with different names
and database users : whatever the documentation
phoenix.ki...@gmail.com (Phoenix Kiula) writes:
My question: how can I use PostgreSQL 8.3 and SVN on the same server?
Has someone figured out how to fix this situation? I'm on CentOS 5 x64
bit.
RPM has a --replacefiles option which might either help or hurt...
I think there's a fair chance
lizz...@gmail.com (Lizzy M) writes:
I have an problem: can postgresql store its data on the raw disks now?
I have checked the mail list and manual, but havent found the
answer. In some early mails, they mentioned pg didnt support this
character. But how about now? Raw disk may
Carlos Oliva oli...@earthlink.net writes:
Would the backup be unrecoverable if I shutdown the databse first?
If the backup includes pg_xlog and pg_clog, as well as all of the
database metadata files, then whatever portions *are* included are
likely to be somewhat usable.
The portions not
Carlos Oliva car...@pbsinet.com writes:
Is there a way to create a database or a table of a database in its own
folder? We are looking for ways to backup the sytem files of the database
to tape and one to exclude some tables from this backup. We can selectively
backup folders of the file
Carlos Oliva car...@pbsinet.com writes:
Is there a way to create a database or a table of a database in its own
folder? We are looking for ways to backup the sytem files of the database
to tape and one to exclude some tables from this backup. We can selectively
backup folders of the file
kentil...@gmail.com (Kenneth Tilton) writes:
Just looking for postgres best practices input from the veterans:
OIDs are decidedly a bad idea; the difference between natural IDs
and surrogate IDs is a general database issue that is fairly well
documented in the literature and is not notably a
x...@thebuild.com (Christophe) writes:
On Apr 21, 2009, at 12:28 PM, Peter Eisentraut wrote:
Yes, but if you are asking that question, you probably really want
to use
TRUNCATE.
The advantage of DROP TABLE being, of course, that DROP TABLE is
transactionally-safe, while TRUNCATE is not.
ianm...@tesco.net (Ian Mayo) writes:
On Wed, Apr 8, 2009 at 8:13 PM, Robert Treat
xzi...@users.sourceforge.net wrote:
Maybe I've been reading too much Pascal again lately, but if only 1% of your
rows are going to have data in this column, personally, I'd put it in a
separate table.
thanks
juankarlos.open...@gmail.com (Juan Pereira) writes:
Quite interesting! The main reason why we thought using a table per
truck was because concurrent load: if there are 100 trucks trying to
write in the same table, maybe the performance is worse than having
100 tables, due to the fact that the
phoenix.ki...@gmail.com (Phoenix Kiula) writes:
On Wed, Mar 4, 2009 at 12:55 AM, Phoenix Kiula phoenix.ki...@gmail.com
wrote:
I guess my question is, how should I remove all pending locks on a
table so that I can get on with the rest of the stuff?
I mean, even if I can now find an offending
I have been trying to set up pl/pgsql code to generate and evaluate
{SSHA} passwords, with somewhat limited success.
{SSHA} is a password scheme that uses SHA-1 along with salting to ward
off dictionary attacks. Apparently it's used quite a bit with LDAP.
There does not seem to be a claimed
tekion tek...@gmail.com writes:
I know that MySQL can only use one index at at time for query. Does
Postgres has this same limitation? For example, the following query:
select uid,count(uid) from A, B where A.uid = B.uid and date between
date and date
MySQL will either use index on uid or
rshep...@appl-ecosys.com (Rich Shepard) writes:
[2] Strangely enough -- to me, at least -- the lack of full support for
date- and time-based SQL in database tools such as PostgreSQL is puzzling.
Virtually all business-related databases (think accounting systems as a
prime example) depend on
[EMAIL PROTECTED] (Tom Lane) writes:
Scott Marlowe [EMAIL PROTECTED] writes:
We really need a favorite Tom Lane quotes thread. Mine is (roughly):
We don't support that, but you're free to try it, you just get to keep
both pieces if it breaks.
Hate to disillusion you, but that's a standard
[EMAIL PROTECTED] (Ioana Danes) writes:
I've been wondering if anybody tried to use the postgresql csv log
file to replicate sql statements. I've been looking into it in the
past days and after a brief testing it doesn't look bad at all...
It's *plausible*, but you have to ensure that you
[EMAIL PROTECTED] (Scott Marlowe) writes:
I assume hardware failure rates are zero, until there is one. Then I
restore from a known good backup. compressed file systems have little
to do with that.
There's a way that compressed filesystems might *help* with a risk
factor, here...
By
[EMAIL PROTECTED] (Tom Lane) writes:
We already have the portions of this behavior that seem to me to be
likely to be worthwhile (such as NULL elimination and compression of
large field values). Shaving a couple bytes from a bigint doesn't
strike me as interesting.
I expect that there would
https://www-927.ibm.com/ibm/cas/cascon/papers/papers.shtml#1
Tuesday, October 28 paper presentations
Session 1: Databases
DBMS Workload Control Using Throttling: Experimental Insights
Best Paper
Wendy Powley and Pat Martin, Queen's University; Paul Bird, IBM Toronto Lab
Today's Database
[EMAIL PROTECTED] (Anderson dos Santos Donda) writes:
Is there a way to execute a simple shell script in server after execute
INSERT INTO ?
Example?
INSERT INTO clients (name) VALUES ('Donda');
after it, execute shell : mkdir $1
You could do this, directly, via stored procedure languages:
A question came up on the Slony-I list (quite a while ago, but that's
another story!) as to the handling of floating point values.
The user is concerned about whether FP values are faithfully
replicated. I commented that the issue will be identical to that of
the handling of data in pg_dump; if
[EMAIL PROTECTED] (Roberts, Jon) writes:
Roberts, Jon wrote:
My top 10 reasons why companies pick Oracle.
Do you mean they actually get these things, or they imagine they do?
Huh? Companies buy Oracle all of the time.
That's not the point.
The question isn't whether they buy *Oracle*
[EMAIL PROTECTED] (Amber) writes:
We know PostgreSQL uses one dedicated server process to serve one
client connection, what we want to know is whether PostgreSQL use
multiple threads inside agents processes to take advantage of
multiple CPUs. In our site we have only a few concurrent
[EMAIL PROTECTED] (Phoenix Kiula) writes:
See, this is where I get confused. I want to upgrade from 8.2.3 to
8.3.3. The recommendation is to try Slony. So I download Slony and try
to configure it. The configure command gives me this:
checking for correct version of PostgreSQL... error
[EMAIL PROTECTED] (Phoenix Kiula) writes:
On 8/26/08, Tomasz Ostrowski [EMAIL PROTECTED] wrote:
I think nobody would guide you step by step. Either read documentation
and do it yourself or hire an expert:
Thanks. I suppose that spirit is quite evident in the documentation.
Why make it
[EMAIL PROTECTED] (David Siebert) writes:
Well I am kind of stuck using OpenSuse. Not a bad distro and is the one
we use in our office for production work.
I like CentOS myself for database work and tend to use that for test
systems here since I manage them myself.
I was more wondering if
[EMAIL PROTECTED] (John Tregea) writes:
I have been asked to specify a pair of HP PC's to set up a
PostGreSQL server (and backup) for a client. The HP model we are
looking at has an AMD Phenomâ,,¢ Quad Core Processor (9600B). The
machines would be running Windows XP Pro (our clients
[EMAIL PROTECTED] (Martijn van Oosterhout) writes:
On Fri, May 30, 2008 at 03:07:17AM +0930, Shane Ambler wrote:
Exactly. The real problem is that the first one to apply for a patent
gets it. It really doesn't matter who invents it. If we have patents
that cover our work then we can control
[EMAIL PROTECTED] (Kaloyan Iliev) writes:
And what about RT (Request Tracker - http://bestpractical.com/rt/)
.
AFAIK it is free and open-source, uses Postgres and is easy to setup.
RT has a very different purpose; it was designed to track work (e.g. -
work tickets), as opposed to managing web
[EMAIL PROTECTED] (Joshua D. Drake) writes:
Gauthier, Dave wrote:
Ive been invited to participate in a forum which discusses
technical issues for relational DBs used in the corporation. The 3
DBs they are discussing are Oracle, SQL-Server and MySQL. Id like
to introduce PG, but want to be
[EMAIL PROTECTED] (Ivan Sergio Borgonovo) writes:
On Sat, 10 May 2008 07:35:36 +0200
Pavel Stehule [EMAIL PROTECTED] wrote:
your application different execution paths. Generally I can say, so
plpgsql isn't well language for this games, and better is using
plperl, plpython or other external
[EMAIL PROTECTED] (Robert Treat) writes:
On Thursday 01 May 2008 13:40, Tom Lane wrote:
7.4 was released 2003-11-17, so I think that it will very likely get
obsoleted at the end of 2008.
If that's the case, it'd be nice to get an official statement of that now. :-)
People have been making
[EMAIL PROTECTED] (Robert Treat) writes:
I feel like some type of counter-argument is that this is probably longer
than one would expect thier database software to last. :-)
That has the counterargument that if the database software works, it's
likely to get used for longer than one would
[EMAIL PROTECTED] (Oliver Helm) writes:
Hello,
I was wondering if if is possible to add a note against a field on a
postgresql table?
For example when running \d tablename i would like to have and additional
column called 'notes' which i could add to by altering the table. As the
[EMAIL PROTECTED] (Andrew Sullivan) writes:
On Wed, Apr 23, 2008 at 07:46:07PM -0400, brian wrote:
Absolutely true. Which is odd, because this example is trotted out
whenever there's a thread about ENUMs.
I don't think it's odd at all. In my view, the people who think enums are a
good
[EMAIL PROTECTED] writes:
How can I make a Update of a column in a very large table for all
rows without using the double amount of disc space and without any
need for atomic operation?
You may need to redefine the problem.
I have a very large table with about 60 million rows. I sometimes
[EMAIL PROTECTED] (Csaba Nagy) writes:
On Sun, 2008-04-20 at 11:32 -0600, Scott Marlowe wrote:
On Sun, Apr 20, 2008 at 11:12 AM, Scott Ribe [EMAIL PROTECTED] wrote:
I am going to play with this and see where it breaks, but it's going to
be
an enormous time investment to babysit it.
[EMAIL PROTECTED] (Scott Marlowe) writes:
What I keep dreaming of is a process that lets slony use pg_bulkloader
or something like it to do the initial load...
Does there seem to be some likelihood of some portion of pg_bulkloader
getting added to core? It sounds like it's worth looking at
[EMAIL PROTECTED] (Joshua D. Drake) writes:
On Thu, 17 Apr 2008 22:19:23 -0500
Josh Trutwin [EMAIL PROTECTED] wrote:
Is your presentation available online at all?
Blogging the bad boy up right now Will be available soon.
The presentation seems pretty good...
... But what is more
[EMAIL PROTECTED] (Alvaro Herrera) writes:
Geoffrey wrote:
Joshua D. Drake wrote:
On Fri, 18 Apr 2008 14:30:18 -0400
Geoffrey [EMAIL PROTECTED] wrote:
I don't know that slony is the answer. It was more of a question
then an answer. We are hoping to use that solution to migrate from
[EMAIL PROTECTED] (Andrew Sullivan) writes:
Oh, one other thing
On Thu, Apr 17, 2008 at 12:44:51PM +0800, Craig Ringer wrote:
One way I can think of doing it is to write a seen_log that notes what the
client has already seen with a timestamp of (say) 1 minute. Then you can
say go
[EMAIL PROTECTED] (Richard Broersma) writes:
I don't believe that DDL Triggers exist, correct?
That is correct.[1]
The usual point is that you cannot attach triggers to pg_catalog
tables, which would be the obvious way of trying to notice DDL
changes. (e.g. - by having triggers that would
[EMAIL PROTECTED] (Terry Lee Tucker) writes:
Is there a distinction between ORIGIN and LOCAL as related to
session_replication_role, and if so, what is it? I am unable to understand
from the documentation any distinction between the two settings.
The intent is that a system that is the
[EMAIL PROTECTED] [EMAIL PROTECTED] writes:
Let me just start off by saying that I *want* to use postgresql.
That's my goal. I do not want to use SQLServer. I'm posting this
message not to slam postgres, but to ask for someone to help me figure
out what I'm doing wrong.
I've used postgres
[EMAIL PROTECTED] (Ivan Sergio Borgonovo) writes:
Is there a switch (php side or pg side) to avoid things like:
pg_query(select id from table1 where a=$i);
into becoming
pg_query(select id from table1 where a=1 and 1=1; do something
nasty; -- );
So that every
pg_query(...) can contain
[EMAIL PROTECTED] (W S) writes:
I was asked this question, and I wasn't sure if it is possible:
do you know of a way to stop just one database (not delete/drop) on
our PostgreSQL 8.1 server?
And, while I know how to shut down postmaster, and/or put in rules to
pg_hba.conf to limit access
[EMAIL PROTECTED] (Roberts, Jon) writes:
I am moving from Windows to Solaris and I need pgcrypto and dblink.
Where are these? I don't see anything in the configure that suggests it
is even an option.
They are part of the set of contrib functions.
You head to directory contrib, and, if those
[EMAIL PROTECTED] (Keaton Adams) writes:
That is an interesting question. If our organization were to help fund the
development of such a feature, would that be something taken into
consideration by the development team?
I seem to recall there being a relevant Google Summer of Code project
[EMAIL PROTECTED] (Steve Atkins) writes:
There are no existing clashes with system tools that I'm aware of. Are
there any? Most of the clashes are with other installations of
postgresql installed on the same machine, so if name clashes is the
real reason for the change, then the version number
[EMAIL PROTECTED] (Craig Ringer) writes:
Erik Jones wrote:
They've gotten around that by making MySQL dual-licensed. If
you're going to be using MySQL in a commercial application then you
can not use the GPL'd version, you have to use their paid,
commercial license.
My understanding is
[EMAIL PROTECTED] (David Wall) writes:
What then? Could it be marketing or the sad results of a avalanche
effect? Geee, there's a thought.
What a wide variety of topics. One big difference for me is that
MySQL used to be open source, but it no longer is. It's an odd hybrid
OSS that barely
[EMAIL PROTECTED] (Christian Teguh) writes:
Hi guys, i just wondering, i there a way to make PostgreSQL database
like M$ Access. That have only single or several files without
installing it.?? Thanks for your attention.
No, there isn't, just as there isn't a make it faster flag.
If you truly
[EMAIL PROTECTED] (Andrej Ricnik-Bay) writes:
On 01/02/2008, Tony Caduto [EMAIL PROTECTED] wrote:
The part about the BSD license is bogus. A BSD license is the most
desirable of any Open Source license and gives you the right to use
PostgreSQL in your commercial apps without worry.
While I'm
[EMAIL PROTECTED] (Ow Mun Heng) writes:
Just wondering if my 'Perceived' feeling that since implementing slony
for master/slave replication of select tables, my master database
performance is getting slower.
I'm constantly seeing a very high amount of IO wait. ~40-80 according to
vmstat 1
Kico Zaninetti [EMAIL PROTECTED] writes:
Hi all.
I have a database with 62 million registers and I have to make a
SELECT using LIKE.
This is my select:
SELECT * FROM phone WHERE name LIKE = '%ZANINETTI%' AND city = 'SAO
PAULO' AND state = 'SP'
I have an index created like this:
CREATE
1 - 100 of 305 matches
Mail list logo