Jayakumar_Mukundaraju wrote:
>
> I am new to Postgresql Database. My setup is backend is postgresql
> database, frontend is Java(JDBC). I installed the postgres in windows
> platform. Now I want to setup server and client configuration. Kindly
> guide me how to set the configuration parameters, in
On Mon, 2007-06-18 at 13:02 -0400, Jonah H. Harris wrote:
> On 6/18/07, Andreas Kostyrka <[EMAIL PROTECTED]> wrote:
> > As a cynic, I might ask, what Oracle is fearing?
>
> As a realist, I might ask, how many times do we have to answer this
> type of anti-commercial-database flamewar-starting ques
Your best bet on something like this is probably going to be
contacting a company that does PostgreSQL support and inquiring about
data recovery. EnterpriseDB and Command Prompt both employ folks who
could probably accomplish this; I think OmniTI might as well. There's
probably a few others
On Jun 14, 2007, at 8:16 AM, Michael Fuhr wrote:
On Thu, Jun 14, 2007 at 06:10:15PM +0530, Shyam Sunder Rai wrote:
How can I calculate a table size in postgres ?
To find the size of an existing table use pg_relation_size() or
pg_total_relation_size() (8.1 and later; in earlier versions use
the
About 2 years ago a new guy at our company deleted all contents of a table on a development server and I managed to
restore them by changing the XID value with pg_resetxlog.
You can get last chackpoint's XID by running pg_controldata; then use pg_resetxlog -x and try different values. You'll
ne
I don't want to add gas to the flamewar, but I gotta ask. What is in
the the 90 to 95% referred to in this email.
Carol
On Jun 18, 2007, at 1:17 PM, Joshua D. Drake wrote:
Jonah H. Harris wrote:
On 6/18/07, Andreas Kostyrka <[EMAIL PROTECTED]> wrote:
As a cynic, I might ask, what Oracle is
Στις Τρίτη 19 Ιούνιος 2007 15:39, ο/η Carol Walter έγραψε:
> I don't want to add gas to the flamewar, but I gotta ask. What is in
> the the 90 to 95% referred to in this email.
short answer: all cases, possibly except when running a Bank or something
similar.
>
> Carol
>
> On Jun 18, 2007, at 1
Andrew Kelly wrote:
On Mon, 2007-06-18 at 13:02 -0400, Jonah H. Harris wrote:
On 6/18/07, Andreas Kostyrka <[EMAIL PROTECTED]> wrote:
As a cynic, I might ask, what Oracle is fearing?
As a realist, I might ask, how many times do we have to answer this
type of anti-commercial-database flamewar-s
Can we please trim this down to just advocacy?
On Jun 18, 2007, at 1:17 PM, Joshua D. Drake wrote:
Jonah H. Harris wrote:
On 6/18/07, Andreas Kostyrka <[EMAIL PROTECTED]> wrote:
As a cynic, I might ask, what Oracle is fearing?
As a realist, I might ask, how many times do we have to answer th
[EMAIL PROTECTED] (Carol Walter) writes:
> I don't want to add gas to the flamewar, but I gotta ask. What is in
> the the 90 to 95% referred to in this email.
I'd say, look at the Oracle feature set for things that it has that
PostgreSQL doesn't.
Four that come to mind:
- ORAC = multimaster rep
[EMAIL PROTECTED] (Achilleas Mantzios) writes:
>> I don't want to add gas to the flamewar, but I gotta ask. What is in
>> the the 90 to 95% referred to in this email.
>
> short answer: all cases, possibly except when running a Bank or something
> similar.
No, it's not to do with what enterprise
>>> On Tue, Jun 19, 2007 at 8:07 AM, in message <[EMAIL PROTECTED]>,
Chander Ganesan <[EMAIL PROTECTED]> wrote:
> Kevin Grittner wrote:
>>
>> weekly maintenance process which builds a new version of a table based on
>> records retention rules. It is built under a temporary name; then the
>>
I'm finaly switching to 8.2. I notice that ugly 'feature' from pg8.1 has
been fixed: logging the parametars of prepared statements. It's a bit
ugly, but it's there :)
But now in my log i have BINDLOG, PARSELOG and others, and my log looks
realy cloged. Here is an example. I'm calling the
'create_m
Mario Splivalo wrote:
> I'm finaly switching to 8.2. I notice that ugly 'feature' from pg8.1 has
> been fixed: logging the parametars of prepared statements. It's a bit
> ugly, but it's there :)
> 2007-06-19 16:22:15.555 CEST [4596] BINDLOG: duration:
> 0.027 ms bind S_2: COMMIT
> 2007-06-19 16
The most important point is that third one, I think:
"any application where reliability requirements do not warrant
spending $1M to make it more reliable"
Adopting ORAC and/or other HA technologies makes it necessary to spend
a Big Pile Of Money, on hardware and the humans to administer it.
On Tue, 2007-06-19 at 10:52 -0400, Alvaro Herrera wrote:
> Mario Splivalo wrote:
> > I'm finaly switching to 8.2. I notice that ugly 'feature' from pg8.1 has
> > been fixed: logging the parametars of prepared statements. It's a bit
> > ugly, but it's there :)
>
> > 2007-06-19 16:22:15.555 CEST [45
Hi,
I'm trying to move a database from postgresql 7.4 to postgresql 8.1.
Unfortunately this is not going well. This is what I did:
pg_dump --file dbsnapshot --format=t -a -b
and then I installed 8.1, and attempted the following:
pg_restore --file dbsnapshot --format=t --table=ingeststatus -
Hi All,
I want to dump the database by using pg_dump command but the problem is the
version at the server is 7.4 which doesn't support the provision for
excluding tables as in version 8.2.
There are 500+ tables in the database,from which 15-20 are of huge sizes.I
want to exclude them.Is there a
Andrew Kelly wrote:
On Mon, 2007-06-18 at 13:02 -0400, Jonah H. Harris wrote:
On 6/18/07, Andreas Kostyrka <[EMAIL PROTECTED]> wrote:
As a cynic, I might ask, what Oracle is fearing?
As a realist, I might ask, how many times do we have to answer this
type of anti-commercial-database flamewar-s
Hi,
I am attempting to use the WAL archiving on a Solaris machine, running
PostgreSQL 8.1.4. The archive_command specified in the postgresql.conf file
does not get executed, nor do I see any log entries showing errors etc.
What am I doing wrong here?
Here is the relevant fragment of my c
Karl Wright <[EMAIL PROTECTED]> writes:
> But, I get the following error:
> pg_restore: [tar archiver] could not find header for file toc.dat in tar
> archive
Could we see "pg_restore -l" output for that dump file?
This looks a bit like some bugs we've seen before, eg,
http://archives.postgresql
cha <[EMAIL PROTECTED]> writes:
> I want to dump the database by using pg_dump command but the problem is the
> version at the server is 7.4 which doesn't support the provision for
> excluding tables as in version 8.2.
If you're dumping with the intent to update to 8.2, you could use 8.2's
pg_dum
George Wilk wrote:
Hi,
I am attempting to use the WAL archiving on a Solaris machine, running
PostgreSQL 8.1.4. The archive_command specified in the
postgresql.conf file does not get executed, nor do I see any log
entries showing errors etc. What am I doing wrong here?
Here is the
Tom Lane wrote:
Karl Wright <[EMAIL PROTECTED]> writes:
But, I get the following error:
pg_restore: [tar archiver] could not find header for file toc.dat in tar
archive
Could we see "pg_restore -l" output for that dump file?
This looks a bit like some bugs we've seen before, eg,
http://archi
Karl Wright wrote:
Tom Lane wrote:
Karl Wright <[EMAIL PROTECTED]> writes:
But, I get the following error:
pg_restore: [tar archiver] could not find header for file toc.dat in
tar archive
Could we see "pg_restore -l" output for that dump file?
This looks a bit like some bugs we've seen befo
Karl Wright <[EMAIL PROTECTED]> writes:
> and then I installed 8.1, and attempted the following:
> pg_restore --file dbsnapshot --format=t --table=ingeststatus -a
> But, I get the following error:
> pg_restore: [tar archiver] could not find header for file toc.dat in tar
> archive
Oh, I'm overthi
>>> On Tue, Jun 19, 2007 at 11:16 AM, in message <[EMAIL PROTECTED]>,
Tom Arthurs <[EMAIL PROTECTED]> wrote:
>
> Looks like you are expecting the archive command to run when you shut
> down the data base. It won't. It only runs when the xlog gets full and
> the system needs to recycle to a new
Hello:
We are in the process of upgrading posgres from v7.3.9 to v8.2.4 In our
current environment (v7.3), we run a reindex operation on all tables to recover
space and improve performance (we have several tables with high insert/update
load - no deletes). Is it likely that the reindex will s
Bill Willits wrote:
> Hello:
>
> We are in the process of upgrading posgres from v7.3.9 to v8.2.4 In
> our current environment (v7.3), we run a reindex operation on all
> tables to recover space and improve performance (we have several
> tables with high insert/update load - no deletes). Is it l
Bill Willits wrote:
Hello:
We are in the process of upgrading posgres from v7.3.9 to v8.2.4 In our
current environment (v7.3), we run a reindex operation on all tables to
recover space and improve performance (we have several tables with high
insert/update load - no deletes). Is it likely
On Tue, 2007-06-19 at 08:17 -0400, George Wilk wrote:
> archive_command = 'touch /var/lib/pgsql/bkp/myfile'
Presumably you understand that an archive_command like the above is not
ever going to do any archiving?
set
log_min_messages = DEBUG1
if you want to see the archive messages.
B
On Mon, 2007-06-18 at 17:55 +0200, David Tokmatchi wrote:
> I am DBA for Oracle and beginner on Postgres. For an company in
> France, I must make a comparative study, between Postgres and Oracle.
> Can you send any useful document which can help me.
> Scalability ? Performance? Benchmark ? Availab
Hello people,
Having installed the universal binary for pg 8.2.4 on my mac
running 10.3.9, I'm now trying to use the initdb command,
but keep running into problems. I can't seem to get the
right syntax. Can anyone suggest where I'm going wrong?
Here's what terminal shows:
Acorn acorn 1 acorn$ log
No MAC expert but try this when changing to the postgres user:
su - postgres
the hyphen gives you an environment for the postgres user.
J. Herbers
Quoting Joe Barwell <[EMAIL PROTECTED]>:
Hello people,
Having installed the universal binary for pg 8.2.4 on my mac
running 10.3.9, I'm now try
I'm guessing all the problems below are something to do with the 'postgres'
user not having a correct shell login setup. It looks like the home
directory is set to /dev/null which would explain all the "not a directory"
errors.
You'll need to edit the postgers user to have a proper login shell
(/b
35 matches
Mail list logo
