Stephen Howard wrote:
also, as much as i really like o'reilly books in general, i find the
index in this one quite lacking.
Yeah, I agree, and I work with one of the authors and he says the same
thing! (long story, not worth it)
In its stead, you can search and read the entire book at our webs
On Feb 19, 2004, at 1:24 PM, Simon Windsor wrote:
Hi
I am used to using Oracle (15 years) and MySQL(5 years), but I am
planning to move an existing application from MySQL to Postgres. The
reasons are very simple,
• New requirements means we need views, or a significant re-write
• Bett
Hi
I am used to using Oracle (15 years) and MySQL(5 years), but
I am planning to move an existing application from MySQL to Postgres. The
reasons are very simple,
New requirements means we need
views, or a significant re-write
Better query/index performance
essential.
On Thursday 19 February 2004 17:41, Sally Sally wrote:
> I had a few questions
> concerning the backup/restore process for pg.
Please don't post HTML if you can avoid it.
> class=RTE>
> 1) Is it possible to dump data onto an existing
> database that contains data (assumning the schema of both ar
on 2/16/04 10:51 AM, [EMAIL PROTECTED] purportedly said:
> I am trying to gather stats about how many times a resource in our web
> app is viewed, i.e. just a COUNT. There are potentially millions of
> resources within the system.
>
> I thought of two methods:
>
> 1.An extra column in the re
On Thu, 19 Feb 2004, Sally Sally wrote:
> I had a few questions concerning the backup/restore process for pg.
>
> 1) Is it possible to dump data onto an existing database that contains data
> (assumning the schema of
> both are the same). Has anyone done this? I am thinking of this in order to
On Thu, 19 Feb 2004, Ed L. wrote:
> On Thursday February 19 2004 9:13, Bruce Momjian wrote:
> > >
> > > The 7.3.4 doc (doc/html/runtime-config.html) does say the
> > > log_connections option can only be set at server start or in the
> > > postgresql.conf configuration file. That seems a little am
Dear Sally Sally ,
I had a few questions concerning the backup/restore process for pg.
1) Is it possible to dump data onto an existing database that contains
data (assumning the schema of both are the same). Has anyone done
this? I am thinking of this in order to expediate the data load proces
rserv doesn't work with 7.4 AFAIK. erserver seems to; I haven't
actually used it in production, although I'm about to. dbmirror has
had reports of success.
We have several clients running erserver w/ 7.4, with another deploying
this coming weekend, and haven't had any reports of problems ...
W
Mammoth is something you would have to ask Joshua Drake about. Don't
know anything about it.
Just FYI: There is very detailed information about Mammoth Replicator
located here:
http://www.commandprompt.com/entry.lxp?lxpe=304
Sincerely,
Joshua D. Drake
Is pgReplication ready for 7.4 yet? And
hi, all!
how can i use unicode in postgresql tables?
"createdb -E UNICODE dbname" work correctly, but when i put data and then
read it i see only garbage instead cyrillic letters. what i do wrong?
--
FreeLSD
Best regards, Pavel aka crazy
Linux Registered User #303117
---
Louis P. Boudville wrote:
1.Where can I get end user support for PostgreSQL ?
You could use this mailing list, the #postgresql channel on the Freenode
IRC server or do a search for commercial Postgres support. The techdocs
on the Postgresql.org site would be my first stop, and you can also
I had a few questions concerning the backup/restore process for pg.
1) Is it possible to dump data onto an existing database that contains data (assumning the schema of both are the same). Has anyone done this? I am thinking of this in order to expediate the data load process
2) I read that wh
Jan Wieck wrote:
> John Small wrote:
>
> > I want to use PostgreSQL on a project that will have to run on
> > both Linux and Windows. But using cygwin is not a viable option.
> >
> > Does the dbExpert version of PostgreSQL run natively under Windows?
>
> Last time I checked the dbExperts versio
John Small wrote:
I want to use PostgreSQL on a project that will have to run on
both Linux and Windows. But using cygwin is not a viable option.
Does the dbExpert version of PostgreSQL run natively under Windows?
Last time I checked the dbExperts version was the cygwin port, bundled
with a stri
On Thursday 19 February 2004 15:50, Denny Morais wrote:
> Hi,
>
> I have a software that use a postgresql database. I am using SuSE 8.2 and
> would like to edit the program tables... Is there any software to do that?
>
> I have never used postgresql before, so I am sorry for the newbie question
> a
On Thu, 19 Feb 2004, Alex wrote:
> Hi,
> just a few questions on the Vaccum
>
> I run a vacuum analyze on the database every night as part of a
> maintenance job.
>
> During the day I have a job that loads 30-70,000 records into two tables
> (each 30-70k).
> This job runs 2-3 times a day; the fi
Bruce Momjian <[EMAIL PROTECTED]> writes:
> The issue is that you can't set log_connections from psql. Should we
> improve the doc wording?
I think the only thing missing is that in the introduction to section
16.4, where it says "The configuration file is reread whenever the
postmaster process r
Randall Skelton wrote:
Greetings all,
I am trying to do what should be a simple join but the tables are
large and it is taking a long, long time. I have the feeling that I
have stuffed up something in the syntax.
Here is what I have:
telemetry=> select (tq1.timestamp = tq2.timestamp) as time
Hi,
try this on psql console:
explain analyze select tq1.*, tq2.* from
cal_quat_1 tq1, cal_quat_2 tq2
where tq1.timestamp = tq2.timestamp
and tq1.timestamp > '2004-01-12 09:47:56. +0'::timestamp with time zone
and tq1.timestamp < '2004-01-12 09:50:44.7187 +0'::timestamp with time zone
order by
On Thursday February 19 2004 9:13, Bruce Momjian wrote:
> >
> > The 7.3.4 doc (doc/html/runtime-config.html) does say the
> > log_connections option can only be set at server start or in the
> > postgresql.conf configuration file. That seems a little ambiguous on
> > the SIGHUP'ability of that opt
At 01:44 AM 2/19/2004 +0100, Dirk Olbertz wrote:
I'm currently about to redesign a database which you could compare with a
database for managing a library. Now this solution will not only manage one
library, but 100 to 500 of them. Currently, eg. all the data about the
inventory (books) is held in
22 matches
Mail list logo
