(B
(B
(BHi All,
(B
(BI want to use domains in the project I'm
(Bworking on right now. I'd like to hear from anyone with experience of using
(Bthem. Basically I'd like to know if you think it's a good idea, and whether
(Bthere are any pitfalls that I should be aware of. I did a quick se
y
dreams, i guess). In the mean time, if anyone knows a 'neat' way to validate
the date strings I'd be happy to hear about it. I got bogged down in very
much over involved (an probably slow) code that couldn't guarantee a valid
date anyway. The date conversion function to_date is far too forgiving to
fulfill this purpose, it seems.
Regards
Iain
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
that. It's somewhat tidier than my original
experiment. I think it's about time I learnt a little more about regular
expressions. I'll check it out.
Thanks for your input, I appreciate it.
Regards
iain
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
(B
(B
(BHi All,
(B
(BI had been having some problems since
(Byesterday with dumping/loading data and even running vacuum analyse. The good
(Bnews is that I've sorted it out and things seem to running smoothly
(Bagain.
(B
(BThere may be a bug in there somewhere, or
(Bat least a deg
(B
(B
(BHi All,
(B
(BI got the following error message
(Byesterday:
(B
(BWARNING: statement-level statistics
(Bare disabled because parser, planner, or executor statistics are onpsql:
(BFATAL: unrecognized configuration parameter
(B"show_statement_stats"
(B
(Band I'm wonderin
(BRegards
(BIain
(B
(B- Original Message -
(BFrom: "Tom Lane" <[EMAIL PROTECTED]>
(BTo: "Iain" <[EMAIL PROTECTED]>
(BCc: <[EMAIL PROTECTED]>
(BSent: Saturday, December 20, 2003 3:11 AM
(BSubject: Re: [ADMIN] ERROR: canceling query due to u
private server
(Bto test this again, as I don't want to interrupt the other developers .
(B
(BWill let you know.
(Bregards
(BIain
(B- Original Message -
(BFrom: "Tom Lane" <[EMAIL PROTECTED]>
(BTo: "Iain" <[EMAIL PROTECTED]>
(BCc: <[EMAIL P
(B
(B
(BHi All,
(B
(BI created a DB with SQL_ASCII encoding but
(BI want to change it to EUC_JP. Can I do this without creating a new database? I
(Bdidn't find a way in the docs, sorry.
(B
(B set server_encoding =
(BEUC_JP;
(B
(Bdidn't work.
(B
(BMy understanding is that the
s returned correctly.
(B
(Bregards,
(B Iain
(B
(B
(B- Original Message -
(BFrom: "Tom Lane" <[EMAIL PROTECTED]>
(BTo: "Iain" <[EMAIL PROTECTED]>
(BCc: <[EMAIL PROTECTED]>
(BSent: Tuesday, January 27, 2004 2:05 AM
(BSubject: Re: [ADMIN] Can I cha
Hi Tom,
(B
(BThanks for that. It's somewhat clearer now.
(B
(BI went ahead and rebuilt the DB with no problems so I guess that whatever
(Bdata was in the DB converted OK.
(B
(BRegards
(BIain
(B
(B> "Iain" <[EMAIL PROTECTED]> writes:
(B> > I read the info w
(B
(B
(BHi All,
(B
(BI'm supposed to put together a plan for
(Bthe routine maintenance of the new database we are building using v7.4, and I
(Bhave a question or two.
(B
(BI'm interested in the auto vacuum daemon,
(Bbut havn't located any good information about it so far, I'd like t
> Just moving from 7.1 to 7.4 should help, since you can start using plain
(B> vacuum (7.1's vacuum is equivalent to vacuum full IIRC).
(B
(BThat old DB server has been running contnuously for 2 years they tell me.
(BApparently it is also growing despite nightly vacuums and a stable data set
(
(B> Kinda sounds like index bloat to me --- have you done any looking to
(B> determine which files are growing?
(B>
(B
(BNo, I havn't. I don't actually have access to that machine, and there is a
(Bcirtain reluctance to tamper with it. However Ithink that it will need some
(Battention soon.
issues) may be helped by placing the WAL files on a disk (and maybe even
controller) seperate from the DB.
Something to think about anyway.
regards
Iain
- Original Message -
From: "Shane Wright" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 04
> Yes, you are right but it wasn't the case this time, I have run the
explain plenty of
> times with same results. I think that the reason was that I made a simple
VACUUM,
> after a VACUUM FULL ANALYZE (1h!!) things are ok
It's reasonable to expect that a seq scan will perform faster after a ful
test above.
I liked Scot's suggestion of using a small table containing only the IDs to
use for counting. A serial scan of this small table could be expected to be
much faster. Postgres doesnt use an index in the case you specified, as I
understand it.
Regards
Iain
- Original Mes
> Or do I just need to vacuum more often? I _did_ try a vacuum before
> asking the list for help, but it didn't give any improvement (just a
> vacuum analyze).
"vacuum analyse" allows dead space to be re-used, but doesn't compact the
table, you need "vacuum analyse full" for that.
I'm not sure
There is some information on www.varlena.com I think it may have been Scott
who wrote the article that I'm thinking about. There is other information
about, your best bet may be google.
Regards
Iain
- Original Message -
From: "C. Bensend" <[EMAIL PROTECTED]>
To: <
IIRC killing vacuums can cause some minor problems - i think it may have
(Bbeen something like index bloat. Tom said something about it once before.
(B
(BOtherwise, as I understand it, it's "safe" to kill vacuums.
(B
(BCheers
(BIain
(B
(B- Original Message -
(BFrom: "Werner Bohl"
(B
(B
(BHi,
(B
(BI thought I read something about this in
(Brelation to v8, but I can't find any reference to it now... is it (or will it
(Bbe) possible to do master-slave style database replication by transmitting log
(Bfiles to the standby server and having it process them?
(B
(BA
(B
(B
(BHI,
(B
(BI've been looking into options for
(Bimproving the availability of postgres servers beyond what you get with a
(Bmonolithic server and RAID. These are, as far as possible "cheap"
(Boptions and therefore don't include use of shared storage and all the good
(Boptions t
ptions and keep an eye on it's progress.
regards
Iain
- Original Message -
From: "Gaetano Mendola" <[EMAIL PROTECTED]>
To: "Robert Treat" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, October 22, 2004
, but a
stable production system should be relatively OK. Just my experience anyway.
regards
Iain
- Original Message -
From: "Lee Wu" <[EMAIL PROTECTED]>
To: "Düster Horst" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, October 30, 2004 1:39 AM
(B
(B
(BHi,
(B
(BI'm wondering if this is already on some
(Btodo list for pg_restore but I didn't find any mention of it anywhere, so I
(Bthought I should post this and see what people think..
(B
(BBasically, I'd like to see an option at
(Brestore time to not include the primary ke
n using newer versions of pg_dump on
older verisons of the DB - is it is possible or even wise to unload a 7.1
DB with the 7.4 version of pg?
Regards
iain
- Original Message -
From: "Bruce Momjian" <[EMAIL PROTECTED]>
To: "Iain" <[EMAIL PROTECTED]>
Cc: <
he new server while the bigger ones are still unloading. Most of
(Bthe old tables have to be transformed to a new format, and I wanna get home
(Bby the last train if possible :) .
(B
(Bregards
(Biain
(B
(B- Original Message -
(BFrom: "Tom Lane" <[EMAIL PROTECTED]>
(
Hi Bruce and Tom,
(B
(BI've got the picture now, thanks.
(B
(BI'll be sure to test it all pretty thoroughly before the day anyway.
(B
(BThanks again.
(B
(BIain
(B- Original Message -
(BFrom: "Tom Lane" <[EMAIL PROTECTED]>
(BTo: "Iain" <[
That should be easy,
use -T template1 when you create the empty DB.
ie:
createdb -T template0
regards
Iain
- Original Message -
From: "Allen Smith" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 04, 2004 4:39 AM
Subject: [ADMIN] Help need to
It seems that this kind of thing pops up from time to time. I don't have v8
(Bavailable right now to check, but is SQL_ASCII still the default DB
(Bencoding? I'm wondering is unicode wouldn't be a better choice these days.
(B
(Bregards
(BIain
(B- Original Message -
(BFrom: "Tom La
icode
(and I guess that means UTF-8) is really the way to go. It was designed as
the universal standard after all.
Thanks for the feedback,
Iain
---(end of broadcast)---
TIP 6: Have you searched our list archives?
ng in Japan, then I
realized what a nightmare it is. I expect you can imagine, but most people
(like me a year ago) couldn't. If everyone was already using unicode, I
don't think we'd have anything to worry about.
regards
Iain
- Original Message -
From: "Peter Eise
test it. If you come up with any good information, I'd
be very intertested to hear it.
I posted a summary of options as I understood them in the admin section. If
your search on availabilty and failover you should find it.
Regards
Iain
- Original Message -
From: Adile Abbadi
To: [E
tup or not. From what I have seen, it looks
reasonably easy considering what it it is trying to achieve.
I might have a chance to test some of this out for myself in the new year,
but that's not decided yet.
Regards
Iain
Cheers
Adile
-Original Message-
From: Iain [mailto:[EMAIL
Hi All,
(B
(BI've read a fair bit in these lists about server configurations, and have
(Bcome to some conclusions as to the kind of system that I want to build.
(BHowever, I would like to hear from anyone with specific experience of this
(Bconfig. before I go ahead and buy it:
(B
(BThe sy
Thanks to all for your feedback on this.
(B
(BI'm looking forward to getting my hands on the system.
(B
(BIt seems that the battery backed cache is an important factor, though I
(Bhavn't found any information specifically concerning this on the tyan site.
(BI can't tell if it's an option or
d we need all the help we can get, right? ;-)
Thanks for pointing me in the right direction there.
regards
Iain
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAI
:-) I'll have a look for "hot swap cpu" too though, just for interests
sake.
High redundancy is becoming more accessible I think, but it still takes a
lot more money than your average PC server motherboard costs to get it ;-)
something to look forward to anyway.
Cheers,
Iain
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hi Aaron,
You are correct. That kind of functionality can't be found on standard
x86 gear (sans the $150K NEC redundant behemoth).
I reckon that the day is coming though, and I expect Linux will ready when
the hardware arrives :-)
cheers
Iain
---(end of broa
package, especially
if it conforms with the above mentioned standard.
Regards
Iain
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Hi All,
(B
(BI'm hoping that soemone can explain this error message to me and give me an
(Bidea of how to proceed.
(B
(BI was given a set of 3 dump files (in a tar.gz archive) generated by a 7.1
(BDB that I'm trying to import into another 7.1 DB. 2 of the files (the
(Bsmaller ones) restore n
--+--+
(B> | http://www.did-it.com | Need help tracking your paid |
(B> | [EMAIL PROTECTED] | search campaigns?|
(B> | 516-255-0500 |- Help is on the way! |
(B> +---+-
urers, please let me know.
Also, someone asked me what happens if one of the CPUs fails on this system,
will the system continue to operate on 1 CPU. I havn't really considered
this, and have never read anything either way, so my assumption is "no, it
won't". Any comment?
Thanks
Hi All,
(B
(BI'm in the process of putting together some docs for a new postgres server.
(BFor development use, I've always just been content to have the PGDATA
(Bdirectory as a subdirectory of the main postgres install directory which is
(B/usr/local/pgsql/ by default (when installing from
Hi,
(B
(BThanks for that. It seems that you were right.
(B
(BWe used pg_restore to create a plain text dump file on the original machine
(Band brought that down to the other machine which worked fine.
(B
(Bregards
(BIain
(B
(B> Apparently you are trying to load into a server compiled wit
Hi All,
(B
(BI have a v7.1 database whose encoding is EUC_JP and I'm trying to get it
(Binto a v7.4 database whose encoding is also EUC_JP. Unfortunately it seems
(Bthat 7.4 is much stricter about it's multibyte data then 7.1 was because
(Battempts to restore into the 7.4 db result in "Inva
em a try and go
with 7.4.6.
regards
Iain
- Original Message -
From: "Gaurav Arora" <[EMAIL PROTECTED]>
To: "postgres questions"
Sent: Friday, January 21, 2005 3:11 AM
Subject: [ADMIN] installing postgres7.3
hi,
I am sorry about my previous mail. The Linux I am
u
it is (at least
upto 7.4.6 - I don't know about later versions) thereis no way to specify the
password on the commandline.
Regards
Iain
- Original Message -
From:
Andrei
Bintintan
To: pgsql-admin@postgresql.org
Sent: Tuesday, February 08, 2005
5:11 PM
Subject: [ADM
d cons
of trust vs .pgpass, but maybe someone else has something to say.
Also, I noticed that the PGPASSPORD environment variable is deprecated, so
probably best to avoid it if possible.
regards
Iain
- Original Message -
From: "John Jensen" <[EMAIL PROTECTED]>
To: &l
Hi,
try doing it this way and work from there:
select sp_items('850001');
regards
Iain
- Original Message -
From: "Chari Clark" <[EMAIL PROTECTED]>
To: ; <[EMAIL PROTECTED]>
Sent: Friday, February 18, 2005 5:25 AM
Subject: [ADMIN] PostgreSQL Err
49 matches
Mail list logo
