On Sat, 2005-10-01 at 21:43 -0700, Jeff Frost wrote:
> On Fri, 30 Sep 2005, Simon Riggs wrote:
>
> > If I follow your example, yes. But that assumes there is only one
> > timeline's WAL files in your pg_xlog. It could get more complex in that
> > situation because you could be in any of the timeli
Hi,
Which backup software out there work well with postgresql, I
cannot find one with backup agent for postgres.
I am looking for a backup solution that will backup the
postgres database from a fiber channel san to a fiber channel tape library, any
one here have experience with simi
I'm going the easy route with that one.
I do a full dump every night - which goes to tape (using any type of tape
backup software) and is mirrored to another machine using rdist. For
continuous backup I use Slony to replicate the master database to two
off-site backup servers. That way there ar
Hi,
Arkeia do this ... but the PostregSQL agent is not free.
regards,
Le Dimanche 2 Octobre 2005 14:06, Robert Ngo a écrit :
> Hi,
>
>
>
> Which backup software out there work well with postgresql, I cannot find
> one with backup agent for postgres.
>
>
>
> I am looking for a backup solution tha
I'm going to attempt to do my best in describing the situation... so please
forgive any ignorance on my part since I am very new to the Postgres community.
We have 2 identical Postgres databases, one on a Windows 2003 platform, and the
other on a SUSe 9.3 Linux platform (both platforms have iden
Hello!
When I install Postgresql 8.0.3 on my Windows server, I set LC_COLLATE
and LC_CTYPE to Russian_Russia.1251 via install process.
But when I install Postgresql server on Fedora Core 4 Linux, I can't
set LC_COLLATE and LC_CTYPE to Russian_Russia.1251. Maximum, that I
may set, is ru_RU.KOI8-R.
Hi:
I wrote a function for my database and 'loaded' it, but then
misplaced the code. Is there a query I can issue to retrieve it?
Thanks
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose
Greetings,
I am attempting to setup a DTS package in Sql Server that
will copy over data from a Postgres database. I have followed the instructions
found here (http://techdocs.postgresql.org/techdocs/usingpostgresqlwithdotnet.php)
but am still unable to connect. The error I receive when
Hello,Im trying to make a remote
connection using a Windows Program called "EMS PostgreSQL Manager".I am
having issues setting up the pg_hba.conf properly to allow a user to make
connections only to his assigned database.Following the PostgreSQL
documentation I could sucessfuly connect using
Hello,
Our server crashed and some of the pgsql/base files got corrupted. 2 out
of 10 databases now reject all connections with error:
psql: FATAL: "/var/db/pgsql/base/17236" is not a valid data directory
DETAIL: File "/var/db/pgsql/base/17236/PG_VERSION" is missing.
We have dump that's a w
Hi all, does anyone have experience with integrating postgres into HP
Openview? Looking at different utilities and HPOV was suggested, however
I can't seem to find much information regarding this combination.
Archives and google don't turn up much so I am hoping for any first hand
experience or
Is it possible to do something like that (taken from Oracle world):
I have two phisical disc (diskA and diskB). I would like to put:
- database data files on diskA,
- database WAL on diskA and diskB (dual logging),
- database archive logs on diskA and diskB.
With this kind of configuration, I cou
I am using postgres 7.4.5, and have a corrupt pg_statistic.
Many commands cause the following error:
ERROR: invalid page header in block 10 of relation "pg_statistic"
I want to preserve my data if at all possible, I figured I would just
dump the database and reload it. I tried
pg_dump, but it giv
Hi,
I am looking at using the iscsi version of Dell|EMC AX100i as
the SAN storage for my network, this solution is using 7200rpm sata, Is this
SAN suitable to be use as storage space for postgresql. Any one here have experience
in setting up iscsi SAN for postgresql database?
Hi folks at pgsql.admin,
I've Postgres 8.0.1 running natively under Windows XPpro SP2. I would
like to update to 8.0.3 using the upgrade-batchfile coming with the
zipped download file.
The installation stops when trying to install the service, saying the
Postgres 8.0 Database Service could not be
Colton A Smith wrote:
> Hi:
>
>I wrote a function for my database and 'loaded' it, but then
> misplaced the code. Is there a query I can issue to retrieve it?
psql \df+? That works for non-C languages.
--
Bruce Momjian| http://candle.pha.pa.us
pgman@candle.pha
In-time for PostgreSQL 8.1 gold, The pgAdmin Developer Team will release
pgAdmin III V1.4, which has a new Guru hint feature that tries to give
users helpful hints on typical beginner's pitfalls.
The current set of hints is at
http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/trunk/pgadmin3/docs/en_US
Bruce Momjian writes:
> Colton A Smith wrote:
>> I wrote a function for my database and 'loaded' it, but then
>> misplaced the code. Is there a query I can issue to retrieve it?
> psql \df+? That works for non-C languages.
Also, consider doing "pg_dump -s yourdb" and then pulling the CREATE
FU
"Jeff Kirby" <[EMAIL PROTECTED]> writes:
> the Linux box however is still chugging away this morning... and
> appears to be stuck on vacuuming "pg_constraint_contypid_index". How
> do I know... well I don't really... I'm inferring based on the order
> of the log output on the Windows box.
Looking
Kevin Seghetti <[EMAIL PROTECTED]> writes:
> Is there any way to nuke pg_statistic (since its contents can be
> recalculated anyway?)
You want to do "TRUNCATE pg_statistic"; to avoid the permission check,
you'll need to do that in a standalone backend with -O option.
Do *not* try to drop and recr
On Mon, Oct 03, 2005 at 02:16:37AM +0200, Andreas Pflug wrote:
> In-time for PostgreSQL 8.1 gold, The pgAdmin Developer Team will
> release pgAdmin III V1.4, which has a new Guru hint feature that
> tries to give users helpful hints on typical beginner's pitfalls.
>
> The current set of hints is a
On Thu, 29 Sep 2005, Ben Sullins wrote:
I logged onto the linux box via ssh and edited the file by adding a line
in pg_hba.conf for my ip. I'm thinking it other lines above my new entry
could be affecting my access restrictions. Below are the lines in order
as they appear in pg_hba.conf. Any ass
22 matches
Mail list logo