If the database is not extremely huge, makes you wonder what does a RAID
actually give us. A robust near-realtime replication setup (say PITR + cloud)
may be good enough against once in a few years of disk failure.atleast you
don't add another point of failure that you (your database/OS) can't
wrote:
> I have serious problems recovering our db after recent raid5
> failure. Long story short - no recent dumps, some missing files
> (like pg_control).
Been there -- at least on the end of helping with recovery for
people in that position with a different database product. It can
be ver
"Vishnu S." wrote:
> I have disabled the WAL log
Exactly what did you do to accomplish that?
> the Postgres server stopped unexpectedly . Can you explain what
> is the reason behind this.?
Can you show us the error messages from the server log and the user
connections around the time of f
You might be able to do that will slony (haven't tried) and you might be even
be able to get away with a view
into the data depending on your requirements. -Tino
From: pgsql-admin-ow...@postgresql.org [pgsql-admin-ow...@postgresql.org] On
Behalf Of dimita
"Prasad DVN" writes:
> 2010-06-14 11:38:44.346 : :9456:LOG: received smart shutdown request
Something sent the postmaster process a SIGTERM signal. Don't do that ...
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to
On Sun, Jun 20, 2010 at 10:36, Elior Soliman wrote:
> Hello,
>
> My company looking for some solution for High availability with Postgres.
>
> Our optional solution is as follows :
> Two DB servers will be using a common external storage (with raid). Both
> servers are going to use the same DB fil
On Mon, 2010-06-21 at 16:22 +0530, Vishnu S. wrote:
> I have disabled the WAL log ,
What?
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.or
Hi,
I am new in PostgreSQL database.
I have a continuous running application that uses PostgreSQL as
database. This application inserts about 20 MB data into the database in
every second.I have disabled the WAL log , because all the data
inserting into the database is logged in the WAL files,
Hello,
My company looking for some solution for High availability with Postgres.
Our optional solution is as follows :
Two DB servers will be using a common external storage (with raid). Both
servers are going to use the same DB files on the storage (as
active/passive)
Now I'm trying to understa
Hi
I have a database running on server A. I need to have my custom web
interface from which i partition/replicate part of the data to other server.
Example:
Server A there is table with records from 1 to 100k.
Create the same database on the other server, partition this table on other
server tak
Hello
I have serious problems recovering our db after recent raid5 failure.
Long story short - no recent dumps, some missing files (like pg_control).
long version of the story:
our raid failed.. badly. I was able to recover most of the files but some
(like pg_control) are missing (possibly more,
Hi ,
We have postgressql database installed along with HP NNM, as an embedded
database.
The database is not starting up for some reason, due to which NNM is completly
down.
I did check the pg_log, and i see the following lines:
2010-06-14 11:36:23.790 : postgres:1256:0FATAL: no pg_hba.conf
Mike,
Doesn't look like it, at least on 8.4. Give the script below a try for
yourself.
Another approach would be to create a new table with the schema you need,
insert the rows from your existing table into it, rename the two tables
appropriately, then recreate the indexes and trigger on the ne
Excerpts from Mike Broers's message of lun jun 21 14:18:01 -0400 2010:
> I need to change service_name column to varchar(55), my plan was to backup
> the table with pg_dump, then run the below alter statement:
>
> alter table dim_product alter column service_name type varchar(55);
>
> But i am w
Pg v8.3.8
I have a table whose column size needs to be increased:
\d dim_product
Table "report.dim_product"
Column| Type
|
Modifiers
--+--+-
Hi all,
it's my first trial with pg_upgrade so I'm surely missing something
I'm trying to launch pg_upgrade passing my super user name but
pg_dumpall fails with a permission denied error
I don't see the username in the pgdumpall callcould it be this the
problem ?
Thank you (I hop
16 matches
Mail list logo
