To me PITR looks like a very nice solution for incremental backup and even
they can serve as a warm standby. What exactly are the complications you see
with WAL archiving?
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/13/06, Eduardo J. Ortega <[EMAIL PROTECTED]> wrote:
H
Hi there:
Are there any nice (official or third party) backup utilities for postgres? I
have a database which is several GB, so pg_dumping it to file and then
bzipping2 every hour is not really the way to go. I've read a little about
using WAL for incremental backup, but it sounds a little comp
Gábriel Ákos wrote:
> Rajesh Kumar Mallah wrote:
> > On 12/12/06, Tom Lane <[EMAIL PROTECTED]> wrote:
> >> "Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes:
> >> > Can you *please* tell how to get the fix.
> >>
> >> Checkout REL8_2_STABLE branch, not HEAD ...
>
> I've checked out that and (for exa
No, Pg Admin connects to 5432 as that is PostgreSQL's server port.
One popular misconfiguration I've seen is that the connection/traffic is
*to* port 5432 on the server, not from port 5432 on the client.
So, depending on your firewall you need rule 1 on it's own (if it
supports keeping state)
Rajesh Kumar Mallah wrote:
> On 12/12/06, Tom Lane <[EMAIL PROTECTED]> wrote:
>> "Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes:
>> > Can you *please* tell how to get the fix.
>>
>> Checkout REL8_2_STABLE branch, not HEAD ...
I've checked out that and (for example) there is no parse.h in it ...
You can get the latest easy to use installer from
http://www.postgresql.org/ftp/binary/v8.2.0/win32/
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/6/06, Aleksander Slavchev <[EMAIL PROTECTED]> wrote:
Hi!
I need to build data replication with PostgreSQL, BUT! on Windows
On Tue, 2006-12-05 at 10:01, dev.department wrote:
>
>
>
> Dear Sirs,
>
> We're a softwarehouse who is considering the possibility to insert the
> PostgreSQL 8.1 database in our software.
> How can we prevent the visualization of structure and data (tables,
> views, etc.) of a PostgreSQL 8.
Hi!
I need to build data replication with PostgreSQL, BUT! on Windows 2003
platform.
So i start tro read about slony, pgpool and other but I can't find some
reasonable descriptyion haw to instal configure and start PostgreSQL
instalation on Windows platform.
Do you have some useful information? -
Dear Sirs,
We're a softwarehouse who is considering the possibility to insert the
PostgreSQL 8.1 database in our software.
How can we prevent the visualization of structure and data (tables, views,
etc.) of a PostgreSQL 8.1 database? Keep present that the person who has
installed PostgreSQL
Hi, I've got a very simply in my mind problem with trigger functions.
My functions returns SKIP in some cases.
But when i execute a statement with psql or with api
postgresql didn't return error but in psql:
DELETE 0
or
INSERT 0 0
and in my CGI scipts situation is the same.
how can i find tha
I have a postgresql database at the server, with firewall protected. And I want
to access the database remotely using pgadmin on the client side. I have
configured the postgre configuration file in such way that the client can
access the database remotely using pgadmin, but when I turn on the fi
Typically in this scenario, more and larger WAL segments can help speed
up your updates. However, the default size of a WAL segment is 16MB
which can be set at postgresql compile time, and can not be changed
thereafter. So, you'd need to increase the checkpoint_segments
parameters to speed up your
On 12/12/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes:
> Can you *please* tell how to get the fix.
Checkout REL8_2_STABLE branch, not HEAD ...
Thanks!.
regards, tom lane
---(end of broadcast)--
"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes:
> Can you *please* tell how to get the fix.
Checkout REL8_2_STABLE branch, not HEAD ...
regards, tom lane
---(end of broadcast)---
TIP 6: explain analyze is your friend
On 12/12/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes:
> below query crashes 8.2.0
> tradein_clients=> SELECT size from general.eyp_listing where size in
> (select distinct size from general.eyp_listing ) order by size limit
> 1;
Already fixed.
Hi,
"Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes:
> below query crashes 8.2.0
> tradein_clients=> SELECT size from general.eyp_listing where size in
> (select distinct size from general.eyp_listing ) order by size limit
> 1;
Already fixed.
regards, tom lane
Hi,
below query crashes 8.2.0
tradein_clients=> SELECT size from general.eyp_listing where size in
(select distinct size from general.eyp_listing ) order by size limit
1;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while
Hello,
I have many updates happening in the DB. All of them works with millions of
rows. When this happens I get the following message:
checkpoints are occurring too frequently (294 seconds apart)
Consider increasing the configuration parameter "checkpoint_segments".
Some values from my postgre
=?ISO-8859-2?Q?G=E1briel_=C1kos?= <[EMAIL PROTECTED]> writes:
> go to psql
> issue \di+
> server closes connection :)
Works for me. Can you narrow it down a bit? Perhaps corruption in a
system catalog? A backtrace from the server coredump might be useful.
regards, tom l
Manuel Trujillo wrote:
> The problem: Encoding incompatibilities between the postgresql
> version.
In detail?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
On 12/12/06, Gábriel Ákos <[EMAIL PROTECTED]> wrote:
go to psql
issue \di+
server closes connection :)
Akos,
Can you please paste the exact message with which
server closes connection. also start psql with -E option
Regds
mallah.
Regards,
Akos
---(end of broadcast)
Exactly the same I too got as output without getting a bug in ver 8.2 :)
---
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hm, i can't see any bug here:
template1=# \di+
No relations found.
template1=#
Works also on a dat
Hm, i can't see any bug here:
template1=# \di+
No relations found.
template1=#
Works also on a database with existing indexes.
Greetings,
Matthias
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Gábriel Ákos
> Sent: Tuesday, December 12, 2006 1:2
go to psql
issue \di+
server closes connection :)
Regards,
Akos
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Have you tried using 'iconv' for cleaning up the invalid UTF8 character? In
case of big files you can always split them.
-
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 12/12/06, Manuel Trujillo <[EMAIL PROTECTED]> wrote:
Hi!
Firs, I will apologize about my bad english...
Hi!
Firs, I will apologize about my bad english... sorry...
I have a database in postgres 8.0 with encoding defined with UTF8. All
work fine, but because the new features from 8.2 version, we would like
to migrate the database to this new version.
The problem: Encoding incompatibilities between t
26 matches
Mail list logo
