Campbell, Lance | 1 Oct 19:41 2007
Picon

What changed were made between minor releases?

Where do I go to find out what changes where made between minor releases? 

 

Example:

8.2.4 to 8.2.5

 

Thanks,

 

Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382

http://webservices.uiuc.edu

 

Milen A. Radev | 1 Oct 20:07 2007
Picon

Re: What changed were made between minor releases?

Campbell, Lance написа:
> Where do I go to find out what changes where made between minor
> releases?  
> 

http://www.postgresql.org/docs/current/static/release.html

> 
> Example:
> 
> 8.2.4 to 8.2.5
> 

http://www.postgresql.org/docs/current/static/release-8-2-5.html

--

-- 
Milen A. Radev

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Kevin Kempter | 1 Oct 18:22 2007

last access times?

Hi List;

Can I query the system catalogs in 8.1.4 and determine the last time a 
database or table was accessed?

Thanks in advance

/Kevin

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

TUC Solutions | 2 Oct 00:29 2007

Re: What changed were made between minor releases?

Hello,

Need help ...

How can I save multi language data such as Arabic / English in postgresql.

Regards

-----Original Message-----
From: pgsql-admin-owner <at> postgresql.org
[mailto:pgsql-admin-owner <at> postgresql.org] On Behalf Of Milen A. Radev
Sent: Monday, October 01, 2007 9:07 PM
To: pgsql-admin <at> postgresql.org
Subject: Re: [ADMIN] What changed were made between minor releases?

Campbell, Lance ??????:
> Where do I go to find out what changes where made between minor
> releases?  
> 

http://www.postgresql.org/docs/current/static/release.html

> 
> Example:
> 
> 8.2.4 to 8.2.5
> 

http://www.postgresql.org/docs/current/static/release-8-2-5.html

--

-- 
Milen A. Radev

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Rajakumar | 2 Oct 19:29 2007

Best Cofniguration

Hi,

I have debian server with 15GB mem

182 GB for data
72 GB for WAL
36 GB for backup

could you tell update me for a best configuration (postgresql.conf). I have
do use maximum resource for the database that only for database.

Regards
Rajakumar
SqlFusion Inc

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Jayakumar_Mukundaraju | 3 Oct 06:15 2007

Re: What changed were made between minor releases?

Hi,
 
On installation itself ... install UDF 8... It will recognise the multiple languages..
 
Thanks & Regards
Jayakumar M
 

From: pgsql-admin-owner <at> postgresql.org on behalf of TUC Solutions
Sent: Tue 10/2/2007 3:59 AM
To: 'Milen A. Radev'; pgsql-admin <at> postgresql.org
Subject: Re: [ADMIN] What changed were made between minor releases?

Hello,

Need help ...

How can I save multi language data such as Arabic / English in postgresql.

Regards

-----Original Message-----
From: pgsql-admin-owner <at> postgresql.org
[mailto:pgsql-admin-owner <at> postgresql.org] On Behalf Of Milen A. Radev
Sent: Monday, October 01, 2007 9:07 PM
To: pgsql-admin <at> postgresql.org
Subject: Re: [ADMIN] What changed were made between minor releases?

Campbell, Lance ??????:
> Where do I go to find out what changes where made between minor
> releases? 
>

http://www.postgresql.org/docs/current/static/release.html

>
> Example:
>
> 8.2.4 to 8.2.5
>

http://www.postgresql.org/docs/current/static/release-8-2-5.html


--
Milen A. Radev


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

DISCLAIMER:
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated..

Jayakumar_Mukundaraju | 3 Oct 06:17 2007

Re: Best Cofniguration

Hi,
 
There is no best configuration in the database... As, how the database get increased, as we decide the configurations spaces..
 
Thanks & Regards
Jayakumar M
 
 

From: pgsql-admin-owner <at> postgresql.org on behalf of Rajakumar
Sent: Tue 10/2/2007 10:59 PM
To: pgsql-admin <at> postgresql.org
Subject: [ADMIN] Best Cofniguration

Hi,

I have debian server with 15GB mem

182 GB for data
72 GB for WAL
36 GB for backup

could you tell update me for a best configuration (postgresql.conf). I have
do use maximum resource for the database that only for database.

Regards
Rajakumar
SqlFusion Inc

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

DISCLAIMER:
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated..

Khan, Mahmood Ahram | 3 Oct 09:01 2007
Picon

Database Migration

Hi,

 

 


  1. What are necessary steps we should follow for migration of a production database from Oracle 10g (10.2.0.1) to PostgreSQL 8.2.4?

  2. What are the most common issues we get and how to fix them in migration procedure?

  3. Any tools available for doing this migration activity. If yes, the URLs of the tools.

 

 

 

 

Thanks & Best Regards

 

M.AHRAM KHAN 

 

Kevin Kempter | 3 Oct 17:01 2007

Re: Database Migration

On Wednesday 03 October 2007 01:01:00 Khan, Mahmood Ahram wrote:
> Hi,
>
>
>
>
>
>
> 1.	What are necessary steps we should follow for migration of a
> production database from Oracle 10g (10.2.0.1) to PostgreSQL 8.2.4?
> 2.	What are the most common issues we get and how to fix them in
> migration procedure?
> 3.	Any tools available for doing this migration activity. If yes,
> the URLs of the tools.
>
>
>
>
>
>
>
>
>
> Thanks & Best Regards
>
>
>
> M.AHRAM KHAN

EnterpriseDB has a toolset to migrate data from Oracle into EnterpriseDB 
(which of course is PostgreSQL plus). I'm not sure if their tool migrates 
from Oracle into generic PostgreSQL as well - I had heard that this was in 
the works. It might be worth a look.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Yogesh Arora | 3 Oct 12:27 2007
Picon

Postgres Array Traversing

Hallo All Frnds,

           I have to add an array in my table. and to update the array in a Procedure called by the trigger.

        In my case Like the Elements of the array are {1,2,5}  now i have to update it to {1,2,5,7} . I.e., Keeping the previous record as such and appending the new elements.

Please reply at the urgent basis..............

 Thanks in Advance......

you can reply me also at yogesh.arora <at> daffodildb.com

--
Best Regards,
Yogesh Arora
Mobile: 09255123173
Web :  www.daffodildb.com


Gmane