On Fri, 2009-11-20 at 17:57 +0100, Alexandra Roy wrote:
Hi all,
I see in the ora2pg documentation on
http://www.darold.net/projects/ora2pg/ that DBD::Pg is optional and
needed only for 'on the fly' migration.
I need to clarify this...
Does someone can explain me that is under 'on the
On Fri, 2009-11-20 at 12:59 -0500, Chris Barnes wrote:
Would someone have a tool that displays statement execution
times/stats from the standard output from postgres logs?
I have attempted pgfouine but not had sucess with the log format.
Does anyone use pgfouine or have something that
-theory.co.uk/
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
If the world pushes look it in the eye and GRR. Then push back harder. -
Salamander
On Thu, 2009-11-19 at 12:05 -0800, ar...@esri.com wrote:
What are the issues with Redhat 4 in terms of supporting libxml? I build
PostgreSQL 8.4 with --with-libxml option but still getting the following
error.
You probably need to tell postgresql to compile against the specific new
version
solution. Check out:
https://projects.commandprompt.com/public/pitrtools
Its BSD licensed.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
If the world pushes
xubuntu and postgres from
source installed. Don't use source unless you have to.
Joshua D. Drake
Thanks, reno
**
This email and any attachments may contain confidential or privileged
into a LOT of
trouble :P
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
If the world pushes look it in the eye and GRR. Then push back harder. -
Salamander
not
involve any explicit setting of this parameter.
The documentation deprecates setting this variable to true. Why does
pg_dump do it?
It is picking up objects that have OIDS.
Joshua D. Drake
TIA!
Kynn
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http
On Mon, 2009-10-26 at 21:36 +, Peter Geoghegan wrote:
Sure ? You *have to* ask for the ParisTech rooms (there were still 10 rooms
available on friday, only for Paristech) Else the hotel is full.
I called on Saturday afternoon. I was sure to specify that I was a
Paristech member, but
.
There is a community after-party being worked on here:
http://wiki.postgresql.org/wiki/After-Thing
And rumblings of other events.
As always we look forward to seeing you there!
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
On Thu, 2009-10-08 at 19:16 -0600, Scott Marlowe wrote:
On Thu, Oct 8, 2009 at 2:22 PM, Merlin Moncure mmonc...@gmail.com wrote:
The #1 tool you have at your disposal is the human brain. I
personally think GUI database tools are counter productive and huge
time wasters. SQL requires
across the network and then filters out the results only
displyaing the results you want to see. I've seen this happen a lot at my
company, but it may be related to the type of queries being run, so you
may experience different results.
You solve that with pass through queries.
Joshua D. Drake
the offending weed down).
If you would like flowery prose, sorry. It isn't my talent.
Other than that... welcome to Open Source. We speak our minds, in plain
site. I hope you stay and help us with the best opens source database on
the planet.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
in this thread that it makes more
sense for you to use -Fc but your speed isn't going to change all that
much overall.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development
On Tue, 2009-10-06 at 22:59 +0200, Krzysztof Barlik wrote:
Hi,
is it possible to force pg_dumpall to ask for
password only once (connecting as superuser 'postgres') ?
Entering it for every database is a bit annoying.
take a look at .pgpass documentation
Thanks,
Krzysztof
--
in such a group, so I'm like to see if there are
enough people interested to make it viable.
Please contact me off-list if you'd like to be involved.
You may want to check with pgeu-general.
Joshua D. Drake
Many thanks,
Ray O'Donnell
hitting this error. I've turned off virus scan it seems to have no
effect.
It means the permissions on the physical file are such that your
postgres service user can't read them.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com
:-).
There is not a specific format but a good thing to do is:
Request Feature
Provide Use Case
Provide Example syntax (if applicable)
Joshua D. Drake
Tim
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development
schedule is up:
http://www.postgresqlconference.org/2009/west/schedule
And our registration is up:
http://www.postgresql.us/purchase
Remember folks, all proceeds are a donation to United States (PgUS)
PostgreSQL. A United States 501c3.
Joshua D. Drake
--
--
Sent via pgsql-general mailing list
is not part of the core distribution.
http://pgfoundry.org/projects/pljava/?downloads
Joshua D. Drake
Thanks,
Sandra Arnold
Sr. DBA
DOE/OSTI
Oak Ridge, TN
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support
the
installation process?
pljava is a mess. you either use GCJ which is only-sorta-java, or you
drag the whole JVM in with every instance of postgres, ugh!
If you check the archives there were very specific reasons for that.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc
On Thu, 2009-09-17 at 11:48 -0600, Scott Marlowe wrote:
I'm trying to do a parallel restore with pg_restore -j but I'm only
seeing one CPU being used really. The file is custom format, but was
made by pg_dump for pgsql 8.3. Is that a problem? Do I need a backup
made with 8.4 to run parallel
On Thu, 2009-09-17 at 12:05 -0600, Scott Marlowe wrote:
On Thu, Sep 17, 2009 at 12:00 PM, Joshua D. Drake j...@commandprompt.com
wrote:
On Thu, 2009-09-17 at 11:48 -0600, Scott Marlowe wrote:
I'm trying to do a parallel restore with pg_restore -j but I'm only
seeing one CPU being used
On Thu, 2009-09-17 at 12:15 -0600, Scott Marlowe wrote:
On Thu, Sep 17, 2009 at 12:12 PM, Joshua D. Drake j...@commandprompt.com
wrote:
On Thu, 2009-09-17 at 12:05 -0600, Scott Marlowe wrote:
On Thu, Sep 17, 2009 at 12:00 PM, Joshua D. Drake j...@commandprompt.com
wrote:
On Thu, 2009
this (maybe statement_timeout)?
statement_timeout will terminate a query not a connection.
Are there any other possibilities?
Fix your code. Not to sound harsh but this is blatant code issues.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com
Then there will likely be something to the affect of:
psql -U user db /usr/share/postgresql/8.3/contrib/postgis.sql (or
something like that)
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom
On Fri, 2009-08-21 at 11:56 -0700, David Kerr wrote:
Is there an easy way, that I'm missing, where I can export a schema from
database A and then rename it on load into database B?
pg_dump -s foo|psql bar
I use similar functionality in oracle all the time and it's great for
development
notice much difference. However, as I recall FF just
uses SQLite, so if you want an interface to that it would be easy
enough.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com
On Fri, 2009-08-07 at 17:36 +0100, Sam Mason wrote:
On Fri, Aug 07, 2009 at 11:11:10AM -0500, Wenjian Yang wrote:
We currently installed emacs 23.1 and PostgreSQL 8.4.0 for Windows on a
windows desktop. When issue sql-postgres in emacs, after providing
User/Password/Database/Server, nothing
Hey folks,
West is upon us shortly. Get those talks in:
http://www.postgresqlconference.org/2009/west
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company
On Tue, 2009-08-04 at 09:30 -0700, Bob Pawley wrote:
I haven''t required line numbers on my query pages before now.
I'm using PGAdmin version 1.8.4.
Is this something that can be turned on?
Maybe but it should be asked here:
http://www.pgadmin.org/support/list.php
Joshua D. Drake
-repeated in the updates.
If they're all exactly the same pattern like that, it might be worth the
trouble to set up a prepared statement.
Seems like an opportunity for the use of a function.
Joshua D. Drake
regards, tom lane
--
PostgreSQL - XMPP: jdr
(because of
--integer-datetimes). So, yeah if you are running Debian/Ubuntu but if
you are running Cent/RH with the defaults, pg_migrator isn't going to
work unless you compile Pg from source.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support
On Mon, 2009-07-27 at 19:16 -0400, Tom Lane wrote:
Joshua D. Drake j...@commandprompt.com writes:
It depends, 8.3 and 8.4 are not compatible by default (because of
--integer-datetimes). So, yeah if you are running Debian/Ubuntu but if
you are running Cent/RH with the defaults, pg_migrator
that will disappear in a practical sense. You know
this is true. My response is not nonsense. The data is still there but
it is floating point based and thus, inexact. The where clause that you
expect to retrieve the data, may not.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
On Fri, 2009-07-24 at 11:31 +0100, Jazz Johal wrote:
Hi
Is it possible to setup replication from EDB to Postgres?
Probably. Using Slony. As I understand it they explicitly keep backward
compatibility.
Joshua D. Drake
Thanks
--
PostgreSQL - XMPP: jdr
systems take a huge hit
by full logging due to transactional velocity.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql
On Mon, 2009-07-20 at 13:46 -0400, Bill Moran wrote:
In response to Joshua D. Drake j...@commandprompt.com:
It depends on the system. I have seen even big systems take a huge hit
by full logging due to transactional velocity.
Perhaps I'm just in a foul mood today, but I feel like people
already exists. Meaning you had
a postgres file or directory already. Initdb will bail out if that is
the case.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company
an account on the PostgreSQL Conference site to
submit a talk.
Joshua d. Drake
---Michael Brewer
mbre...@gmail.com
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving
for the cost of RAC.
Joshua d. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-general mailing list (pgsql-general
as good as MySQL Replication. Both
statement-based and row-based replication. And support for
Master-Master and full cyclic replication setups. Postgresql is just a
toy database without this as far as I am concerned.
Funny.
Joshua D. Drake
Regards,
Gerry
--
PostgreSQL - XMPP: jdr
. There
is no real replication available for postgresql. Postgresql needs to
develop a real replication offering for postgresql. Builtin or a
separate module.
Well this certainly isn't true but what do I know.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting
On Mon, 2009-06-22 at 18:35 -0400, Gerry Reno wrote:
Joshua D. Drake wrote:
It is true. Otherwise show me a viable replication offering for
postgresql that I can put into production and obtain support for it.
Well, you can get support for Slony (known to to be a bit complicated
but stable
... there is the streaming page. That needs to stay somewhere
we have raw HTML because of the widget embedding. Should that be
somewhere else?
Why not embed it into the pugs SFPUG page?
Joshua D. Drake
--
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com
--
PostgreSQL - XMPP: jdr
Drupal-foo is good enough. Will seek help
You just create a new page and set the input type to full html.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL
also understand that it's a pg_connect limitation to not
accept the \copy variant which would solve me issues.
Help me Rhonda, help help me..
http://www.php.net/manual/en/function.pg-copy-from.php
?
Joshua D. Drake
Thanks
Tory
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
pg_proc are not allowed. Is
there any way in postgres to do this, by some other way?
This is the wrong away to go about it. You should put this into your
development process not within the database itself. There are a number
of utilities that would allow you to do such a thing.
Joshua D. Drake
solutions that are already used by others such as walmgr or
pitrtools
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql
On Wed, 2009-06-03 at 15:07 -0400, Geoffrey wrote:
You are still going to need to either:
A. Reinvent the wheel, by scripting it all yourself
B. Use solutions that are already used by others such as walmgr or
pitrtools
My assumption was that since pg_standby does not have the
from
the central storage device. This is why we were thinking about changing
pg_standby.
PITRTools 1.2 has queuing which can deal with this problem.
I don't know if walmgr does.
Joshua D. Drake
Thanks for all the help...
--
Work: 1-336-372-6812
Cell: 1-336-404-6987
email: te
for warm standby. It is a component
thereof. Also don't use SCP. Use rsync. Take a look at walmgr or
PITRTools it will make your life easier.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http
will have what you want.
It appears the PITRTools use pg_standby binary, thus I'm still confused
as to how these files are processed.
Yes it does use pg_standby. It just wraps everything that is missing for
warm standby into a single utility.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr
a protocol change,
and it doesn't seem worth it to me. The idea that the client gets
to choose seems like a bad idea from a security standpoint anyhow...
Wouldn't this be solved just by having fall through authentication?
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
are using proper host control then yes you can make it so that
the PHP user is only able to access the public data in the private
database. See here:
http://www.postgresql.org/docs/8.3/static/client-authentication.html
http://www.postgresql.org/docs/8.3/static/user-manag.html
Sincerely,
Joshua D
the postmaster is running from a (different)
private machine?
A postmaster must be running on whatever database you are trying to
access. You could use replication such as Slony to mirror the linux
database to the solaris one.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
-linpro.com/
2nd Quandrant : http://www.2ndquandrant.com/
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql
On Fri, 2009-05-08 at 10:45 -0400, Bill Moran wrote:
In response to George Weaver gwea...@shaw.ca:
proved you a static IP and rent you rack space for ~$150/month.
That kind of thing will provide you with the professional reliability
that most people expect but will never get from consumer DSL
record. This is what I’m trying...
psql –P tuples_only=on,footer=off,border=0 mydb
psql -A -t
j...@jd-laptop:~$ psql -A -t -U postgres -c select * from bool_test
f
j...@jd-laptop:~$
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting
with that will continue to
help support them.
In all I believe we need to be pushing hard to help any community that
is reasonably organized to get official (/me hints at Brazil).
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support
On Thu, 2009-05-07 at 12:15 -0400, Alvaro Herrera wrote:
Andrew Gould escribió:
Hey, but I forgot -- congratulations on the 501(c)3 status!
First, thanks!
I think we are getting a bit off topic here. If we want to continue this
let's move it to -advocacy.
Sincerely,
Joshua D. Drake
including mine,
http://www.pgexperts.com/, that will be happy to work with you.
Or others:
OmniTI, http://www.omniti.com/
Keving Kempter LLC: http://www.kevinkempterllc.com/
Command Prompt: http://www.commandprompt.com/
EnterpriseDB: http://www.enterprisedb.com/
Sincerely,
Joshua D. Drake
to everyone who helped!
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-general mailing list (pgsql
with your
own implementation.
I would also note that Win32 8.1 is deprecated and unsupported. You need
to update to at least 8.2.
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http
/articles on how
to do the backup would be appreciated very much.
The postgres manual tends to be a great source of information. See, for
example:
http://www.postgresql.org/docs/8.1/interactive/backup.html
Not for Windows it isn't.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr
http://www.postgresql.org/docs/8.3/static/app-pgrestore.html
Sincerely,
Joshua D. Drake
Christine
At 09:08 AM 22/04/2009, you wrote:
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: binary
Content-Description: Welcome to the pgsql-bugs list
/local/bin and by using RPM only.
They are wrong. Redhat standard is /usr/bin for
binaries /var/lib/pgsql/data for the data directory.
Use www.pgsqlrpms.org and make your life easy.
Joshua D. Drake
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development
to use specific
array functions to work with the array versus just a nice join.
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
On Mon, 2009-04-27 at 13:33 -0600, Scott Marlowe wrote:
It looks like pl/php is still on a beta release. Is the previous
non-beta release preferred, or the beta1 tested against 8.3beta1?
Better question for the pl/php list. Copying Alexey because he would
know better.
Joshua D. Drake
sense at all. Chen, are you talking about an unclean
shutdown where you have to fsck a file system?
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company
Sincerely,
Joshua D. Drake
Thank you so much!
B.R.
ChenDongdong
-Original Message-
From: Alvaro Herrera [mailto:alvhe...@commandprompt.com]
Sent: Friday, April 24, 2009 8:22 AM
To: Chen, Dongdong (GE Healthcare)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] need help
sure it is always on if going through your layer. That way
none of this is an issue.
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving
for inputs to the
concatenation (||) operator, so long as least one input is a
character-string type.
However Alvaro is right. You should read the entire incompatibilities
section, and of course test.
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr
is about whether or not the server was compiled with
integer datetime support. There may also be an upgrade error here as
well if she is trying to use 8.4Beta because 8.4 finally fixes the long
standing mistake of not using integer datetime support by default.
Joshua D. Drake
--
PostgreSQL - XMPP
. Uninstall 8.3.4
5. Reinstall 8.3.7 in a new location
6. Restore backup
7. Test/Verify
7a. If o.k. remove 8.3.4 location
7b. If not o.k. check back
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http
and
floating based packages (for compatibility).
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-general mailing list
to proceed.
If anybody knows what going on please email me or reply on this post.
Thanks in advance.
You have a version of pg_dump that is installed that isn't the same as the
server.
Joshua D. Drake
--
View this message in context:
http://www.nabble.com/pgadmin-1.8.4-gives-error-while
of queries.
Joshua D. Drake
Thanks
--
View this message in context:
http://www.nabble.com/Migration-Upgrade-Problems-tp23100921p23100921.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting
. It disqualifies it as proprietary. I can make money
providing consulting for Npgsql, that makes it commercial or at least
the opportunity for it to be commercial.
Not to be pedantic but let's be accurate with our data. We are database
people after all :)
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP
On Mon, 2009-04-13 at 14:55 -0700, Christophe wrote:
On Apr 13, 2009, at 2:54 PM, Joshua D. Drake wrote:
Yes Vimeo can download and I will have it up soon.
Thank you! My work here is done. :)
And it is now up on vimeo.
http://www.vimeo.com/4144396
Joshua D. Drake
--
PostgreSQL
. Alternatively you can try to cleanse the data
with something like iconv.
Joshua D. Drake
\\||/
Rod
--
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since
On Mon, 2009-04-13 at 23:48 +0200, Ivan Sergio Borgonovo wrote:
was just thinking about a public official place for everybody.
I'm going to sleep so I'm not going to miss the bandwidth required
for downloading the full stuff ;) but still then it will have to
find it's way back to a public
lower limit before the
video quality reaches the point that we might as well just post the
audio :) ).
We really don't want anything that is less than about 700MB. After that
it is just youtube crap. At least with 700MB we get SVCD quality.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr
On Wed, 2009-04-08 at 22:14 -0400, Jeff Brenton wrote:
There are no filesystem level content size restrictions that I am aware
of on this system. The user pgsql should have full access to the
filesystems indicated except for the root filesystem.
Inodes?
Where is the temporary location?
/purchase
And get your registration in!
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-general mailing
Be happy to help you over there. As a note we are going to immediately as:
post your ini files
what exactly steps did you follow to fail over (did you just F999)
what version for pitrtools are you running.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting
default from the previous
floating point data type?
In 8.4 yes. Not sure why the windows installer does that now.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL
type of IO are you using now? (This is also assumes an actual
decent RAID controller).
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
kind of elastic hosting?
Given the craze in 'cloud' technology, its an important question to ask
(and research).
Cheers,
--Tim
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com
/unison-ucsf-sfpug
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-general mailing list (pgsql-general
know).
Meaning, it doesn't use RPM or DEB.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
-
Sent via pgsql-general mailing list (pgsql
is only large when the size is measured in
terrabytes :)
So really, really large would mean something like 100 petabytes
My personal opinion is that a large database has more than ~10 million rows
in more than ~10 tables.
It entirely depends on workload and hardware.
Joshua D. Drake
packaging. As far as I know
Postgres Plus does not do this on Linux.
If you are running windows, use what you want :)
Joshua D. Drake
Jen
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com
On Sat, 2009-03-14 at 15:27 -0700, Christophe wrote:
Hi,
The video is now available for download! You can find it at:
http://blog.thebuild.com/sfpug/sfpug-unison-20090311.mov
It is also on Vimeo:
http://www.vimeo.com/3732938
Joshua D. Drake
Thanks,
-- Christophe
of supported platforms in the manual - have a rummage there.
http://www.postgresql.org/docs/8.2/static/supported-platforms.html
Sincerely,
Joshua D. Drake
Ray.
--
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
r
support for 8.2 Win32 to Windows 2008.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-general mailing list (pgsql
D. Drake
regards, tom lane
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
--
Sent via pgsql-general mailing list (pgsql
are running Linux DRBD is a common solution as well. There is also
Slony-I, and Mammoth Replicator.
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since
.
If this applies to raid based cache as well then performance is going to
completely tank. For users of Linux + PostgreSQL using LVM.
Joshua D. Drake
.TM.
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http
On Sun, 2009-03-15 at 01:48 +0100, Marco Colombo wrote:
Joshua D. Drake wrote:
On Sat, 2009-03-14 at 05:25 +0100, Marco Colombo wrote:
Scott Marlowe wrote:
Also see:
http://lkml.org/lkml/2008/2/26/41
but it seems to me that all this discussion is under the assuption that
disks have
501 - 600 of 2121 matches
Mail list logo