Hello,
Sorry for bothering you, but I thought you might help me.
I'm installing Postgres8.3 under windows XP (having Cygwin to simulate unix
environment).
==When I install postgres without libxml2, everything works fine. I use:
./configure --prefix=/cygdrive/c/PostgresInstallation/pgsql --enabl
On 10/26/07, Naomi Walker <[EMAIL PROTECTED]> wrote:
> I'm trying to drop a database in a postgres 8.1.4 instance (x86 Solaris
> 10 OS), but someone is connected to
> the database. What is the best way to find out exactly who is connected?
select * from pg_stat_activity;
---
I am trying to drop a user but it complained with the following message:
ERROR: role "joe" cannot be dropped because some objects depend on it
DETAIL: 1 objects in database Jan_test
1 objects in database Jan
this user does not own any tables in those two databases. Is there any command
I can u
Hello frnds,
I have created a PL/JAVA class.
Step 1. create a Function in Postgres that returns a set of Complex
type
Step 2 . Create a Complex Type.
Step 3. Write the Class
Step 4. Deploy it in Postgres
Step 5. Call the Method
Step 6. Method calls and it founds the required method
On 10/30/07, karthik keyan <[EMAIL PROTECTED]> wrote:
> Hi admins
>
> I have a issue with my database .
>
> Its not starting up after /var got filled up
>
> After clearing some space still the database doesnt start up ..
>
> Pls find the log vacuumdb: vacuuming of database "insight_v1_0" failed:
>
On 10/31/07, Jessica Richard <[EMAIL PROTECTED]> wrote:
> I am trying to drop a user but it complained with the following message:
>
> ERROR: role "joe" cannot be dropped because some objects depend on it
> DETAIL: 1 objects in database Jan_test
> 1 objects in database Jan
>
> this user does not
Question,
I have an ancient database that is running Postgresql 7.2.1 on AIX. Is it
safe to directly upgrade the database to 8.1? If not, what steps do I need
to take?
I have been pushing for 3 years to upgrade this database, and with some
upcoming projects, I am going to do another push with m
>>> On Tue, Oct 30, 2007 at 11:28 PM, in message
<[EMAIL PROTECTED]>,
"Nandakumar Tantry" <[EMAIL PROTECTED]> wrote:
> I have attached my Installation problem in Image File and log file.
This (from the log file) looks odd:
> fixing permissions on existing directory C:/Program Files/PostgreSQ
On 10/31/07, Kevin Grittner <[EMAIL PROTECTED]> wrote:
> >>> On Tue, Oct 30, 2007 at 11:28 PM, in message
> <[EMAIL PROTECTED]>,
> "Nandakumar Tantry" <[EMAIL PROTECTED]> wrote:
>
> > I have attached my Installation problem in Image File and log file.
>
> This (from the log file) looks odd:
>
> > f
On 10/31/07, Chris Hoover <[EMAIL PROTECTED]> wrote:
> Question,
>
> I have an ancient database that is running Postgresql 7.2.1 on AIX. Is it
> safe to directly upgrade the database to 8.1? If not, what steps do I need
> to take?
It might be better to upgrade to 7.2.xx where xx is the latest
ve
Jessica Richard <[EMAIL PROTECTED]> writes:
> I am trying to drop a user but it complained with the following message:
> ERROR: role "joe" cannot be dropped because some objects depend on it
> DETAIL: 1 objects in database Jan_test
> 1 objects in database Jan
> this user does not own any tables
Jessica Richard wrote:
> I am trying to drop a user but it complained with the following message:
>
> ERROR: role "joe" cannot be dropped because some objects depend on it
> DETAIL: 1 objects in database Jan_test
> 1 objects in database Jan
>
> this user does not own any tables in those two dat
"Chris Hoover" <[EMAIL PROTECTED]> writes:
> I have an ancient database that is running Postgresql 7.2.1 on AIX. Is it
> safe to directly upgrade the database to 8.1? If not, what steps do I need
> to take?
That's a big jump. You'll want to set up a test installation and do
some compatibility t
Doesn't ownership also apply to views and stored procs...
On 11/1/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
>
> On 10/31/07, Jessica Richard <[EMAIL PROTECTED]> wrote:
> > I am trying to drop a user but it complained with the following message:
> >
> > ERROR: role "joe" cannot be dropped becau
On 10/30/07, Achilleas Mantzios <[EMAIL PROTECTED]> wrote:
> Στις Τρίτη 30 Οκτώβριος 2007 10:45, ο/η Patrick De Zlio έγραψε:
> > Hi,
> >
> > We are running PostgreSQL 8.2.4 with quite highly updated millions rows
> > tables.
> >
> > It comes sometimes to get some "idle in transaction" processes, wh
You can have a look through all the release notes from 7.2.1 to current to
see what will be fixed, including any data eating insects. Check this page
http://www.postgresql.org/docs/7.4/static/release.html
Obviously you'll need to test everything, but you should be able to install
the new versio
Hi All,
I would like to know if any one has used Linux heartbeat for Slony to
support Postgres databse. I am trying to implement myself and running
into few issues.
It would be nice to get in touch with somebody who has implemented slony
with linux HA.
Thanks!
dinesh
--
"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> On 10/30/07, Achilleas Mantzios <[EMAIL PROTECTED]> wrote:
>> Some connection pools issue a BEGIN on the connection just
>> after the previous user of the connection issues COMMIT and
>> then closes it (Jboss does it). So, in transaction is not
>> apri
--- On Wed, 10/31/07, yogesh <[EMAIL PROTECTED]> wrote:
> Step 6. Method calls and it founds the required method but then
> gives the Error that relation not Found ( Table) but the table exists
> in the Database
When you specify that table name, did you qualify it with its associated
sche
The permissions are proper and I have all the permissions required for
that directory.
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 31, 2007 11:23 PM
To: Kevin Grittner
Cc: pgsql-admin@postgresql.org; Nandakumar Tantry
Subject: Re: [ADMIN] init
20 matches
Mail list logo
