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 databases will give me a message that says that
someone is using the database when it appears that no one is. What
causes this? What c
Carol Walter writes:
> I'm not sure I understand. If there is a lag time between when
> someone exits the database and when the database "knows" that no one
> is still in it, then that shouldn't be the problem here. I tried a
> number of time over the course of 24 hours to rename the datab
Gerd König wrote:
Hi Venkat,
try this one as a good starting point:
http://www.postgresql.org/docs/8.1/static/backup-online.html
Or the more current version of the documentation:
http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html
Generally its best to use the docs th
I'm not sure I understand. If there is a lag time between when
someone exits the database and when the database "knows" that no one
is still in it, then that shouldn't be the problem here. I tried a
number of time over the course of 24 hours to rename the database and
it always reported t
Carol Walter writes:
> Well, most recently I had created a new database using UTF8 encoding
> and I had restored data to it, that had been in a database using
> SQL_ASCII. I wanted to rename the original database. When I tried to
> rename it, I got the message that I couldn't do it because
Well, most recently I had created a new database using UTF8 encoding
and I had restored data to it, that had been in a database using
SQL_ASCII. I wanted to rename the original database. When I tried to
rename it, I got the message that I couldn't do it because the
database was in use. T
ps -ef | grep postgres
> Date: Mon, 2 Mar 2009 22:35:23 +0200
> Subject: Re: [ADMIN] Database in use?
> From: lu...@fmf.vtu.lt
> To: pgsql-admin@postgresql.org
>
> Hi,
>
> try this:
> SELECT * FROM pg_stat_activity;
>
> Maybe it will show you who is using it..
>
>
> --
> Lukas
> UAB nSoft
Hi,
try this:
SELECT * FROM pg_stat_activity;
Maybe it will show you who is using it..
--
Lukas
UAB nSoft
http://www.nsoft.lt
Lukas at nsoft.lt
+370 655 10 655
> Periodically, my databases will give me a message that says that
> someone is using the database when it appears that no one is.
Carol Walter writes:
> Periodically, my databases will give me a message that says that
> someone is using the database when it appears that no one is. What
> causes this? What can I do about it?
What's the context exactly?
In some cases you can get this type of message because of the fact
Periodically, my databases will give me a message that says that
someone is using the database when it appears that no one is. What
causes this? What can I do about it?
Thanks,
Carol
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
ht
>>> How do I install postgres 8.2? I think I installed 8.2 with something
>>> like sudo apt-get install postgresql, but that will install 8.3 now, I
>>> think.
>>
>> Try: sudo apt-get install postgresql-8.2
>>
>> I'm not sure about Ubuntu. Probably 8.2 isn't included in Intrepid
>> anymore. (packa
Hi,
Bryan Keith wrote:
> It looks to me like postgresql-8.2 is still available in the hardy
> repositories:
Yeah, it certainly is in Hardy, but not in Intrepid, as the
packages.ubuntu.com website confirmed me now.
> Same error. Any suggestions?
Did you just forget an "apt-get update" in betwee
>> How do I install postgres 8.2? I think I installed 8.2 with something
>> like sudo apt-get install postgresql, but that will install 8.3 now, I
>> think.
>
> Try: sudo apt-get install postgresql-8.2
>
> I'm not sure about Ubuntu. Probably 8.2 isn't included in Intrepid
> anymore. (packages.ubun
Ashish Karalkar writes:
> Jan-Peter Seifert wrote:
>> Obviously you can't just use the specific_name from
>> information_schema.routine_privileges for this.
> May be this will help you:
Easier is just
select oid::regprocedure from pg_proc where
regards, tom lan
Jan-Peter Seifert wrote:
Hello,
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 don't see anything in the docs:
http://www.po
Hello,
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 don't see anything in the docs:
http://www.postgresql.org/docs/8.3/inter
Hi Venkat,
try this one as a good starting point:
http://www.postgresql.org/docs/8.1/static/backup-online.html
regards..GERD..
venkat ramana schrieb:
> Hi,
>
> I am planning to implement PITR in Postgres.
> Can someone please provide me the details of step by step information on
> implementin
Hi,
I am planning to implement PITR in Postgres.
Can someone please provide me the details of step by step information on
implementing backup and recovery using PITR mechanism.
Thanks
Venkat.
_
Ready for MARRIAGE? Join MSN
Hi,
Bryan Keith wrote:
> How can I install postgres 8.2 without messing up the data in
> /var/lib/postgresql/8.2/main?
The way Postgres packages for Debian (and Ubuntu) are built, that's no
problem. Just install postgresql-8.2 again. After the upgrade, you can
remove the package and the data dire
19 matches
Mail list logo
