Hello
Does exist another way to make upgrade (without dump-restore)?
I have this question, because I have very big DB (or very poor server): dump
~40min, restore >2h
I can't stop my DB so long...
Thanks
В сообщении от Thursday 20 September 2007 19:58:24 Milen A. Radev написал(а):
> Josef S
When you see a hanging Postgres connection (or a job running so long and you
don't want to continue any more) from
select * from pg_stat_activity
and you want to disconnect it,
how do you do it?
thanks,
Jessica
-
Check out the hottest 2008 models tod
Use Slony to replicate to the new version from the old version.
Once they are sync-ed up, you switch the new version to be the
master and re-point your apps to the new DB.
Ken
On Mon, Oct 15, 2007 at 04:52:43PM +0400, Alexander Kuprijanov wrote:
> Hello
>
> Does exist another way to make upgrade
On 10/15/07, Jessica Richard <[EMAIL PROTECTED]> wrote:
> When you see a hanging Postgres connection (or a job running so long and you
> don't want to continue any more) from
>
> select * from pg_stat_activity
>
> and you want to disconnect it,
>
> how do you do it?
See pg_cancel_backend
You shou
Jessica Richard wrote:
When you see a hanging Postgres connection (or a job running so long
and you don't want to continue any more) from
select * from pg_stat_activity
and you want to disconnect it,
how do you do it?
|pg_cancel_backend()
|http://www.postgresql.org/docs/8.1/interactive/fu
Hi all,
I have some questions about postgreSQL, concerning Distributed DataBases.
I know Oracle can do this very Well. With Oracle, i can configure my dataBases
to use data stored in another DataSource (Microsoft SQL Server, Access,
Access, ...), using Oracle Transparent Gateway.
What i want t
So having upgraded to 8.1.10, I thought I'd try out a few things...
# /usr/pkg/bin/pg_dumpall
--
-- PostgreSQL database cluster dump
--
\connect postgres
--
-- Roles
--
CREATE ROLE postgres;
ALTER ROLE postgres WITH SUPERUSER INHERIT CREATEROLE CREATEDB LOGIN;
CREATE ROLE root;
ALTER ROLE roo
Darren Reed wrote:
Scott Marlowe wrote:
On 10/7/07, Darren Reed <[EMAIL PROTECTED]> wrote:
> Scott Marlowe wrote:
> > On 10/7/07, Darren Reed <[EMAIL PROTECTED]> wrote:
> > > Scott Marlowe wrote:
> A few days ago I did:
> pg_dumpall > foo
> What I was doing yesterday was:
> rm -rf /data/db/*
>
On 10/14/07, Martial Elisée Wendbé KIBA <[EMAIL PROTECTED]> wrote:
> I have some questions about postgreSQL, concerning Distributed DataBases.
> I know Oracle can do this very Well. With Oracle, i can configure my
> dataBases to use data stored in another DataSource (Microsoft SQL Server,
> Access,
Darren Reed <[EMAIL PROTECTED]> writes:
> # /usr/pkg/bin/psql -U postgres template1
> psql: FATAL: out of memory
> DETAIL: Failed on request of size 20.
I'm starting to think there is something very broken about your machine :-(.
Have you run any hardware diagnostics on it lately? The level of
Thanks a lot!
"select pg_cancel_backend(procpid) " can end the current query for that user,
but then this connection becomes IDLE, still connected.
Is there a command for me to totally disconnect a user by procpid? Some times,
I need to kick out a particular Postgres user completely.
thanks
On 10/15/07, Jessica Richard <[EMAIL PROTECTED]> wrote:
> Thanks a lot!
>
> "select pg_cancel_backend(procpid) " can end the current query for that
> user, but then this connection becomes IDLE, still connected.
>
> Is there a command for me to totally disconnect a user by procpid? Some
> times, I
On 10/15/07, Jessica Richard <[EMAIL PROTECTED]> wrote:
> Thanks a lot!
>
> "select pg_cancel_backend(procpid) " can end the current query for that
> user, but then this connection becomes IDLE, still connected.
>
> Is there a command for me to totally disconnect a user by procpid? Some
> times, I
>>> On Mon, Oct 15, 2007 at 12:34 PM, in message
<[EMAIL PROTECTED]>, "Jonah H.
Harris" <[EMAIL PROTECTED]> wrote:
>
> There used to be a pg_terminate_backend, but it was #ifdef'd out due
> to corruption concerns. Basically, all it did was:
>
> kill -TERM pid
>
> I'm not sure whether anyone ha
Tom Lane wrote:
Darren Reed <[EMAIL PROTECTED]> writes:
> # /usr/pkg/bin/psql -U postgres template1
> psql: FATAL: out of memory
> DETAIL: Failed on request of size 20.
I'm starting to think there is something very broken about your
machine :-(.
Have you run any hardware diagnostics on it la
On 10/15/07, Darren Reed <[EMAIL PROTECTED]> wrote:
> Tom Lane wrote:
> > Darren Reed <[EMAIL PROTECTED]> writes:
> > > # /usr/pkg/bin/psql -U postgres template1
> > > psql: FATAL: out of memory
> > > DETAIL: Failed on request of size 20.
> >
> > I'm starting to think there is something very brok
Tom Lane wrote:
Darren Reed <[EMAIL PROTECTED]> writes:
> # /usr/pkg/bin/psql -U postgres template1
> psql: FATAL: out of memory
> DETAIL: Failed on request of size 20.
I'm starting to think there is something very broken about your machine :-(.
Have you run any hardware diagnostics on it late
Darren Reed <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Anyway, the above error should have also produced a map of per-context
>> memory usage in the postmaster log (ie, postmaster stderr). If you
>> could show us that, it might be revealing.
> MessageContext: 267378688 total in 43 blocks; 1
Tom Lane wrote:
Darren Reed <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Anyway, the above error should have also produced a map of per-context
>> memory usage in the postmaster log (ie, postmaster stderr). If you
>> could show us that, it might be revealing.
> MessageContext: 267378688 tot
Darren Reed <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Indeed. And there shouldn't even be anything in MessageContext until
>> the first client command has been received. Maybe you have something
>> in ~/.psqlrc that you haven't told us about?
> That's easy - I don't even have one of these
Scott Marlowe wrote:
...
Again, I'm kinda shooting in the dark here as you reveal more and more
what you are doing a little at a time. A test case that can invoke
this failure would be most useful.
After seeing this today:
ERROR: duplicate key violates unique constraint "ers_pkey"
ERROR:
On 10/15/07, Darren Reed <[EMAIL PROTECTED]> wrote:
> Scott Marlowe wrote:
> > ...
> >
> > Again, I'm kinda shooting in the dark here as you reveal more and more
> > what you are doing a little at a time. A test case that can invoke
> > this failure would be most useful.
> >
> After seeing this to
Darren Reed <[EMAIL PROTECTED]> writes:
> I'm starting to wonder if it is a combination of:
> - the operating system (NetBSD 4.99.20)
Um ... what was your motivation for choosing that? According to
http://www.netbsd.org/releases/release-map.html
a .99 release number signifies "an alpha quality di
Scott Marlowe wrote:
On 10/15/07, Darren Reed <[EMAIL PROTECTED]> wrote:
> Scott Marlowe wrote:
> > ...
> >
> > Again, I'm kinda shooting in the dark here as you reveal more and more
> > what you are doing a little at a time. A test case that can invoke
> > this failure would be most useful.
> >
24 matches
Mail list logo
