Not really a PG-related question, but we are looking to migrate a
customer from Oracle on Windows to PG on Linux. The only problem is that
the company is already using reportwriter tools like Crystal Reports and
Oracle's reportwriter. They are open to be migrated if we can come up
with a repor
>The only problem is that the company is already using reportwriter tools
like Crystal Reports...
Hello.
Crystal Reports via ODBC should work, doesn't it?.
Pablo.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL P
>> Original Message <<
On 1/28/02, 12:19:38 PM, "Pablo Prieto" <[EMAIL PROTECTED]> wrote
regarding Re: [ADMIN] OT: Decent GUI-based reportwriter for Linux?:
> >The only problem is that the company is already using reportwriter
tools
> like Crystal Reports...
Hello there
Running postgreSQL 7.0.3 on a SuSE linux server (1GHz, PIII, 384 MB RAM) I
have problems with the performance. There are three to six postmaster
processes running. One with ODBC connector to a NT server , the others use
JDBC. Each month, we're having this situation. The customer encou
pgsqlPostgres automatically creates a unique index to assure data integrity
(see CREATE INDEX statement).
The online docs at
http://www.postgresql.org/idocs/index.php?sql-createtable.html state the
following:
" Postgres automatically creates a unique index to assure data integrity
(see CREATE IN
[EMAIL PROTECTED] writes:
> Please help me in analyzing this output. After vacuum/analyze, the
> performance is ok for another month.
So, vacuum on a regular basis. Most people do it at least once a day.
regards, tom lane
---(end of broadcast)---
On Mon, 28 Jan 2002, Marc Mitchell wrote:
> pgsqlPostgres automatically creates a unique index to assure data integrity
> (see CREATE INDEX statement).
>
> The online docs at
> http://www.postgresql.org/idocs/index.php?sql-createtable.html state the
> following:
>
> " Postgres automatically creat
I haven't _used_ this software, and it's not ready as a 'drop in' app,
but have you looked at the GNU Enterprise work? I've been tracking that
project via the kt.zork.net 'Kernel Cousins' weekly summary. It sounds
like it's targeted at what you want, eventually. Their site is at:
http://www.gnuen
[EMAIL PROTECTED] wrote in message
news:<[EMAIL PROTECTED]>...
> Hello there
>
> > Please help me in analyzing this output. After vacuum/analyze, the
> performance is ok for another month.
>
Are you regularily doing a "vacuum analyze"? This is a critical step
to maintaining the database as Pos
Aha! Someone in the Crystal know! Thanks for the very handy reply!
The reports cannot be static, they need to be dynamic, so unfortunately
cannot be served up as you suggest.
The reasons for going Linux/PG are many. To name a few:
Cost
Security
Reliability
Availability
System administr
I'm confused because after implementing much performance tuning advice I've
found that postgresql is no faster than when configured with the factory
defaults. The particular query I used for testing exemplifies the type of
query I need to run often.
All of my queries rely heavily on doing INSERT
Andy,
I think that there is a database created as part of the regression tests
that you can probably use (src/test/regress).
hih
steve boyle
- Original Message -
From: "Andy Ruhl" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 28, 2002 2:24 AM
Subject: [ADMIN] Sample
Check this
http://candle.pha.pa.us/main/writings/pgsql/hw_performance/index.html
I would think that you would see *some* increase in performance by turning
fsync off I see huge increases in performance of INSERT/UPDATE with
fsync off.
-Mitch
- Original Message -
From: "Peter T. Brow
On Mon, 28 Jan 2002, Steve Boyle (Roselink) wrote:
> I think that there is a database created as part of the regression tests
> that you can probably use (src/test/regress).
And since you referenced src, it must be within the source tree? I don't
have the source tree but I'll grab it. The ports
"Peter T. Brown" <[EMAIL PROTECTED]> writes:
> All of my queries rely heavily on doing INSERT INTO. So is there some
> special behavior with insert's, where they are flushed to disk one by one?
> If I simply increase checkpoint_segments to 50 or so would this cause
> inserts to occur only in memor
Regarding the SQL: The query I showed there is built dynamically from a
library of queries chosen by the application user (using a web gui). For
now, I don't have any way to intelligently condense the often complex series
of operations into a single 'smart' query.
That being said, I still don't u
"Peter T. Brown" <[EMAIL PROTECTED]> writes:
> Regarding the SQL: The query I showed there is built dynamically from a
> library of queries chosen by the application user (using a web gui). For
> now, I don't have any way to intelligently condense the often complex series
> of operations into a si
In the query:
select field, length(field) from table where length(field) < 10;
How many times is the length() function called for each row?
Once or twice?
Thanks,
--
Steve Chadsey <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 5: Have
Has anyone out there got any experience in importing complete Oracle Dbs
into PG?
Any tip would be useful! A tool to do this would be awesome!
Thanks!
Brad
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTEC
Bradley Kieser wrote:
> Has anyone out there got any experience in importing complete Oracle Dbs
> into PG?
>
> Any tip would be useful! A tool to do this would be awesome!
There is an Oracle porting tool in PostgreSQL's /contrib.
--
Bruce Momjian| http://candle.ph
is there any way in postgres (7.1.3) to get postgres to source the
pg_hba.conf file without restarting the database completely?
will any new backend use a modified pg_hba.conf if it is modified while
postgres is running?
-tfo
---(end of broadcast)-
Thomas F. O'Connell wrote:
> is there any way in postgres (7.1.3) to get postgres to source the
> pg_hba.conf file without restarting the database completely?
>
> will any new backend use a modified pg_hba.conf if it is modified while
> postgres is running?
>
In 7.1.X and earlier, pg_hba.conf
> In 7.1.X and earlier, pg_hba.conf is reread on every connection request.
> 7.2.X will requires a sighup to the postmaster to reload pg_hba.conf.
why the change?
-tfo
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, pleas
Thomas F. O'Connell wrote:
> > In 7.1.X and earlier, pg_hba.conf is reread on every connection request.
>
> > 7.2.X will requires a sighup to the postmaster to reload pg_hba.conf.
>
>
> why the change?
Performance. Faster to cache contents.
--
Bruce Momjian| http
Hi all,
I am writing a php script to backup my
postgres database through web interface, but my database is password
required. When I do a pg_dump at the linux shell prompt, it will prompt
for password in order to backup the database, does anyone know how to pass this
password with the pg
25 matches
Mail list logo
