Is there a way from postgresql to write a query that will query a remote
database through an odbc connection? You can do this on MS sql and other
databases. Again I want to go from my postgresql server to an odbc
connected remote database.
Use nmap. Unless you deliberately changed the IP port you should have no
problem. Are you the one who setup all the servers?
On Wed, Nov 17, 2010 at 4:03 PM, Frederiko Costa wrote:
> True. However, I was just assuming that Postgres was running on default
> ports. If not, you could also probe in
On Mon, Oct 6, 2008 at 10:08 AM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> On Mon, Oct 6, 2008 at 12:23 AM, Mohammed Rashid <[EMAIL PROTECTED]> wrote:
>> Hi All,
>>
>> I have use the Postgres database as a client/server architecture.
>> I mean I want to run the clients on different PCs and want th
-- Forwarded message --
From: Rich <[EMAIL PROTECTED]>
Date: Jan 10, 2008 1:32 PM
Subject: Re: [ADMIN] physical memory
To: Antonio Corardi <[EMAIL PROTECTED]>
There is probably no limit except the limitations of your hardware at
this time. As far as it a
Hi there..
First, I'm a begginer to PostgreSQL. please, Don't fool me too much. ;-)
As you see the title of this post, I'd like to know how to start
postresql db server as a administrator of MS-windows os. (I'm trying not to
run as a service.)Yes, I already know that according to th
it to any array
type, and the only reference to it in the searchable archives (Thanks,
pgsql.ru!) points one to contrib/intarray -- which doesn't mention
int2vector at all.
How can I deal with this type in plpgsql?
Thanks,
R
Tom Lane wrote:
Rich Cullingford <[EMAIL PROTECTED]> writes:
Hmmm, how do you use 7.4 utilities against a 7.3 DB?
pg_dump can dump from prior-release DBs (back to 7.0 at the moment).
Just point it at the older DB's port.
This is a bit tricky when installing from RPMs, since there&
Tom Lane wrote:
Rich Cullingford <[EMAIL PROTECTED]> writes:
I did a pg_dumpall in preparation for moving one of our databases from
PG7.3 to PG7.4, but I just realized I have another problem: that DB
(which has served us faithfully for some time) was created for superuser
'postgr
xample -- I need to
know that soonest.)
Thanks,
Rich Cullingford
System Detection, Inc.
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our lis
assuming I can
catch it).
Thanks for any help,
Rich Cullingford
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 8: explain analyze is your friend
n't), you'll never be able to drop it cleanly either.
> I'll submitt a corrected version of this for the next release.
Peter,
Thank you. I didn't think I was doing everything incorrectly.
It will be nice to see this working someday.
Rich
mar. Tomorrow I'll grab the other packages (the locale-free
ones) and install them in lieu of what's there now. Then I'll let you know
how the regression tests come out.
Ciao,
Rich
Dr. Richard B. Shepard, President
Applied Ecosystem Services, Inc. (TM)
e to me. PostgreSQL ought to go in /usr or /usr/local since it's an
application, not a part of the kernel or OS utilities or required tools.
Some folks (foolish thought they may be) might actually prefer another dbms
over PostgreSQL. They sould be able to not install pgsql and put in wha
and PGDATA2?
Especially so that the locations are available to other authorized database
creators and users?
TIA -- again,
Rich
Dr. Richard B. Shepard, President
Applied Ecosystem Services, Inc. (TM)
Making environmen
ee.
Well, the location exists (I can echo $PGDATA and see it correctly --
minus the base/ directory), so it must be that the backend hasn't the
permission to write to it.
What mode should PGDATA2/base or PGDATA have so I can create databases in
it?
Thanks,
Rich
Dr.
, but I always have difficulty designing the
organization of a new database. I want it to be very easy to use, and
organized in the most useful way.
Any thoughts or suggestions will be greatly appreciated.
Thanks,
Rich
Dr. Richard B. Shepard, President
Applie
eries. I use limit also.
I think writing a Distribution/Replication engine using Java servlets
should be a medium size task. Making it fault-tolerant and dealing with
crash and error recovery issues could make it larger. If I end up writing
it from scratch, I'll post the source for others to use.
e world to accomplish what a few huge mainframes
can't.
> >
> > So do your upgrade this weekend but then in two months, if you are
> > lucky, you will need to upgrade again. Maybe then think about a
> > non-PC that will have a three to five year life. A good rule of
> &
goes
out or something.
- Original Message -
From: Peter Galbavy <[EMAIL PROTECTED]>
To: Rich Ryan <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, October 28, 1999 1:31 AM
Subject: Re: [ADMIN] HSA (Highly Scalable Architecture) Distribution and
replication
>
t that in a year
Postgres should have an HSA solution. Is anyone working on this? Maybe we
could start?
Thanks,
Rich
y with that info. It
> was compiling and I didn't know it so hadn't looked for a make.log file.
> Am new to both Linux and Postgres.
Good! Glad you found the problem and fixed it.
>Perhaps the permissions problems Rich mentioned are related to the fact
> that RedHat i
with errors.
Making the directories exactly match what the Administrator's Guide,
Chapter 4 (Installation) shows did the trick for me. But, it's not the way
the tarball unrolls.
HTH,
Rich
Dr. Richard B. Shepard, President
Applied Ecosystem Services, Inc.
2404 SW 22nd Street
Troutdale, OR 970
to post a summary to
the list of private responses received.
Rich
Dr. Richard B. Shepard, President
Applied Ecosystem Services, Inc.
2404 SW 22nd Street
Troutdale, OR 97060-1247 U.S.A.
+ 1 503-667-4517 (voice) | + 1 503-667-8863 (fax)
[EMAIL PROTECTED]
23 matches
Mail list logo
