I try to restore a backup, but I got the following error:
pg_restore: [custom archiver] could not read data block -- expected
4096, got 2353
I run
pg_ctl (PostgreSQL) 8.0.3
I've tried the same with different backups ( one day before or after ) ,
and I tried also with -i flag ( ignore version )
Hi Folks,
I have a small problem. We're currently using an old PostgreSQL 7.3.1
database. In near future we want to migrate to a new server and taking
the chance to upgrade postgres. Now I have a testsystem with postgres
8.0.1 where I tried to import a dump from our database. Everthing works
fine
> I had to kill a vacuum in the middle with -9. I shut down and
> restarted the postgres server several times after that but I am unable
> to connect to the db that I was initially running vacuum on
> I'm doing "psql dbname" and it hangs for a while. I'm still
> waiting. Any ideas?
"Kill -9" is di
Jason
I had to kill a vacuum in the middle with -9. I shut down and restarted the
postgres server several times after that but I am unable to connect to the
db that I was initially running vacuum on
I'm doing "psql dbname" and it hangs for a while. I'm still waiting. Any
ideas?
Thanks
On Fri, Jan 13, 2006 at 12:19:38PM -0500, Brian A. Seklecki wrote:
> In short, it's a deterrent to hackers and a convenience to admins. But we
Not just that. Unless something big has changed when I wasn't
looking, the jdbc driver can't use the .pgpass mechanism yet; but it
_can_ use SSL, except
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> You should also change your application... IIRC the intention
> is to eventually remove OIDs from user tables.
There is no such plan --- defaulting to WITHOUT OIDS is as far as we
intend to go.
regards, tom lane
---
On Fri, Jan 13, 2006 at 11:05:38AM +0100, Szabolcs BALLA wrote:
> Hi,
>
> I have already upgraded our server from 7.4 to 8.1.
> My problem is the next: some of our queries use OIDS but I restored the
> databases without OIDS.
> Is it possible to set the OIDS without dump and restore?
No; the
On Thu, Jan 12, 2006 at 11:21:19PM -0500, Jaime Casanova wrote:
> On 1/5/06, Szabolcs BALLA <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > How do I know vacuum is need or not? I mean, are there any query to know
> > status of statistics, tables, indexes, etc?
>
> at least, once every billion transacti
On Fri, 13 Jan 2006, Tom Lane wrote:
"Brian A. Seklecki" <[EMAIL PROTECTED]> writes:
If a "bad person" were to somehow obtain a copy of the source code with a
password embedded in the connect string (Steal it from a developer who
uses Windows, or maybe convince Apache to not interpret PHP befor
"Brian A. Seklecki" <[EMAIL PROTECTED]> writes:
> If a "bad person" were to somehow obtain a copy of the source code with a
> password embedded in the connect string (Steal it from a developer who
> uses Windows, or maybe convince Apache to not interpret PHP before sending
> to the client, somet
Kai Hessing <[EMAIL PROTECTED]> writes:
> I have a small problem. We're currently using an old PostgreSQL 7.3.1
> database. In near future we want to migrate to a new server and taking
> the chance to upgrade postgres. Now I have a testsystem with postgres
> 8.0.1 where I tried to import a dump fr
The current PKI implementation seems to support the encryption aspects of
SSL/TLS, but what about using Authorization/Authentication?
I.e., when you configure SSL on the server, you're not specifying a
trusted CA cert (or directory of trusted CA Certs).
The client can specify REQUIRE_SSL en
> Hi,
>
> Thanks for your response,
>
> Ur Q: Does it work when you use runas?
> YES, it works when i use runas to run postgres in Win 2000 & XP.
Ok.
> Below i am mentioning my requirements and the bug received
> more clearly
>
> 1.I am trying to use postgres in three versions of
> Wi
>I am able to start and stop database after logging as user postgres in NT.
It is clear that you can start and stop postgreSQL using the postgres user.
Therefore access to pg_ctl.exe is working as expected!
The fact that the problem only exists when you introduce a thrid party tool
to perform the
Hi,
I have already upgraded our server from 7.4 to 8.1.
My problem is the next: some of our queries use OIDS but I restored the databases without OIDS.
Is it possible to set the OIDS without dump and restore?
Thanks
Szabek
16 matches
Mail list logo
