Re: [GENERAL] Keyword OWNED not recognized in pg v. 8.1

2007-02-15 Thread Devrim GUNDUZ
Hi,

On Tue, 2007-02-13 at 08:57 +0100, dfx wrote:
> I tryied also with .rpm downloaded from postgres official site but I
> get a lot of unresolved dependencies.

You should not have gotten dependency errors if you did not miss to
install compat package.

> So I ask if it exist a document that explain step by step the process
> to upgrade v. 8.1 to v. 8.2 under Fedora Core 6, a document for
> novices, as I am. 

http://pgfoundry.org/docman/view.php/148/98/PostgreSQL-RPM-Installation-PGDG.pdf

Let us know if you have more questions.

-- 
Devrim GÜNDÜZ
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/




signature.asc
Description: This is a digitally signed message part


Re: [GENERAL] Keyword OWNED not recognized in pg v. 8.1

2007-02-13 Thread Peter Eisentraut
Raymond O'Donnell wrote:
> For what it's worth, I've always found it easier to compile from
> source than to try and grapple with packet managers, both under
> RedHat and Ubuntu, and I'm no Linux expert on Ubuntu in
> particular, apt-get seems to scatter files around the hard disk in
> all sorts of non-standard places.

FWIW, I'm pretty sure both Red Hat and Ubuntu, following the LSB and 
all, scatter their files in a decidedly standard way.  Of course you 
are not required to like that way, but then you will have similar 
issues with most Linux binary packages.  If you have particular and 
well-founded gripes with the package layout, a bug report would also 
work.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

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

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


Re: [GENERAL] Keyword OWNED not recognized in pg v. 8.1

2007-02-13 Thread Raymond O'Donnell

dfx wrote:


I tryied also with .rpm downloaded from postgres official site but I get a
lot of unresolved dependencies.

So I ask if it exist a document that explain step by step the process to
upgrade v. 8.1 to v. 8.2 under Fedora Core 6, a document for novices, as I
am.


For what it's worth, I've always found it easier to compile from source 
than to try and grapple with packet managers, both under RedHat and 
Ubuntu, and I'm no Linux expert on Ubuntu in particular, apt-get 
seems to scatter files around the hard disk in all sorts of non-standard 
places.


The installation instructions in the docs are very comprehensive and 
easy to follow, and as long as you make sure that you have all the 
requirements (readline and zlib in particular) you should have no problem.


Ray.

---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
---


---(end of broadcast)---
TIP 4: Have you searched our list archives?

  http://archives.postgresql.org/


[GENERAL] Keyword OWNED not recognized in pg v. 8.1

2007-02-13 Thread dfx
Thank you Tom,

I tryied in any way to upgrade to 8.2 but I get only v. 8.1.8 (with yum).

I tryied also with .rpm downloaded from postgres official site but I get a
lot of unresolved dependencies.

So I ask if it exist a document that explain step by step the process to
upgrade v. 8.1 to v. 8.2 under Fedora Core 6, a document for novices, as I
am.

Thank you again.

Domenico


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

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


Re: [GENERAL] Keyword OWNED not recognized in pg v. 8.1

2007-02-12 Thread Tom Lane
"dfx" <[EMAIL PROTECTED]> writes:
> How I can recreate (replicate) the same structure of a database originally
> made with pg v. 8.2 to a server v. 8.1?

pg_dump has never been intended to produce backward-compatible dump
scripts; in most versions it's easy to point to cases where it'd be
flat-out impossible to do so, because the new version has features
not present in the older.

If you really need to do the above then get out your text editor and
change the script ... but my advice would be to install 8.2 instead.

regards, tom lane

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly


[GENERAL] Keyword OWNED not recognized in pg v. 8.1

2007-02-12 Thread dfx
Dear Sirs,

I am trying to create a database in postgres v. 8.1 (Fedora core 6) using a
sql script created from pg version 8.2 (Windows) (using backup.text of
PgAdminIII) but I get an error with the keyword OWNED. (tables uses serial
type).

The fields with serial type are declared differently in the similar script:
as 'serial' in the version 8.1 and as 'integer' + association to sequence in
the version 8.2.

How I can recreate (replicate) the same structure of a database originally
made with pg v. 8.2 to a server v. 8.1?

Thank you in advance.

Domenico


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

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