X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AC20E8B9BD0 for ; Wed, 2 Feb 2005 20:43:41 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 42138-05 for ; Wed, 2 Feb 2005 20:43:29 +0000 (GMT) Received: from out014.verizon.net (out014pub.verizon.net [206.46.170.46]) by svr1.postgresql.org (Postfix) with ESMTP id 8372C8B9B48 for ; Wed, 2 Feb 2005 20:43:29 +0000 (GMT) Received: from jfradkin ([66.15.127.235]) by out014.verizon.net (InterMail vM.5.01.06.06 201-253-122-130-106-20030910) with ESMTP id <20050202204328.JXOE28388.out014.verizon.net@jfradkin> for ; Wed, 2 Feb 2005 14:43:28 -0600 From: "Joel Fradkin" To: Subject: Re: pg_restore problem Date: Wed, 2 Feb 2005 15:46:46 -0500 Message-ID: <000801c50968$525ecb00$797ba8c0@jfradkin> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0009_01C5093E.6988C300" In-Reply-To: <74EFBC01-7557-11D9-AC7D-000D932ED682@nuvio.com> X-Authentication-Info: Submitted using SMTP AUTH at out014.verizon.net from [66.15.127.235] at Wed, 2 Feb 2005 14:43:25 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.199 tagged_above=0 required=5 tests=AWL, HTML_60_70, HTML_MESSAGE, MSGID_DOLLARS X-Spam-Level: *** X-Archive-Number: 200502/47 X-Sequence-Number: 20158 This is a multi-part message in MIME format. ------=_NextPart_000_0009_01C5093E.6988C300 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I used pgadmin to save and mine would not restore saying something about = the encoding. I will have to be able to save and restore reliably as well. =20 Also I never heard anything further on the query running slow (I put up table defs and analyze with and without seq on). I am running into this on several of my views (I guess I am not too = bright, because I still don't get why it chooses seq scan on indexed tables). I can force it to use index and did see a little improvement, but the = MSSQL was 3 secs and Postgres was like 9. Seeing as how I got the one viw to return faster (it was very complex = view) on postgres, my guess is I still have stuff to do. I did try changing = the cost to a lower number in config and redid my analyze, but it was still trying to do a seq scan. =20 Joel Fradkin =20 Wazagua, Inc. 2520 Trailmate Dr Sarasota, Florida 34243 Tel. 941-753-7111 ext 305 =20 jfradkin@wazagua.com www.wazagua.com Powered by Wazagua Providing you with the latest Web-based technology & advanced tools. C 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc This email message is for the use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized = review, use, disclosure or distribution is prohibited. If you are not the = intended recipient, please contact the sender by reply email and delete and = destroy all copies of the original message, including attachments. =20 =20 -----Original Message----- From: pgsql-sql-owner@postgresql.org = [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Bradley Miller Sent: Wednesday, February 02, 2005 3:17 PM To: Postgres List Subject: [SQL] pg_restore problem =20 I'm attempting to restore a dump from one server to another (one is a = Mac and one is a Linux base, if that makes any difference). I keep running = into issues like this: pg_restore: [archiver (db)] could not execute query: ERROR: function public.random_page_link_id_gen() does not exist This is what I'm using to restore the files with: pg_restore -O -x -s -N -d nuvio mac_postgres_2_2_2005_13_24=20 Any suggestions on how to get around this problem? It's a huge pain so = far just to sync my two servers up. Bradley Miller NUVIO CORPORATION Phone: 816-444-4422 ext. 6757 Fax: 913-498-1810 http://www.nuvio.com bmiller@nuvio.com ------=_NextPart_000_0009_01C5093E.6988C300 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I used pgadmin to save and mine = would not restore saying something about the encoding.

I will have to be able to save and = restore reliably as well.

 

Also I never heard anything further = on the query running slow (I put up table defs and analyze with and without seq = on).

I am running into this on several = of my views (I guess I am not too bright, because I still don’t get why = it chooses seq scan on indexed tables).

I can force it to use index and did = see a little improvement, but the MSSQL was 3 secs and Postgres was like = 9.

Seeing as how I got the one viw to = return faster (it was very complex view) on postgres, my guess is I still have = stuff to do. I did try changing the cost to a lower number in config and redid = my analyze, but it was still trying to do a seq scan.

 

Joel Fradkin

 

Wazagua, Inc.
2520 Trailmate Dr
Sarasota, Florida 34243
Tel.  941-753-7111 ext 305

 

jfradkin@wazagua.com
www.wazagua.com
Powered by Wazagua
Providing you with the latest Web-based technology & advanced = tools.
© 2004. WAZAGUA, Inc. All rights reserved. WAZAGUA, Inc
 This email message is for the use of the intended recipient(s) and = may contain confidential and privileged information.  Any unauthorized = review, use, disclosure or distribution is prohibited.  If you are not the intended recipient, please contact the sender by reply email and delete = and destroy all copies of the original message, including = attachments.

 


 

-----Original = Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] = On Behalf Of Bradley Miller
Sent: Wednesday, February = 02, 2005 3:17 PM
To: Postgres List
Subject: [SQL] pg_restore = problem

 

I'm attempting to restore a dump from one = server to another (one is a Mac and one is a Linux base, if that makes any = difference). I keep running into issues like this:

pg_restore: [archiver (db)] could not execute query: ERROR: function = public.random_page_link_id_gen() does not exist

This is what I'm using to restore the files with:

pg_restore -O -x -s -N -d nuvio mac_postgres_2_2_2005_13_24

Any suggestions on how to get around this problem? It's a huge pain so = far just to sync my two servers up.

Bradley Miller
NUVIO = CORPORATION
Phone: 816-444-4422 ext. = 6757
Fax: 913-498-1810
http://www.nuvio.com
bmiller@nuvio.com

------=_NextPart_000_0009_01C5093E.6988C300--