Hi all,
Im trying to create a dbi_link between Oracle and postgresql. i installed
all the necessary perl packages
And I had run dbi_link.sql and it completed without any errors
This is sql that I use to connect
postg...@garuda:~$ less /home/postgres/dbi-link-2.0.0/examples/oracle/dola.sql
/*
*
Im not sure if this is the right place to ask about dbi_link. If not please
forward it there.
Im trying to create a dbi_link between Oracle and postgresql. i nistalled
all the necessary perl packages
And I had run dbi_link.sql and it completed without any errors
This is sql that I use to connect
Hi
Is it possible to disable FK constraints in Postgresql?
Thanks
Josh
Hi,
Is there any utility like (oracle's dblink etc) that can establish
connection between oracle and postgres database?
Thanks
Josh
On Thu, Jan 8, 2009 at 8:52 AM, A. Kretschmer <
andreas.kretsch...@schollglas.com> wrote:
> In response to Josh Harrison :
> > Hi,
> > A basic question about the COPY command syntax
> > This is the syntax in the postgres manual.
> >
> > COPY tablename
Hi,
A basic question about the COPY command syntax
This is the syntax in the postgres manual.
COPY *tablename* [ ( *column* [, ...] ) ]
FROM { '*filename*' | STDIN }
..
.
What is the difference between copying from 'filename' and copying
from 'stdin' ???
Thanks
Josh
Thanks all
On 12/7/08, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Josh Harrison" <[EMAIL PROTECTED]> writes:
>> How can I give the ALTER permission
>
> You can't grant ALTER permission --- that's only allowed to the table
> owner. However, you
Hi,
I had created some tables in the schema Foo and given
GRANT ALL ON SCHEMA FOO TO SCOT;
But when Scot tries to alter a table he gets the error
MUST BE OWNER OF THE TABLE
How can I give the ALTER permission or is there any other way to let other
users modify or add tables in this schema?
Thank
On Wed, Dec 3, 2008 at 11:51 AM, Scott Marlowe <[EMAIL PROTECTED]>wrote:
> On Wed, Dec 3, 2008 at 8:43 AM, Josh Harrison <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > 1. Is there a limit on the number of databases that can be in a single
> > postgres cluster
Hi,
1. Is there a limit on the number of databases that can be in a single
postgres cluster?
2. Is there any performance impacts associated with having too many
databases in a cluster?
3. Is there a good magical number for this limit ?
Thanks
Josh
Thanks Tom. This is wonderful
On Thu, Nov 20, 2008 at 4:21 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Josh Harrison" <[EMAIL PROTECTED]> writes:
> > My question is when I don't use the Recursive term does the optimizer
> just
> > consider it as
Hi,
I tried the 8.4-devel version and the CTE (Common Table Expression -WITH
RECURSIVE ) patch is working pretty good.
I just have a question
These are the queries & their plan .
The first query uses RECURSIVE keyword (and has a recursive and
non-recursive term as CTE) while the second query uses
On Wed, Nov 19, 2008 at 1:08 PM, Joshua D. Drake <[EMAIL PROTECTED]>wrote:
> On Wed, 2008-11-19 at 17:19 +0200, Devrim GÜNDÜZ wrote:
> > On Wed, 2008-11-19 at 08:35 -0500, Josh Harrison wrote:
> > > If so can you direct me to "the" website?
>
> Just a ti
Thanks GJ for the 'he' information. It was just a typo.
If so can you direct me to "the" website?
-Josh
On Wed, Nov 19, 2008 at 8:33 AM, Grzegorz Jaśkiewicz <[EMAIL PROTECTED]>wrote:
> "he" is still in the making, so there's no 8.4 release as such yet.
> "You" have to wait, for "he" will come. ;)
Hi
Is version 8.4 available for download now ? If so can you direct me to he
website?
Thanks
Josh
Hi,
Is Heikki's Visibility Map patch included for the Postgresql 8.4 version
http://archives.postgresql.org/pgsql-hackers/2007-11/msg00142.php
If not whats the status of that patch? Im especially interested in the
index-only scan mentioned there!!!
Thanks
On Jan 18, 2008 4:14 AM, Dorren <[EMAIL PROTECTED]> wrote:
> Terabytes of data: this is a lot of Oracle data to migrate. You would
> need a high performance tools capable to handle heterogeneous
> environment
> People suggested links here, so I will add some that could be very
> appropriate to you
On Jan 18, 2008 7:45 AM, Gregory Williamson <
[EMAIL PROTECTED]> wrote:
> Mayuresh Nirhali wrote:
> >
> > Josh Harrison wrote:
> > >
> > >
> > > Thanks .
> > > We have around 3TB of data now running in Oracle. I have done
> > > re
On Jan 16, 2008 1:31 PM, Dawid Kuroczko <[EMAIL PROTECTED]> wrote:
> On Jan 11, 2008 7:14 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> >
> > On Jan 11, 2008 12:02 PM, Josh Harrison <[EMAIL PROTECTED]> wrote:
> > > Hi
> > > We have an Oracle
On Jan 16, 2008 1:43 PM, Josh Harrison <[EMAIL PROTECTED]> wrote:
>
>
> On Jan 16, 2008 10:11 AM, Josh Harrison <[EMAIL PROTECTED]> wrote:
>
> >
> >
> > On Jan 15, 2008 3:58 PM, David Fetter <[EMAIL PROTECTED]> wrote:
> >
> > >
On Jan 16, 2008 10:11 AM, Josh Harrison <[EMAIL PROTECTED]> wrote:
>
>
> On Jan 15, 2008 3:58 PM, David Fetter <[EMAIL PROTECTED]> wrote:
>
> > On Mon, Jan 14, 2008 at 11:42:50AM -0500, Josh Harrison wrote:
> > > Thanks
> > >
> > > On Jan
On Jan 15, 2008 3:58 PM, David Fetter <[EMAIL PROTECTED]> wrote:
> On Mon, Jan 14, 2008 at 11:42:50AM -0500, Josh Harrison wrote:
> > Thanks
> >
> > On Jan 12, 2008 9:19 AM, David Fetter <[EMAIL PROTECTED]> wrote:
> >
> > > On Fri, Jan 11, 2008 at 0
>
>
> > > >> We have an Oracle production database with some terbytes of data.
> > > >> We wanted
> > > >> to migrate that to Postgresql (rigt now...a test database and not
> > > >> production) database.
> > > >> What are the good options to do that?
> > > >> Please advise me on where to look for m
Thanks
On Jan 12, 2008 9:19 AM, David Fetter <[EMAIL PROTECTED]> wrote:
> On Fri, Jan 11, 2008 at 01:02:01PM -0500, Josh Harrison wrote:
> > Hi
> > We have an Oracle production database with some terbytes of data. We
> > wanted to migrate that to Postgresql (rig
On Jan 11, 2008 1:22 PM, Erik Jones <[EMAIL PROTECTED]> wrote:
>
> On Jan 11, 2008, at 12:14 PM, Scott Marlowe wrote:
>
> > On Jan 11, 2008 12:02 PM, Josh Harrison <[EMAIL PROTECTED]> wrote:
> >> Hi
> >> We have an Oracle production database with
Hi
We have an Oracle production database with some terbytes of data. We wanted
to migrate that to Postgresql (rigt now...a test database and not
production) database.
What are the good options to do that?
Please advise me on where to look for more information on this topic
thanks
josh
On Jan 9, 2008 12:11 PM, Andrew Sullivan <[EMAIL PROTECTED]> wrote:
> On Wed, Jan 09, 2008 at 11:51:16AM -0500, Josh Harrison wrote:
>
> > accessed frequently. So clustering the table according to one index will
> > yield poor performance to queries involving other ind
On Jan 9, 2008 11:56 AM, Andreas Kretschmer <[EMAIL PROTECTED]>
wrote:
> Josh Harrison <[EMAIL PROTECTED]> schrieb:
> > My questions
> > 1. I pg_dumped dummy and Shuffled_dummy (from database1) to another
> database
> > (database2)
> > When I issued
On Jan 9, 2008 11:39 AM, Andrew Sullivan <[EMAIL PROTECTED]> wrote:
> On Wed, Jan 09, 2008 at 05:28:15PM +0100, Ivan Sergio Borgonovo wrote:
> > Does it make any sense *knowing* how the implementation works to load
> > records in a table in a specific order to improve performances?
>
> Well, this
On Jan 9, 2008 11:28 AM, Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote:
> On Wed, 09 Jan 2008 10:54:21 -0500
> Tom Lane <[EMAIL PROTECTED]> wrote:
>
> > Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > > Josh Harrison escribió:
> > >> Fine. I
On Jan 9, 2008 10:27 AM, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> Josh Harrison escribió:
>
> > Another quick question...When you issue a query like this
> > select * from dummy limit 10
> > What 10 rows are fetched? like first 10 or last 10 or the firs
On Jan 9, 2008 9:59 AM, A. Kretschmer <[EMAIL PROTECTED]>
wrote:
> am Wed, dem 09.01.2008, um 9:45:11 -0500 mailte Josh Harrison folgendes:
> > What if I want to maintain the same order as in the database1? ie., I
> want my
> > rows of TableABC in Database2 to be the s
On Jan 9, 2008 9:35 AM, A. Kretschmer <[EMAIL PROTECTED]>
wrote:
> am Wed, dem 09.01.2008, um 14:07:13 + mailte Raymond O'Donnell
> folgendes:
> > On 09/01/2008 14:02, Josh Harrison wrote:
> >
> > >When restoring the pg_dumped data thro psql does the
On Jan 9, 2008 9:12 AM, A. Kretschmer <[EMAIL PROTECTED]>
wrote:
> am Wed, dem 09.01.2008, um 9:02:23 -0500 mailte Josh Harrison folgendes:
> > Hi,
> > When restoring the pg_dumped data thro psql does the rows of the table
> are
> > restored in the same order? ie
Hi,
When restoring the pg_dumped data thro psql does the rows of the table are
restored in the same order? ie for example if
Table A has rows r1,r2,r3,r4,r5 in this order, then if I pg_dump and restore
it to another database, will it have the rows in the same order
r1,r2,r3,r4,r5? Does this apply t
Hi,
I have postgresql version 8.3beta3 running. I want to apply a patch (
gzn7ImULlK3v.gz patch for index-only scan) to this and try it out. How to
apply this patch. Where should the patch be placed and what command to be
run. Should I have to stop the postgres server or run initdb for the patch
to
ation going.
>
> We have to use slony, like you we need a replica to take the load off
> of our main system, this is mainly for our reporting processes.
>
> Glyn
>
>
> --- Josh Harrison <[EMAIL PROTECTED]> wrote:
>
> > Hi,
> > We are trying to use slony an
On Dec 27, 2007 12:37 PM, Andrew Sullivan <[EMAIL PROTECTED]> wrote:
> On Thu, Dec 27, 2007 at 10:49:10AM -0500, Josh Harrison wrote:
> > Hi,
> > We are trying to use slony and WAL shipping for warm standby for
> replication
>
> It's unusual to use both. Any
Hi,
We are trying to use slony and WAL shipping for warm standby for replication
with postgresql. Currently our systems are in oracle and we r checking the
feasibility to migrate to postgres. Replication is one major issue here.
Though everything seems to be working fine in our test environment, we
Hi
I have a question about postgres long text column values.
How does it handles these long text column values? Does it put all the long
text columns values from all the tables in one single place or separately?
Thanks
josh
Hi,
This is a newbie pgpool question. I have 2 servers (master-slave) and Slony
is doing the replication. I had installed pgpool for load balance where i
had disabled the replication_mode=false and load_balance_mode=true in
pgpool.conf
pcp_node_info gives this output.
-sh-3.00$pcp_node_info 10 l
Thanks...It works...
josh
On Dec 18, 2007 3:06 PM, Richard Huxton <[EMAIL PROTECTED]> wrote:
> Josh Harrison wrote:
> > Hi
> > I have a postgres version 7.4 and version 8.3 installed in my system.
> > 7.4 uses port 5432 and 8.3 uses port 5433.
> > I started 7.4
Hi
I have a postgres version 7.4 and version 8.3 installed in my system.
7.4 uses port 5432 and 8.3 uses port 5433.
I started 7.4 and the database is running fine. Now i started the database
server in version 8.3
and it started fine.
pg_ctl -D /export/home/josh/postgres8.3/pgsql/data start -l log
On Dec 17, 2007 3:14 PM, Shane Ambler <[EMAIL PROTECTED]> wrote:
> Not sure I can help much, I only read out of interest, but thought
> clarifying a few things may help.
>
> SHARMILA JOTHIRAJAH wrote:
> > Hi I had posted this in the slony mailing list but no luck in getting
> > any answers...Pls h
-thread-safety on solaris2.10
Can you help
Thanks
josh
On Dec 10, 2007 8:19 PM, Geoffrey <[EMAIL PROTECTED]> wrote:
> Scott Marlowe wrote:
> > On Dec 10, 2007 2:19 PM, Chris Browne <[EMAIL PROTECTED]> wrote:
> >> [EMAIL PROTECTED] ("Josh Harrison") writes:
Thanks...Ill check that list
josh
On Dec 10, 2007 12:37 PM, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Mon, 10 Dec 2007 12:20:07 -0500
> "Josh Harrison" <[EMAIL PROTECTED]> wrote:
>
> > Hi,
Hi,
Does slony support postgres major version upgrade ? ie., will it replicate
between different major versions?
Thanks
josh
>
>
>
> On 12/7/07, Josh Harrison < [EMAIL PROTECTED]> wrote:
> > > I have 2 servers on which I need to have data replicated. The master
> > server
> > > should serve for read/write queries and the 2nd server is used mainly
> > for
> > > r
On 12/7/07, Josh Harrison <[EMAIL PROTECTED]> wrote:
> > I have 2 servers on which I need to have data replicated. The master
> server
> > should serve for read/write queries and the 2nd server is used mainly
> for
> > research queries(read-only queries) and so it d
Hi list,
I'm a newbie for postgresql replication
This is my requirement.
I have 2 servers on which I need to have data replicated. The master server
should serve for read/write queries and the 2nd server is used mainly for
research queries(read-only queries) and so it doesn't have to be up-to-dat
initdb -E en_CA.utf-8 -D /export/home/sjothirajah/postgres8.3/pgsql/data
gives this error
initdb: "en_CA.utf-8" is not a valid server encoding name
Thanks
josh
On Dec 3, 2007 1:01 PM, brian <[EMAIL PROTECTED]> wrote:
> Josh Harrison wrote:
> > Hi
> > Im tying
Hi
Im tying to initialize the cluster using initdb and encoding 'UTF8'
initdb -E UTF8 -D /export/home/josh/postgres8.3/pgsql/data
But I get this error
The files belonging to this database system will be owned by user "josh".
This user must also own the server process.
The database cluster will be
accordance with those
> provisions. Any unauthorized review, use, disclosure or distribution is
> prohibited. If you are not the intended recipient, please contact the sender
> by reply e-mail and destroy all copies of the original message.
>
> (My corporate masters made me say this.
Hi,
What is the best way to uninstall postgres?
I'm planning to use postgres 8.3 beta and I would like to uninstall my
earlier version 8.2.3. This is only a test database and so I'm not
interested in upgrading or preserving anything from this version.
Thanks
josh
>
>
> Or using an IN or EXISTS query:
>
> SELECT person_id
> FROM person
> WHERE column1=1
> AND column2='62'
> AND person_id IN (
> SELECT person_id
> FROM person
> WHERE column1=1
>AND column2='189'
> )
>
> or
>
> SELECT person_id
> FROM person
>
>
> > > > *Query1*
> > > > SELECT person_id FROM person WHERE (column1=1 AND column2='62')
> > > > INTERSECT
> > > > SELECT person_id FROM person WHERE (column1=1 AND column2='189')
>
> > I get the same plan(see below) with 'sort' for 'intersect all'
> operation
> > too. Why is intersect n
On Nov 30, 2007 7:55 AM, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> Josh Harrison escribió:
>
> > Thanks...
> > I have 1 more question in the same line...
> >
> > *Query1*
> > SELECT person_id FROM person WHERE (column1=1 AND column2='62&#x
On Nov 29, 2007 8:15 AM, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> Josh Harrison escribió:
> > >
> > > > For example if I have a table Person with 3 fields
> (name,city_id,age).
> > > And
> > > > the table contains 1000 rows. The table has
>
> > For example if I have a table Person with 3 fields (name,city_id,age).
> And
> > the table contains 1000 rows. The table has 2 indexes city_id and age
> > If I have a query :
> > SELECT * FROM PERSON WHERE city_id=5 AND AGE=30
>
> The answer is "it depends". Postgres has a cost based planner,
>Some indexes are inexact, i.e. they may sometimes return tuples that
>don't actually match the index condition.
What causes an index to be inexact. When you create an index and vacuum it
regularly, it is suppose to be correctright??
>This also happens with bitmap
>scans, because it'll return
Hi,
Sorry if my question is silly.
When I use explain analyze command I come across 'recheck condition' in some
places.
I googled for this but didn't get any solid answers.
What is recheck condition and when does the query planner choose this?
Thanks
josh
On Nov 20, 2007 11:13 AM, Brad Nicholson <[EMAIL PROTECTED]> wrote:
> On Tue, 2007-11-20 at 07:22 -0500, Josh Harrison wrote:
>
> > There were a couple of things we noted.
> > 1. Tablesize twice as much than oracle-- Im not sure if postgres null
> > columns has any o
On Nov 20, 2007 8:10 AM, Filip Rembiałkowski <[EMAIL PROTECTED]> wrote:
> 2007/11/20, Josh Harrison <[EMAIL PROTECTED]>:
> > We are working on migrating our database from oracle to postgres.
> > Postgres tablesize is twice than oracle tablesize for all my
>
(when we
examined the iostat and vmstat) (we had set postgres' db block size as
8 and oracle's is 16kb...)
Do you have any comments on this?
Thanks in advance
josh
On Nov 20, 2007 12:37 AM, Trevor Talbot <[EMAIL PROTECTED]> wrote:
> On 11/19/07, Josh Harrison <[EMAIL PROT
mailing list even after 30 minutes. So i
tried again and then both showed up...kind of strange though!
Thanks again
Josh
On Nov 19, 2007 1:37 PM, Filip Rembiałkowski <[EMAIL PROTECTED]> wrote:
> 2007/11/19, Josh Harrison <[EMAIL PROTECTED]>:
> > Hi,
> > I have a few ques
Hi,
I have a few questions about the storage and performance
1. How do you estimate the table size in postgresql?
For example if I have a table 'Dummy' with 1 varchar (40) & 1
numeric(22,0) fields and 1000 rows, what is the tablesize estimate for
this (including the row overhead etc)? How many pa
Hi,
I have a few questions about the storage and performance
1. How do you estimate the table size in postgresql?
For example if I have a table 'Dummy' with 1 varchar (3) & 1
numeric(8,0) fields and 1000 rows, what is the tablesize estimate for
this (including the row overhead etc)? How many pages
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
Hi,
I have a few questions about the storage and performance
1. How do you estimate the table size in postgresql?
For example if I have a table 'Dummy' with 1 varchar (40) & 1
numeric(22,0) fields and 1000 rows, what is the tablesize estimate for
this (including the row overhead etc)? How many pag
Hello,
I have a question in the postgres document chapter 34. Rules and Command
Status.
The last paragraph of that page says that
"The programmer can ensure that any desired INSTEAD rule is the one that
sets the command status in the second case, by giving it the alphabetically
last rule name amon
Hi,
Where in the source code can I see the error message that says foreign key
to a view is not allowed
The exact error message as it appears when I try foreign key reference on a
view is
referenced relation "xyz_view" is not a table
I just wanted to know where is this error message thrown
ED]> wrote:
>
> On Sep 17, 2007, at 11:57 AM, Josh Harrison wrote:
> >
> > On 9/17/07, Tom Lane <[EMAIL PROTECTED]> wrote: "Josh Harrison"
> > <[EMAIL PROTECTED]> writes:
> > > When i try to give this query
> >
> > > UPDATE paym
the pg_class catalog file instead of using 'drop table' sql
command. Do you think this created the problem?
Thanks
josh
On 9/17/07, Tom Lane <[EMAIL PROTECTED]> wrote:
>
> "Josh Harrison" <[EMAIL PROTECTED]> writes:
> > When i try to give this que
On 9/17/07, Erik Jones <[EMAIL PROTECTED]> wrote:
>
>
> On Sep 17, 2007, at 9:02 AM, Josh Harrison wrote:
> >
> > On 9/17/07, Tom Lane <[EMAIL PROTECTED]> wrote: "Josh Harrison"
> > <[EMAIL PROTECTED]> writes:
> > > if I give this q
Thanks Tom.
I tried it using pg_class.oid and I still have some records which r not in
the pg_class files. What can I do about that?
(BTW what does relfilenode in pg_class stands for?)
Thanks again
Josh
On 9/17/07, Tom Lane <[EMAIL PROTECTED]> wrote:
>
> "Josh Harrison" <
Hi,
I noticed that I have too many records in my pg_ catalog files with the same
name. For example
if I give this query, which checks for the triggers that do not have
corresponding tables in the pg_class
select * from pg_trigger where tgrelid not in (select relfilenode from
pg_class),
I get set
/12/07, Tom Lane <[EMAIL PROTECTED]> wrote:
>
> "Josh Harrison" <[EMAIL PROTECTED]> writes:
> > Now I create this function to redirect the inserts and updates on the
> > master table.
>
> Uh ... there never will be any updates in the master table, sin
Hi
I have the master-child tables as follows
Master table
create table foo(a numeric(10,0));
first child table foo1 as
create table foo1 (check(a>=0 and a<10)) inherits(foo)
second child table foo2 as
create table foo1 (check(a>=10) inherits(foo)
Now I create this function to redirect the inser
78 matches
Mail list logo
