I have successfully setup the driver on a win98 machine, but when
performing the same process on a win2000 machine, I get the following
error:
ODBC--call failed, Password authentication failed for user
'ADMINISTRATION' (#210)[Microsoft][ODBC Driver Manager] Connection not
open (#0)
I have tried r
I'm running 7.0.3 on a double pentium 733 RH 7 box with 512M ram.
We quickly ran up against the default 32 max. connection limit since it
is a backend DB for our web server. When trying to increase the buffers
and connections as advised in the docs, I got the error:
[postgres@atl01371 data]$ noh
-
key semid owner perms nsems status
-- Message Queues
key msqid owner perms used-bytes messages
bash-2.04$
Tom Lane wrote:
>
> DHSC Webmaster <[EMAIL PROTECTED]> writes:
> > [postgres@atl01371 data]$ nohup postmaster -D /usr/loc
-9 on anything. :)
Tom Lane wrote:
>
> DHSC Webmaster <[EMAIL PROTECTED]> writes:
> > It would appear that either my icps is not working or that everything is
> > alright.
>
> Try it as root. I think on Linux, ipcs won't show shm segments that you
> do not have read
Gracias, merci' & Thank You Tom!
After shutting down the entries were still there.
I rebooted and restarted and voila!, we're in business.
Tom Lane wrote:
>
> DHSC Webmaster <[EMAIL PROTECTED]> writes:
> > [root@atl01371 linux]# ipcs
>
> > -
Hello all,
We are running 7.0.3 on a RH 7.0 box w/twin 733 pentium CPUs, 512 meg.
ram and a 3 drive raid 5 scsi array. The machine is dedicated. Our main
table is about 700,000 rows with an associated table of about 15,000
rows.
-N 128 -B 256
logging to a file
Without spelling out our complete sc
is if some is good, more must be better. :)
Also I noticed in this artice:
http://www.ca.postgresql.org/docs/faq-english.html#3.7
mention of another memory parameter (-S), however the elephant book
refers to -S as silent mode.
Could you clarify this?
Tom Lane wrote:
>
> DHSC Webmaster <[E
We just moved our database to a different machine and upgraded from
7.0.3 to 7.1.3 in the process. We have been using the windows driver v.
6.50., Access 2000 and a combination of win flavors with good
success on Postgres 7.0 . However, now that we have upgraded, we can
connect to the database
You could use a perl script to read your data and do a pattern match for
consistency with your date output. Or you could import the data into a
temp table which has a text field instead of date. You could query
against your temp table to find offending data. Then use SQL to insert
the data into yo
Isabelle Brette wrote:
>
> Hello,
>
> On Thu, Jan 03, 2002 at 12:10:01PM -0500, Zhang, Anna wrote:
> > I have a problem to load data to postgres database using copy command. The
> > problem is that we have one column called address which is multi-line text,
> > the taxt file looks like this:
>
Jean,
We are using a quad pentium xeon machine with 6 GB ram RH 7.1 enterprise
kernel. Postgres uses everything that is available. Actually, its only
idling with the hardware we have and we have tables with over 2M rows.
Your disk subsystem is very important as well as it can easily become a
bottl
You sure can, Charlie.
We have our indexes, lightly used/smaller tables and heavily used/larger
tables split across several disks.
In a nutshell,
1. You just have to create the objects.
2. Then identify the objects using oid2name.
3. Shut down your database and move the objects.
4. Then put symlin
12 matches
Mail list logo
