They make 15k disks now.
Max memory and fastest disk seem to keep people happy :-)
Joern Muehlencord wrote:
Hi out there,
I am wondering what is the right dimension for a server I have to layout
an mantain. So, here are the specifiactions I know as far as I can know
them already:
- approx. 15
Patch applied. Thanks.
---
Jeffrey W. Baker wrote:
> On Mon, 2003-06-09 at 23:08, Tom Lane wrote:
> > "Jeffrey W. Baker" <[EMAIL PROTECTED]> writes:
> > > This is the strace of a process which is deleting rows from four ta
There's already a DateStyle guc that can be set. Would that be the one,
or would we need something else?
On 24 Jun 2003, Ron Johnson wrote:
> Wasn't a 'set' command also discussed to override locale?
>
> On Tue, 2003-06-24 at 16:02, Bruce Momjian wrote:
> > Good point.
> >
> > ---
I know the current method for specifying alternate drives for PG tables is
by using symlinks. I had some ideas for simple ways to do this in PG
code, but wanted to know if anyone was working on this right now. I'd
hate to take the time to start messing with this if others were already on
it.
Jon
Wasn't a 'set' command also discussed to override locale?
On Tue, 2003-06-24 at 16:02, Bruce Momjian wrote:
> Good point.
>
> ---
>
> scott.marlowe wrote:
> > I thought it was more correctly we were considering not using the
On 24 Jun 2003, Joern Muehlencord wrote:
> Hi out there,
>
> I am wondering what is the right dimension for a server I have to layout
> an mantain. So, here are the specifiactions I know as far as I can know
> them already:
> - approx. 15 Users - at end of month many of them at the same time
> on
http://gborg.postgresql.org/project/tablelog/download/download.php
or
http://gborg.postgresql.org/project/audittrail/download/download.php?branch=devel
I haven't used either, but table_log seems to be one that I may start
using in the near future.
On Tue, 2003-06-24 at 13:17, Andrew Gould wrot
I haven't used this. It would probably work, but there's also another
way just using plain SCSI. You can attach both your main machine and a
hot standby to an external RAID array. When the main machine goes down,
just mount the RAID array yourself. However, you should also install a
serial powe
Has anyone used PostgreSQL with Drbd
(http://www.complang.tuwien.ac.at/reisner/drbd/)?
They claim it works with PostgreSQL. Do the PostgreSQL hackers forsee
any issues with this type of replication method?
Do you think this method (combined with some other HA utilities) could
work well as a "hot
Hi out there,
I am wondering what is the right dimension for a server I have to layout
an mantain. So, here are the specifiactions I know as far as I can know
them already:
- approx. 15 Users - at end of month many of them at the same time
online
- ca 30-40 gb data overal (few but big tables)
- da
If that's true, then termcap-devel should probably be added to the SRPM
dependencies. Isn't the RPM maintainer on this list? (wink wink)
Wes
Mike Mascari <[EMAIL PROTECTED]>@postgresql.org on 06/24/2003 03:32:22 PM
Sent by:[EMAIL PROTECTED]
To:Paul Ramsey <[EMAIL PROTECTED]>
cc:
Joe Conway wrote:
> Guillaume LELARGE wrote:
>
>> Le Mardi 24 Juin 2003 20:17, Andrew Gould a écrit :
>>
>>> I would like to create a audit log of update and
>>> delete queries against a table. I want the log on the
>>> server side, since access will be done using various
>>> clients via ODBC.
Good point.
---
scott.marlowe wrote:
> I thought it was more correctly we were considering not using the the
> system locale automatically, but that if someone wished to use
> --locale=en_US we'd let that work, right?
>
>
Guillaume LELARGE wrote:
Le Mardi 24 Juin 2003 20:17, Andrew Gould a écrit :
I would like to create a audit log of update and
delete queries against a table. I want the log on the
server side, since access will be done using various
clients via ODBC. I would like to capture the user,
current date
> This is in the pg_hba.conf file
>
> www.websiteIamusing.com all themachine'sIP 255.255.255.255
> trust
>
> I am sure I need to edit something yet.
"host" is a keyword (for tcp/ip connections as opposed to keyword
"local" for local domain socket connections), it is not a hostname.
Try:
Le Mardi 24 Juin 2003 20:17, Andrew Gould a écrit :
> I would like to create a audit log of update and
> delete queries against a table. I want the log on the
> server side, since access will be done using various
> clients via ODBC. I would like to capture the user,
> current datetime and the qu
Although I group my data topically in databases, most
of the data is integrated on the client side
(MSAccess). That is, tables from different databases
are often joined together during analysis.
I'm thinking of simplifying analysis and
administration by consolidating the databases and
separating
I would like to create a audit log of update and
delete queries against a table. I want the log on the
server side, since access will be done using various
clients via ODBC. I would like to capture the user,
current datetime and the query statement. My thought
was to accomplish this by creating
I go 7.3.3 installed Paul thanks...here is what is left
I am trying a php bulletin board by phpbb. I don't think I have the server
configured all the way yet. Any help is appreciated on how to get this
straight
Warning: Unable to connect to PostgreSQL server: FATAL: No pg_hba.conf entry
for
Paul Ramsey wrote:
> Red Hat (and most other RPM based distros) split libraries into
> "runtime" and "development" halves. In order to actually compile
> software against the libraries, you must install the development half.
> So, to compile against readline, you must also install the
> readline-d
On Tue, 24 Jun 2003, Alan Williams wrote:
>
> On Tue, 24 Jun 2003, Stephan Szabo wrote:
> > > hs.exon.2=> explain select * from ga_psr_transcript_1 t,
> > ga_psr_exon_1e where e.parent = t.id;
> > > QUERY PLAN
> > >
> >
I thought it was more correctly we were considering not using the the
system locale automatically, but that if someone wished to use
--locale=en_US we'd let that work, right?
I would assume that if someone actually went to the bother of setting a
locale, then it should be the deciding factor in
We are actually considering not honoring locale for initdb encodings, so
it might make no sense to do this --- that another reason for the
question mark, but until we decide, it is an open issue.
---
Lincoln Yeoh wrote:
> At
On Tue, 24 Jun 2003, Daniel E. Fisher wrote:
> I get an error during config I have redhat 7.2. readline library and Zlib
> library not found...they are installed with the latest version how do I fix
> this?
you need the -devel versions of those RPMs. i.e. readline-devel etc...
---
On Tue, 24 Jun 2003, Stephan Szabo wrote:
> > hs.exon.2=> explain select * from ga_psr_transcript_1 t,
> ga_psr_exon_1e where e.parent = t.id;
> > QUERY PLAN
> >
>
> -
I have a big ascii text file that I would only like to import columns 1, 3 and 7 from.
I know I can filter it through cut, but I wonder if there is an undocumented way to
do it with COPY. Sybase has a useless function called filler() that you use for
fields you want to ignore. For example (ps
Red Hat (and most other RPM based distros) split libraries into
"runtime" and "development" halves. In order to actually compile
software against the libraries, you must install the development half.
So, to compile against readline, you must also install the
readline-devel RPM.
Daniel E. Fishe
In looking at your ideas, a thought came to mind.
This issue is something I've been looking at neediing to address, so any comments are
welcome.
Whatever the first entry of a string entered becomes the reference string. You could add a field for that.The design below needs a unique index on:
I get an error during config I have redhat 7.2. readline library and Zlib
library not found...they are installed with the latest version how do I fix
this?
-Dan
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister
On Tue, 24 Jun 2003, Alan Williams wrote:
> hs.exon.2=> \d ga_psr_transcript_1
> Table "public.ga_psr_transcript_1"
> Column| Type | Modifiers
> --++---
> id | integer| not null
> parent
At 19:15 24.06.2003, Antonios Christofides said:
[snip]
>'description' is no longer enough; it must be possible to add
>translations to _any_ language and to any number of languages.
>I've thought of a number of solutions, but none satisfies me to the
>point
Hi !
We had this problem in GnuMed (www.gnumed.org). Eventually, we
decided that it is only really solvable automatically for "fixed"
strings. That is, strings that are known at database creation.
User supplied strings need user supplied translations as well.
The translation mechanism works for th
Hi Tom,
Thank you very much for your help. In order to get the pg_ctl trace at
start up, I would appreciate it if you could advise me on how to modify
the postscrpt script. The line in question in the script is:
su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p
/usr/bin/postmaster -o '
The xserver in cygwin works just fine on all the systems I have tested, I
have several linux boxen at home all headless, and I use Cygwin and XDMP to
select which box I what to connect to and manage, seems as fast as using a
local screen etc. Webmin is also a good tool, as it also has a POSTGRESQL
On Tue, 24 Jun 2003, Reuben D. Budiardja wrote:
> Hi,
> Seems that everytime I use the word 'desc' I got an error. For example, this
> query:
> SELECT code, desc FROM or_code_table WHERE tr = 'FORMAT'
> gave me
> ERROR: parser: parse error at or near "desc"
>
> When I created the table I got the
Hi,
Seems that everytime I use the word 'desc' I got an error. For example, this
query:
SELECT code, desc FROM or_code_table WHERE tr = 'FORMAT'
gave me
ERROR: parser: parse error at or near "desc"
When I created the table I got the same error too. I got around that by
creating the table usin
I'm working on pgSQL integration with Domino6 (DECS, LCLSX) (there will be
documentation in the coming weeks).
I have a question a couple of questions for you:
1) Are you using Domino 6 or 5.x
2) In your DSN setup on (NT?) do you have the valid
account information to connect to Pg?
3) If you a
"Carlos Oliva" <[EMAIL PROTECTED]> writes:
> This log has the error but I do not understand why it occurs.
> Starting postgresql service: + su -l postgres -s /bin/sh -c
> '/usr/bin/pg_ctl -D /var/lib/pgsql/data -p /usr/bin/postmaster -o
> '\''-p 5432'\'' start > /dev/null 2>&1'
> -sh: [: ==: una
Arjen van der Meijden wrote:
Jan Wieck wrote:
If you work on Unix systems remotely on a regular base, you
should have
a Unix system as a workstation too. That way you can use ssh(1) to
forward your X11 connections through a secure channel.
A "second" PC can be implemented as a memory+disk upgra
I have created a
table using the following command
CREATE TABLE metricsreporttable(id
VARCHAR(150) NOT NULL,sitename VARCHAR(155),title VARCHAR(160),type
VARCHAR(165),count INTEGER,categoryid
VARCHAR(170));
When I start
inserting rows into this table I get the following error message in t
[EMAIL PROTECTED] writes:
> And while i'm on the subject, the only book (hard copy) I've got on
> PostgreSQL is the O'Reilly 'Practical PostgreSQL' book, now a bit dated,
> which has one of the worst indexes I've seen in a computer manual in years.
> It may be the worst index I've ever experienc
> Jan Wieck wrote:
> If you work on Unix systems remotely on a regular base, you
> should have
> a Unix system as a workstation too. That way you can use ssh(1) to
> forward your X11 connections through a secure channel.
>
> A "second" PC can be implemented as a memory+disk upgrade
> together
[EMAIL PROTECTED] wrote:
??? You can look at an HTML file directy with any browser. If you're SSH-ing
in to a remote system, use Lynx. Though I agree that providing both man and
html would be nicer.
Try accessing a HTML file on a Linux system from a PC-based browser.
Unless you have some kin
I'm a Postgres and PHP newbie. I'm having a great deal of success with
my latest development effort having moved most of the logic from a
perl/php logic 'core' to postgres using plpgsql functions. (Thanks for
all that help, Josh).
I have a few comments to make on the idea of introducing people, PH
Hi,
What chars must be escaped in string and how exactly?
LF -> \\n
CR -> \\r
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hi Tom,
This log has the error but I do not understand why it occurs. Attached
is the file also
+ PGVERSION=7.3
+ INITD=/etc/rc.d/init.d
+ . /etc/rc.d/init.d/functions
++ TEXTDOMAIN=initscripts
++ TEXTDOMAINDIR=/etc/locale
++ umask 022
++ export PATH=/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
+
Read thread:
http://fts.postgresql.org/db/msg.html?mid=1359513
Jochem van Dieten wrote:
I was wondering if there is any reason not to define the functions from
tsearch as immutable. What I am trying to achieve is that I don't have
to create a separate field to index as is explained in the manua
Hello Hervé,
Thanks a lot for help. Both Martijn van Oosterhout and yours do job god.
Execution time is now about 1 to 2 seconds. I also figured myself what i
was doing wrong with join and error i got.
If enybody need this here is both three solutions.
select distinct d1.id,d1.url,d1.title from
Hi,
I think this could be good :
select d1.id, d1.url, d1.tittle
from directory d1
where exists (select url from directory d2 where d1.url=d2.url and
d2.oid>d1.oid)
order by d1.url;
Hope this will help,
Regards,
Le Mardi 24 Juin 2003 12:16, Uros a écrit :
> Hello ,
>
> I have table dir
On Tue, Jun 24, 2003 at 01:12:05PM +0200, Uros wrote:
> Hello Martijn,
>
> MvO> select id,url,title from directory,
> MvO> (select url from directory group by url having count(*) > 1) as list
> MvO> where list.url = directory.url;
>
> MvO> I hope I got the syntax right.
>
> I tried that before
Hello Martijn,
Tuesday, June 24, 2003, 12:32:53 PM, you wrote:
MvO> On Tue, Jun 24, 2003 at 12:16:43PM +0200, Uros wrote:
MvO> How about:
MvO> Duplicate urls would be given by:
MvO> select url from directory group by url having count(*) > 1;
MvO> To get all the entries with those urls, someth
Josh Berkus wrote:
Matt,
The quality of the material is very good, so please don't get me wrong, I
just think it's hard to find stuff. Both PHP and MySQL have well laid out
docs, with PHP being the better of the two.
I certainly agree ... one of my goals (shared with some other people) is to
On Tue, Jun 24, 2003 at 12:16:43PM +0200, Uros wrote:
> Hello ,
>
> I have table directory with 3 columns (id,url,title)
>
> I want to list all entries with duplicate urls.
>
> I tried this:
>
> select id,url,title from directory where url IN
> (select url from directory group by url having c
Uros wrote:
(B>
(B> I want to list all entries with duplicate urls.
(B>
(B> I tried this:
(B>
(B> select id,url,title from directory where url IN
(B> (select url from directory group by url having count(url) > 1)
(B> ORDER by url;
(B
(BTry:
(B
(Bselect id,url,title from directory w
Hello ,
I have table directory with 3 columns (id,url,title)
I want to list all entries with duplicate urls.
I tried this:
select id,url,title from directory where url IN
(select url from directory group by url having count(url) > 1)
ORDER by url;
but this takes 30 seconds with 25.000 entrie
Dennis Gearon wrote:
so,
if Postgres were to have a manual like PHP's OLD manual(more next),
that would be a worthwhile contribution?
the new manuals seems to be drifting to using only GOOGLE listings.
MUCH less information on one page, not nearly as good search results as
the old one. I
Joe Conway wrote:
I get nanswers = 16777216, so right off the bat 67MB or so is allocated.
Then there's this:
/* compute the cross product from right to left */
for (;;)
{
oneres = (Oid *) palloc0(FUNC_MAX_ARGS * sizeof(Oid));
I'm guessing this gets executed nanswers times.
> ??? You can look at an HTML file directy with any browser. If you're SSH-ing
> in to a remote system, use Lynx. Though I agree that providing both man and
> html would be nicer.
Try accessing a HTML file on a Linux system from a PC-based browser.
Unless you have some kind of file sharing
58 matches
Mail list logo
