Hi all
Can we do a point-in-time restore of a single database out of n databases??.
--
I have 5 databases in the postgresql server.
I have taken full-backup of
samana srikanth wrote:
Can we do a point-in-time restore of a single database out of n
databases??.
In principle no. But you could invent workarounds such as recovering to
the point where you are happy with your restored one database, and then
restore the other n-1 databases from an
The users are accessing the database using PhpPgAdmin. I thought that
this might happen if they closed the browser without closing logging
off. I know that if you do that the browser will return to where you
left it, when you open it again. I tried that with my own database,
and I
I'm using psql from the command line. Doing an ALTER DATABASE command.
Carol
On Mar 3, 2009, at 2:36 AM, Julius Tuskenis wrote:
Hello, Carol.
how exactly are you trying to change the DB name? In console or
using some management tool like pgAdmin?
Carol Walter rašė:
Periodically, my
Hello Ashish, Hello Tom,
thank you very much for your quick and helpful replies - I really appreciate
that.
May be this will help you:
Easier is just
select oid::regprocedure from pg_proc where whatever
I guess I'll go with the very nifty type cast suggested by Tom though as this
Jakov Sosic jakov.so...@srce.hr wrote:
How do you mean, do fewer updates?
Well, without knowing the application it's hard for me to say; but, as
a guess, perhaps the application could be modified to accumulate, say,
a minute's worth of data and update it in summary, rather than
updating each
That's interesting and is probably the answer to my question as to why
this happens. Thanks, Nick. What it doesn't explain is why I was
able to connect to a test database using PhpPgAdmin and close the
browser, without logging out, and I was able to rename my test
database. I couldn't
Testing pg_standby in 8.3.6. I've gotten this standby into some sort of
bind. It seems like it may be waiting for some WAL. How can I tell
what it is waiting on? I don't really know how this works, so I may
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes
On Wed, 2009-03-04 at 15:06 -0500, Ray Stell wrote:
Testing pg_standby in 8.3.6. I've gotten this standby into some sort of
bind. It seems like it may be waiting for some WAL. How can I tell
what it is waiting on? I don't really know how this works, so I may
Looks like you were cut off
On Wed, Mar 04, 2009 at 03:06:12PM -0500, Ray Stell wrote:
Testing pg_standby in 8.3.6. I've gotten this standby into some sort of
bind. It seems like it may be waiting for some WAL. How can I tell
what it is waiting on? I don't really know how this works, so I may
say something silly.
On Wed, 2009-03-04 at 15:59 +0200, Peter Eisentraut wrote:
samana srikanth wrote:
Can we do a point-in-time restore of a single database out of n
databases??.
In principle no. But you could invent workarounds such as recovering to
the point where you are happy with your
Hello Ashish, Hello Tom,
before I reinvent the wheel I'd like to know whether there's a shortcut
for getting the 'full' name (incl. argtypes) of the functions within a
database in order to REVOKE priviliges on them given to certain users.
I combined your suggestions into this query I'll be
On Wed, 2009-03-04 at 15:14 -0500, Ray Stell wrote:
On Wed, Mar 04, 2009 at 03:06:12PM -0500, Ray Stell wrote:
Testing pg_standby in 8.3.6. I've gotten this standby into some sort of
bind. It seems like it may be waiting for some WAL. How can I tell
what it is waiting on? I don't
On Wed, Mar 04, 2009 at 08:31:16PM +, Simon Riggs wrote:
You've set archive_timeout?
no, but new WAL files seem to be getting created and replicated to the standby,
just the pg_standby
command seems snagged on something. I probably have done something dumb,
ready, fire, aim. I'm
Simon Riggs si...@2ndquadrant.com writes:
On Wed, 2009-03-04 at 15:59 +0200, Peter Eisentraut wrote:
samana srikanth wrote:
Can we do a point-in-time restore of a single database out of n
databases??.
In principle no. But you could invent workarounds such as recovering to
the point where
jan-peter.seif...@gmx.de writes:
I combined your suggestions into this query I'll be using for now:
SELECT DISTINCT n.nspname || '.' || p.oid::regprocedure::text FROM
This is flat *wrong*, as you'll soon find if you are working with
functions in more than one schema. regprocedure already puts
On Wed, 2009-03-04 at 15:37 -0500, Tom Lane wrote:
Simon Riggs si...@2ndquadrant.com writes:
On Wed, 2009-03-04 at 15:59 +0200, Peter Eisentraut wrote:
samana srikanth wrote:
Can we do a point-in-time restore of a single database out of n
databases??.
In principle no. But you could
Hello
I want to see statistics about the use of my postgresql 8.3 in Ubuntu 8.04.1
(Hardy) Server. The package installed is
http://packages.ubuntu.com/hardy/postgresql
http://packages.ubuntu.com/hardy/postgresql
The statistic in this version of postgres are by default enabled, but I
didn't
For some reason it is looking for 0002001C.00512178.backup
file which is not the WAL file.
Are you sure that you made initial recovery properly?
Yauheni Labko (Eugene Lobko)
Junior System Administrator
Chapdelaine Co.
(212)208-9150
On Wednesday 04 March 2009 03:14:51 pm Ray
Simon Riggs si...@2ndquadrant.com writes:
On Wed, 2009-03-04 at 15:37 -0500, Tom Lane wrote:
It's not as easy as all that. What will you do with updates to shared
catalogs?
Apply them.
... which leaves your other databases in inconsistent states.
regards, tom lane
On Wed, Mar 04, 2009 at 03:41:06PM -0500, Yauheni Labko wrote:
For some reason it is looking for 0002001C.00512178.backup
file which is not the WAL file.
Are you sure that you made initial recovery properly?
I could have fouled this in any number of ways. Like I said
I'm
This has happened or is happening to me again, only this time, it's a
database that I just created. I restored another database into a test
database. One of the tables is empty. I want to drop the test
database and create a new one. When I try to drop the test database,
I get this
Have you got any copies of psql or tools like pgadmin open. I've been
caught out by this. try
select * from pg_stat_activity
it should tell you what connections are open on the table (look at the
datname column)
Carol Walter wrote:
This has happened or is happening to me again, only this
Carol Walter walt...@indiana.edu writes:
This has happened or is happening to me again, only this time, it's a
database that I just created. I restored another database into a test
database. One of the tables is empty. I want to drop the test
database and create a new one. When I try
On Wed, Mar 4, 2009 at 2:40 PM, Carol Walter walt...@indiana.edu wrote:
This has happened or is happening to me again, only this time, it's a
database that I just created. I restored another database into a test
database. One of the tables is empty. I want to drop the test database and
I had forgotten that I had used Aqua Data Studio to draw ERD's for
this test database. Even though, I closed it, it still had the
database open. When I reopened it, and did a disconnect, if allowed
me to drop the database.
Thanks,
Carol
On Mar 4, 2009, at 4:45 PM, John Lister wrote:
No. %f is the WAL filename which is needed by the server to start recovery.
0002001C.00512178.backup will give you start and end of WAL
segment, the WAL filename containing this segment and your label to identify
where it might be. That's why I asked you about your backup.
On Mar 4, 2009, at 4:53 PM, Scott Marlowe wrote:
On Wed, Mar 4, 2009 at 2:40 PM, Carol Walter walt...@indiana.edu
wrote:
This has happened or is happening to me again, only this time, it's a
database that I just created. I restored another database into a
test
database. One of the tables
On Wed, 2009-03-04 at 16:27 -0500, Tom Lane wrote:
Simon Riggs si...@2ndquadrant.com writes:
On Wed, 2009-03-04 at 15:37 -0500, Tom Lane wrote:
It's not as easy as all that. What will you do with updates to shared
catalogs?
Apply them.
... which leaves your other databases in
Simon Riggs si...@2ndquadrant.com writes:
On Wed, 2009-03-04 at 16:27 -0500, Tom Lane wrote:
Simon Riggs si...@2ndquadrant.com writes:
On Wed, 2009-03-04 at 15:37 -0500, Tom Lane wrote:
It's not as easy as all that. What will you do with updates to shared
catalogs?
Apply them.
...
Btw i think you may remove %r from the restore command.
Yauheni Labko (Eugene Lobko)
Junior System Administrator
Chapdelaine Co.
(212)208-9150
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Scott Marlowe scott.marl...@gmail.com writes:
On Wed, Mar 4, 2009 at 2:40 PM, Carol Walter walt...@indiana.edu wrote:
This database is one that I created just a few hours ago just to test some
things myself. There can be no one in it except me.
Correct me if I'm wrong, but isn't that enough
does a file named 000100CD exist anywhere on your disk?
-lee
On Fri, Feb 27, 2009 at 2:47 AM, Brad Wiemerslage wieme...@yahoo.com wrote:
I'm attempting to get warm standby up and running with a pair of servers
running ubuntu 8.04 and postgresql 8.3. Been following the docs:
jan-peter.seif...@gmx.de wrote:
Hello Ashish, Hello Tom,
thank you very much for your quick and helpful replies - I really appreciate
that.
May be this will help you:
Easier is just
select oid::regprocedure from pg_proc where whatever
I guess I'll go with the very nifty
34 matches
Mail list logo