Hello!
I think I found a proper utility for that: pg_filedump
http://sources.redhat.com/rhdb/utilities.html
Ciao,
Gerhard
--
http://www.wiesinger.com/
On Fri, 18 May 2007, Gerhard Wiesinger wrote:
Hello!
Are there any tools available to dump the files of the pg_xlog, pg_clog, ...
director
Hi,
I'm trying to dump and restore a copy of a database in the same
cluster. pg_restore would abort when creating a tsearch2 gist index.
So I dumped to text removed the CREATE INDEX commands and tried to do
that at the end after the rest of the database was loaded. I still
have the same p
Cyril VELTER wrote:
>
>>> Cyril VELTER wrote:
Searching the source files, it seems the error message is generated in
port/win32/socket.c line 594.
>>> Right, but the important thing is which path down to that function is it
>>> generated in. Which is why a backtrace would help.
>>
On Wednesday 23 May 2007 20:33, Ron Johnson wrote:
> On 05/23/07 19:17, Chris Browne wrote:
> > [EMAIL PROTECTED] ("Harpreet Dhaliwal") writes:
> >> I was just wondering if Vacuum Db in postgresql is somehow superior
> >> to the ones that we have in other RDBMS.
> >
> > The thing that is more akin
so the outfit i'm currently working for on a quasi-full time
basis has what amounts to an OLTP database server in colocation.
the footprint in the rack is very small, that is, there's no
DLT autoloader or anything of that sort in the rack.
the temporary backup solution was to do full dumps in cro
Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> A more interesting question is what sort of hardware you need for that
>> actually to be a win, though. Loading a few tables in parallel sounds
>> like an ideal recipe for oversaturating your disk bandwidth...
> you don't actua
"Richard P. Welty" <[EMAIL PROTECTED]> wrote:
>
> so the outfit i'm currently working for on a quasi-full time
> basis has what amounts to an OLTP database server in colocation.
> the footprint in the rack is very small, that is, there's no
> DLT autoloader or anything of that sort in the rack.
>
Bill Moran wrote:
As an aside, you can only fit so many gallons into a 10 gallon
container. You might simply have to accept that your requirements
now exceed the capacity of the RR connection and upgrade.
actually, what it will come down to is the cost of an upgraded
connection vs $60/month
is the host base configuration methodology in postgres superior to other
RDBMS.
is this something novel that postgres has come up with?
~Harpreet
On 5/26/07, Tom Lane <[EMAIL PROTECTED]> wrote:
Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> A more interesting question is
If you ask me, yes. When I had to choose between MySQL 3.x and
PostgreSQL 6.5 a long ago and I was able to exclude the DB superuser
with REVOKE CONNECT from MySQL, I said "no, thanks".
I did it on purpose to prove that you can the external configuration
is better in this case.
And apart from fixi
Zoltan Boszormenyi írta:
If you ask me, yes. When I had to choose between MySQL 3.x and
PostgreSQL 6.5 a long ago and I was able to exclude the DB superuser
with REVOKE CONNECT from MySQL, I said "no, thanks".
I did it on purpose to prove that you can the external configuration
is better in this
Scott Marlowe writes:
Note that if you're in a transaction, you don't technically need the
backup (doesn't hurt though) as if you get it wrong you can just roll it
back.
I know.. I do the backup in case I forget to do the transaction. :-)
---(end of broadcast)---
Zoltan Boszormenyi <[EMAIL PROTECTED]> writes:
> Harpreet Dhaliwal írta:
>> is the host base configuration methodology in postgres superior to
>> other RDBMS.
> If you ask me, yes. When I had to choose between MySQL 3.x and
> PostgreSQL 6.5 a long ago and I was able to exclude the DB superuser
>
Richard P. Welty writes:
actually, what it will come down to is the cost of an upgraded
connection vs $60/month
rent for 3Us of rack space to place a DLT autoloader in the colocation
facility.
How much data are you looking to backup?
There are companies that do rsync services.
Just saw one la
Tom Lane wrote:
> Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes:
>> Tom Lane wrote:
>>> A more interesting question is what sort of hardware you need for that
>>> actually to be a win, though. Loading a few tables in parallel sounds
>>> like an ideal recipe for oversaturating your disk bandwidth
MySQL has a related problem, which is that they have embedded IPv4
addressing rather deeply into their client authentication logic (by
making userids be [EMAIL PROTECTED] not just a username). This is probably why
they still haven't got IPv6 support:
http://bugs.mysql.com/bug.php?id=8836
I won
Francisco Reyes wrote:
Richard P. Welty writes:
actually, what it will come down to is the cost of an upgraded
connection vs $60/month
rent for 3Us of rack space to place a DLT autoloader in the
colocation facility.
How much data are you looking to backup?
There are companies that do rsync s
Andrus ha escrito:
> CREATE TRIGGER mycheck_trigger BEFORE INSERT OR UPDATE ON mytbl
> FOR EACH ROW EXECUTE PROCEDURE mycheck_pkey();
>
> aborts transaction if trigger already exists.
>
> There in no CREATE OR REPLACE TRIGGER command in PostgreSQL
>
> How to create trigger only when it does not
Richard P. Welty writes:
a couple of gig, not really all that much. the problem is that there is
an expectation of one or more persons/organizations going through
due diligence on the operation, and i'm not sure that a fuzzy
"somewhere online" file storage service will pass the smell test for
ma
Problem solved! It turns out the warm spare server wasn't the same release
of Linux, though that wasn't quite the problem. However, it also an older
version of the tar utility.
When I restored the index file with the problem, it came out as 32768 bytes
long rather than 40960 bytes long.
Upgrad
Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
>> Erik Jones wrote:
>>> And, to finish up, is there any reason that pg_restore couldn't
>>> already work with separate processes working in parallel?
>
>> The problem is that the ordering of objects in the dump is the only
>> thing th
21 matches
Mail list logo
