I am using database Postgresql 9.0.1.
For some reasons, my database was crashed.
At first I found:
DETAIL: The database cluster was initialized with PG_CONTROL_VERSION 0, but
the server was compiled with PG_CONTROL_VERSION 903.
I solved it by copying pg_control from a new cluster
Then I got,
FA
On 17/07/2011 5:19 PM, AI Rumman wrote:
I am using database Postgresql 9.0.1.
For some reasons, my database was crashed.
At first I found:
DETAIL: The database cluster was initialized with PG_CONTROL_VERSION 0,
but the server was compiled with PG_CONTROL_VERSION 903.
First, read and act on th
Hello all,
I am testing a backup and restore of a db in version 7.4.30. During the
restore, after successfully restoring many BLOBS, I get the following error:
pg_restore: restoring large object OID 318907
pg_restore: restoring large object OID 318909
pg_restore: restoring large object OID 3189
Chris McCormick writes:
>I am testing a backup and restore of a db in version 7.4.30. During the
> restore, after successfully restoring many BLOBS, I get the following error:
How many is "many"?
> pg_restore: restoring large object OID 318907
> pg_restore: restoring large object OID 318909
I'm about to buy a new desktop home computer and my main concern is best
Poker Tracker performance.
Poker Tracker uses PostgreSQL so I thought this will be the best place to
ask.
My DB is big, around 5M hands(big is relative of course), I use complex
HUD(if you know what it is), run complex report
On 18/07/2011 9:37 AM, mdxxd wrote:
CPU:
*Will PostgreSQL benefit from using hyperthreading in i7 2600k CPU? Or will
there be no noticeable performance change if I use i5 2500K CPU(i.e no HT,
just 4 cores)?
On a typical desktop system, hard disk I/O is the limiting factor rather
than CPU, so I i
On Sun, Jul 17, 2011 at 7:37 PM, mdxxd wrote:
> I'm about to buy a new desktop home computer and my main concern is best
> Poker Tracker performance.
> Poker Tracker uses PostgreSQL so I thought this will be the best place to
> ask.
>
> My DB is big, around 5M hands(big is relative of course), I u
*Database Version:* Postgresql 9.0.1
*OS:* Linux rumman.dhaka 2.6.18-92.el5xen #1 SMP Tue Jun 10 19:55:54 EDT
2008 i686 i686 i386 GNU/Linux
*Installed from:* Source configure
*Problem:*
When I try to connect to postgres, I got -
psql: FATAL: role "postgres" does not exist
In fact, it seems to me t
On Jul 17, 2011, at 9:36 PM, AI Rumman wrote:
> Database Version: Postgresql 9.0.1
> OS: Linux rumman.dhaka 2.6.18-92.el5xen #1 SMP Tue Jun 10 19:55:54 EDT 2008
> i686 i686 i386 GNU/Linux
> Installed from: Source configure
> Problem:
> When I try to connect to postgres, I got -
> psql: FATAL: r
