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
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
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.
Crystal Reports via ODBC should
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
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
[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
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 creates a
[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 PostgreSQL
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.
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 memory and
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
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 single
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
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|
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
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 is
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, please
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|
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
21 matches
Mail list logo