Gauthier, Dave wrote:
Hi
I created a database instance and a database takign whatever defaults
were in effect with regard to defining a superuser and password. What
are those defaults? How do I change the password for the superuser?
You created a database or a cluster? What command did
.
The problem is that you don't have your authentication configured. That
is discussed in detail here:
http://www.postgresql.org/docs/8.2/static/client-authentication.html
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support
of PG can the 32 G of
RAM be used for caching?
There is zero reason not to run PG on 64bit with that configuration.
Sincerely,
Joshua D. Drake
Many thanks,
David
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 21 Dec 2007 13:24:01 -0800 (PST)
Glyn Astill [EMAIL PROTECTED] wrote:
Is there a way I can check what it is?
Change your log line prefix to show connections and ip addresses.
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http
way to do
this?
Take a look at setval.
postgres=# select setval('foo_id_seq',(select max(id) from foo));
setval
-
100
(1 row)
postgres=# select currval('foo_id_seq');
currval
- -
100
(1 row)
Sincerely,
Joshua D. Drake
---(end
AND d.refclassid='pg_class'::regclass
AND d.refobjsubid 0
AND d.deptype='a';
sequencename | schema | tablename | columnname
- --++---+
foo_id_seq | public | foo | id
(1 row)
- From there, scripting should be easy.
Sincerely,
Joshua D. Drake
seem essential, because
there isn't any other reason for a sequence to depend on a table
column. Otherwise the query seems correct.
8.2 is type 'a' (and I assume 8.3), 8.1 is 'i'. I don't know about
anything older.
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http
. the OOXML debacle?
The list continues, but I suspect you get my point.
You are assuming most people care.
1. You have to pay for the the OS.
2. You have to pay for the database.
3. You have to pay for any extra feature.
That is where you start.
Sincerely,
Joshua D. Drake
to work with.
/Kevin (Although not the same Kevin as above)
/me takes note of all the Kevins that are handing out hugs...
:)
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
Donate
opportunity to interact with the PG
community.
That is until I can convince my new employer to realise the dark side
of Microsoft SQL Server. :)
503-667-4564 extension 101... I am available anytime after 9:00am PST
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http
Jane Ren wrote:
Hi,
I need to write a script that creates a new user with a password
automatically.
Is there a way I can specify the password as a command line argument to
createuser?
Since you have access to the shell use psql -U user -c create role ...
Joshua D. Drake
It looks like
this week and registration opens up in
January 08.
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
SELECT
can't vouch for how well it
works.
Well OpenOffice now has a native sdbc driver so no ODBC is required.
It seems to work very well.
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
Donate
would be using
this once we can actually test it.
http://www.postgresql.org/docs/8.2/static/runtime-config-connection.html
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
know I'm RAM starved on this machine)
Good lord, my laptop has more memory than that. :)
My phone has more memory than that :P
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 12 Dec 2007 23:08:35 -0800
Joshua D. Drake [EMAIL PROTECTED] wrote:
Tom Lane wrote:
Joshua D. Drake [EMAIL PROTECTED] writes:
Tom Lane wrote:
You sure about that? I tested CVS HEAD just now, by setting the
checkpoint_ parameters
Simon Riggs wrote:
On Tue, 2007-12-11 at 22:21 -0500, Tom Lane wrote:
Joshua D. Drake [EMAIL PROTECTED] writes:
... Now I understand that restoring log files can be slow but this is a big
machine.
Yeah, restoring is known to be less than speedy, because essentially
zero optimization work has
Richard Broersma Jr wrote:
Are there any planes in the works for a booth and talks for PostgreSQL?
This is already being discussed on the advocacy list :)
Joshua D. Drake
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 1
Simon Riggs wrote:
On Wed, 2007-12-12 at 07:36 -0800, Joshua D. Drake wrote:
We can't really expect people to use PITR if they new
it would take hours to recover even on the size of machine I was working on.
That's not true statement in all cases and can often be improved with
some
SHARMILA JOTHIRAJAH wrote:
Hi,
I need some help with slony...
Which comes from the Slony lists:
http://lists.slony.info/mailman/listinfo
Sincerely,
Joshua D. Drake
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner
Dave Page wrote:
Joshua D. Drake wrote:
* Is there a project to create MySQL compatibility for Postgresql? I
No. Thank god.
Just think of all those potential customers you could be missing JD :-)
http://pgfoundry.org/projects/mysqlcompat/
I know you put a smiley face
of
functionality found on Joomla and Drupal work with Postgresql?
Those are the two I know best. We have several extremely high profile
customers that use Drupal PostgreSQL with great success.
Joshua D. Drake
---(end of broadcast)---
TIP 2: Don't 'kill -9
at
smaller intervals).
Sincerely,
Joshua D. Drake
regards, tom lane
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
CPU, there is a huge
amount of optimization *somewhere* to be done.
Tom is also correct, we should test this on 8.3.
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL
be. This is a database that is doing nothing but restoring.
Zero concurrency. This thing should be flying.
Depending on your transaction mix and what percentage of it is
read-only select queries you might reasonably expect the restore to
take as long as it took to generate t
We archive selects?
Joshua D
Gregory Stark wrote:
Joshua D. Drake [EMAIL PROTECTED] writes:
On Wed, 12 Dec 2007 18:02:39 +
Gregory Stark [EMAIL PROTECTED] wrote:
I'm not sure what you guys' expectations are, but if you're restoring
5 minutes worth of database traffic in 8 seconds I wouldn't be
complaining.
I would
:34:56+04
(1 row)
?
Sincerely,
Joshua D. Drake
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
Tom Lane wrote:
Joshua D. Drake [EMAIL PROTECTED] writes:
Jeff Trout [EMAIL PROTECTED] wrote:
in this case it was 24hrs of data - about 1500 wal segments. During
this time the machine was nearly complete idle and there wasn't very
much IO going on (few megs/sec).
Exactly. Which
Tom Lane wrote:
Joshua D. Drake [EMAIL PROTECTED] writes:
Tom Lane wrote:
You sure about that? I tested CVS HEAD just now, by setting the
checkpoint_ parameters really high,
... And:
2007-12-13 00:55:20 EST LOG: restored log file 000107E1006B
from archive
Hmm --- I
, otherwise how is anyone to know?
Because it is standard practice on the internet to have lists-headers?
And that is how every standard mail client deals with it?
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support: +1.503.667.4564 24x7/Emergency
that you are replying to, to have enough wits to not top post.
However, I would also note that in windows world, it is very common
to top post. I am constantly retraining very smart, just very ignorant
customers.
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http
to a line that has a command to export a table from
PostgreSQL, or calls another batch file, which copies some files.
Use perl, python, mono/c#, java, pl/sh ... you have a wealth of various
easy to use APIs :)
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com
). It is the PostgreSQL communities decision and I believe
except for newbies and a few long timers who should know better,
everyone avoids top posting.
Top posting makes it hard to read.
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales
discourage top posting, vehemently if
needed.
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
SELECT
care, email etiquette in painful detail here
http://tools.ietf.org/html/rfc1855. Hijacking seems to be more of a
Bozo No-No than top posting. Or maybe that's just me.
Oh certainly Hi-jacking is bad as well.
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http
of the original message.
FWIW this would be another item on the netiquette FAQ.
O.k. but the above is *not* user controlled. I think the community
needs to suck it up and live with that.
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support
version I can use
these WAL?
No. Take a look at www.slony.info.
Joshua D. Drake
Thanks
Never miss a thing. Make Yahoo your homepage.
http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs
haven't been here very long.
Sincerely,
Joshua D. Drake
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
, and it simply is not the way it's done on this list. Get use to
it. Now who's doing the 4 year old crying??
There is no reason for this discussion to become rude. It has been
productive on both sides thus far. Let's keep it that way.
Sincerely,
Joshua D. Drake
---(end
,
Joshua D. Drake
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
Tom Lane wrote:
Joshua D. Drake [EMAIL PROTECTED] writes:
... Now I understand that restoring log files can be slow but this is a big
machine.
Yeah, restoring is known to be less than speedy, because essentially
zero optimization work has been done on it.
Heikki has improved matters a bit
the slony lists:
http://lists.slony.info/mailman/listinfo
Sincerely,
Joshua D. Drake
Thanks
josh
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com
Replicator already does
replication (www.commandprompt.com). Inserts replication transactional
data, where updates and deletes replicate the low level command (what
was deleted/updated not the actual DML).
Joshua D. Drake
P.S. DDL is never a subject for replication (in normal RDBMS'es
will be run on allowing you to have a
centralized master for your connect manager that can interact with any
number of various nodes based on function call.
Sincerely,
Joshua D. Drake
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency
problem
as far as I can tell...
Pg_dump uses Access Share if I recall. You can operate normally while
running pg_dump. I am having a hard time parsing that. Could you instead
go over to pgsql.privatepaste.com and send back a paste link?
Joshua D. Drake
sdb: tables
sdc: logs
sdd: backup share
?
pgAccess is long dead. Please take a look at pgadmin, www.pgadmin.org.
Alternatively you could use OOBase from OpenOffice.
Joshua D. Drake
Thank you.
Kandy
---(end of
broadcast)--- TIP 9: In versions below 8.0,
the planner will ignore your desire
Chris Velevitch wrote:
Where can I find information on when support for 7.4.x formally cease?
This has yet to be determined. However you can expect that it will be
considered in the next 12 to 18 months. We are about to EOL 7.3.
Sincerely,
Joshua D. Drake
Chris
you to do that. Not to mention, a SELECT *
without a where clause will always scan the whole table so an Index
would be useless.
Joshua D. Drake
thanks
pau
--
Pau Marc Muñoz Torres
Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent
Villar
of defense to help us find any corner
cases of possible issues.
Further Beta information is available here:
http://www.postgresql.org/developer/beta
Binaries for are already available for our major platforms.
Joshua D. Drake
PostgreSQL Liaison
--
* PostgreSQL - The world's most advanced open source
On Tue, 4 Dec 2007 13:59:13 -0800
Joshua D. Drake [EMAIL PROTECTED] wrote:
Thanks to all the testing, feedback and bug reports the community has
performed with the current betas, we now have our fourth beta
of 8.4.
Pardon. I am living 12 months in the future. This should be:
we now have
between a dual core opteron and a
dual core xeon will likely not be noticeable to a PostgreSQL
installation (generally speaking).
However, the two extra cores (even if slower), will greatly help if you
have any kind of concurrency.
Sincerely,
Joshua D. Drake
---(end
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 03 Dec 2007 22:30:58 -0600
Ron Johnson [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/03/07 21:27, Joshua D. Drake wrote:
Uwe C. Schroeder wrote:
On Monday 03 December 2007, Tom Allison wrote
if it is in contrib or not.. try?:
apt-file is your friend:
apt-file search pg_resetxlog
/usr/lib/postgresql/8.1/bin/pg_resetxlog
Joshua D. Drake
---(end of
broadcast)--- TIP 5: don't forget to increase
your free space map settings
signature.asc
On Sat, 01 Dec 2007 15:32:50 -0500
Tom Allison [EMAIL PROTECTED] wrote:
I tracked it down and did a reset.
I only have one large table right now.
And now I've decided to start using fsync=on!!! :)
change wal_sync_method to open_sync and fsync=on isn't nearly as bad as
it sounds.
joshua
very usable code but then you have to wonder why you have
hibernate there at all.
Sincerely,
Joshua D. Drake
Regards,
Oleg
_
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical
like a realistic issue
with using logrotate or syslog was tgl's. You can loose data in the log
when rotating if you aren't using the PostgreSQL logging facility.
Other than that I think our current logging situation is a bit
ridiculous. [1]
Joshua D. Drake
[1]
http://www.commandprompt.com/blogs
list is is the list of fields you don't want selected
and the second parameter is the table you are going to use. Then you
just have to build the logic inside the function.
Sincerely,
Joshua D. Drake
Cheers,
David.
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales
?
I thought it was more about the cost to fork() a process in win32?
Sincerely,
Joshua D. Drake
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com
.
Sincerely,
Joshua D. Drake
Cheers,
David.
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate
at the kernel level.
Joshua D. Drake
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project
explicitly
for use with drdbd which is synchronous block level replication.
No license fees :)
Sincerely,
Joshua D. Drake
Jeff
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
process, to be not-so-natural after all.
In theory the item that would be a natural key in this instance is
the VIN. You would of course have to make some kind of allowance for
cars that don't have a VIN (nothing in the last what... 50 years?).
Joshua D. Drake
Cheers,
Steve
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 26 Nov 2007 10:28:03 -0800 (PST)
Richard Broersma Jr [EMAIL PROTECTED] wrote:
--- On Mon, 11/26/07, Joshua D. Drake [EMAIL PROTECTED] wrote:
In theory the item that would be a natural key
in this instance is the VIN. You would
replication.
Sorry, this makes no sense to me -- EnterpriseDB has no replication
solution that I know of.
This is bullsh*t, it does as I've been talking to them this week.
Glyn, relax.. he did say, that I know of.
Sincerely,
Joshua D. Drake
- --
=== The PostgreSQL Company
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 26 Nov 2007 12:39:42 -0500
Chris Browne [EMAIL PROTECTED] wrote:
Unfortunately, the only way to make things deterministic (or to get
from near real time to *GUARANTEED* real time) is to jump to
synchronous replication, which is not much
important for a project I am
working on.
There was a Google Summer of Code project IIRC for that... So yes, it
has been worked on a bit but I am unaware of the status.
Joshua D. Drake
---(end of
broadcast)--- TIP 6: explain analyze is your
to see a real desire for them.
I have deferred the ladies shirts decision to Selena for what I feel
are obvious reasons.
Sincerely,
Joshua D. Drake
Regards,
Richard Broersma Jr.
---(end of
broadcast)--- TIP 6: explain analyze is your
friend
.
I personally wouldn't even mind having a PG polo that has 3rd part vendor logos
on the sleeves if that would help make PG polo shirts available.
O.k., o.k. :) I will look into costs.
Joshua D. Drake
Regards,
Richard Broersma Jr.
---(end of broadcast
brian wrote:
Joshua D. Drake wrote:
We have considered getting Polos as well as normal shirts. The normal
shirts are your basic 6.1 oz 100% cotton. No iron required, heavy
enough to hide the extra we all get once we get over 30. The main issue
with polo's is that they are expensive
Paul Lambert wrote:
Joshua D. Drake wrote:
We do not yet have a store although it has been something of
interest in the past. We usually order them in bulk and then request
donations for them at the conferences and shows.
Note :) If you register for East you get a shirt.
What if we
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 20 Nov 2007 10:49:25 -0500
Walter Vaughan [EMAIL PROTECTED] wrote:
Joshua D. Drake wrote:
It's that time, after a wildly successful conference last October in
Portland, Oregon we are now beginning to ramp up for the East Coast
08
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 20 Nov 2007 11:50:03 +0300 (MSK)
Oleg Bartunov [EMAIL PROTECTED] wrote:
Are there any possibilities to sponsor me and Teodor ?
I will contact off list about this.
Joshua D. Drake
- --
=== The PostgreSQL Company: Command Prompt
talking about
the hotel idea. More to come after Thanksgiving.
Joshua D. Drake
--
Walter
---(end of
broadcast)--- TIP 4: Have you searched our
list archives?
http://archives.postgresql.org
should be available soon.
Joshua D. Drake
PostgreSQL Liaison
--
PostgreSQL - The world's most advanced open source database
http://www.postgresql.org/
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
,
and will be used for PostgreSQL development, support and advocacy.
So if you are on the east coast and can help with organizing this
conference please let me know.
Sincerely,
Joshua D. Drake
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7
/ pricing available
4. Most importantly are we supporting any customer in APAC on this ? Is
tehre a referal ?
Why are you asking PostgreSQL about this? These are questions for Sun.
Joshua D. Drake
Appreciate your help.
regards, Jeba
---(end of broadcast
, b text, primary (a,b));
Joshua D. Drake
life. I'm back to almost never using natural keys now, mainly because
interfacing with the outside world gets too complicated. When I'm
just doing stuff inside the database then I can use natural keys and
all is good, otherwise things just get too
on
what you're doing, though unless you've got a few years experience
I'd be tempted to stay away from primary keys of more than a single
column.
Fie on you evil synthetic key lovers. Long live the Natural Key!
Right with you there buddy. Let's get the pitchforks!
Joshua D. Drake
- --
Ron
already provided to me.
Sincerely,
Joshua D. Drake
Thanks!
---(end of
broadcast)--- TIP 4: Have you searched our
list archives?
http://archives.postgresql.org/
- --
=== The PostgreSQL Company: Command Prompt
names so that I'm not faced
with this problem.
Thank you for your reply, and you too Joshua. Sorry for such an easy
question :-)
No sweat :)... I trust you will have more. Bring them on.
Joshua D. Drake
Sam
---(end of
broadcast
| text |
xxPrimaryName | text |
xxJointName | text |
xxHouseholdHash | text |
current=#
TIA
It is because when you created the relation you double quoted isactive,
so it isn't isactive it is isActive. E.g; case is relevant.
Joshua D
stored procedures instead.
Joshua D. Drake
TIA.
Ed
---(end of
broadcast)--- TIP 9: In versions below 8.0,
the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
?
Normally a primary key would just be a single column.
Uhmm no. Normally a primary key is defined by the number of columns it
takes to determine naturally distinct values.
I would agree that if he is looking at 6 then he probably needs to
normalize further.
Sincerely,
Joshua D. Drake
the packagers are for.
As far as I know it's included in the core.
Things like the debugger need to just be there with no monkeying
around.
If you are compiling from source, you are likely monkeying around. It
is the packagers responsibility to package this stuff, not core.
Sincerely,
Joshua D
.)
Right.
Joshua D. Drake
A
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL
explicit
casts in a few queries that didn't need them before, the elimination of
surprising interpretations justifies it.
- From the release notes :)
http://www.postgresql.org/docs/8.3/static/release-8-3.html
Sincerely,
Joshua D. Drake
- --
=== The PostgreSQL Company: Command Prompt, Inc
that.
I would rather us just start a packaging project. We are already doing
this for RPMS... and the debian folks are all over it... We just need
to provide some help and get them into the repos.
Joshua D. Drake
A
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support
or unsubscribe.
Joshua D. Drake
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http
Trevor Talbot wrote:
On 11/15/07, Joshua D. Drake [EMAIL PROTECTED] wrote:
A) resource governor - the ability to configure how much resources
(IO per second, CPU slices) particular users or sessions are allowed
to use
That is controlled from the operating system.
What OSes support
have a
priority set, so it can run quicker than other queries?
No.
Sincerely,
Joshua D. Drake
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com
features, why should they?
Don't get me wrong the debugger is certainly useful but I see no
technical argument (and I am sure you will correct me if I am wrong :))
that deems it needs to be in core.
Joshua D. Drake
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support
. A quick co
of /trunk shows that it is not in contrib.
Sincerely,
Joshua D. Drake
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com
.
Sincerely,
Joshua D. Drake
Later,
Tony Caduto
---(end of
broadcast)--- TIP 4: Have you searched our
list archives?
http://archives.postgresql.org/
- --
=== The PostgreSQL Company: Command Prompt, Inc
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 14 Nov 2007 18:40:26 +
Richard Huxton [EMAIL PROTECTED] wrote:
Joshua D. Drake wrote:
So the debugger is a feature of 8.3. It just isn't included in core.
Is it going to be included as a contrib module or something else
.
Sincerely,
Joshua D. Drake
brian
---(end of
broadcast)--- TIP 9: In versions below 8.0,
the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
- --
=== The PostgreSQL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 14 Nov 2007 19:01:04 +
Richard Huxton [EMAIL PROTECTED] wrote:
Joshua D. Drake wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 14 Nov 2007 12:49:37 -0600
Tony Caduto [EMAIL PROTECTED] wrote:
Here ya go:
http
if the
database needs migration from 8.2 to 8.3 or not.
What is migration? Application changes? The release notes pretty
much tell you everything you need.
http://www.postgresql.org/docs/8.3/static/release-8-3.html
Sincerely,
Joshua D. Drake
- --
=== The PostgreSQL Company: Command
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 13 Nov 2007 15:27:51 -0800
Rick Grandy [EMAIL PROTECTED] wrote:
We are looking for a Postgresql Architect/Developer to do some
mentoring, training, knowledge transfer and implementation for a
large media outlet in Los Angeles. Travel is
postgresql.conf settings? Are you running 64bit on the Linux machine?
Is there a trick to making AMDs perform? Does
Linux suck compared to BSD?
No.
Sincerely,
Joshua D. Drake
Thanks.
---(end of
broadcast)--- TIP 4: Have you searched our
are running with 8GB of ram, then it is all about the
ability to use more than 2GB of shared memory.
Joshua D. Drake
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http
901 - 1000 of 2121 matches
Mail list logo
