Hi,
I'm trying to develop a C application using ODBC on PostgreSQL 7.3.1.
I link my application with the lib : libodbcpsql.so.2.0.0. But the ODBC
function SQLGetDiagRec() used to get the error message does not exist in
this lib.
Does anyone, can tell me how to get back the postgres error message
Title: RE: [ADMIN] Can I make Postgresql to bind to 127.0.0.1:5432, instead of all the available interfaces
Thank you Tom. That worked.
I appreciate your help and the quick response.
- Uday
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 1
Raj Mathur <[EMAIL PROTECTED]> writes:
> ... However, the complementary process, determining
> all the users in group administrators, isn't so clean.
Doesn't
select grolist from pg_group where groname = 'administrators'
do it for you? I suppose you might want the thing to map sysids
back
Hi,
Using PostgreSQL 7.2.3 on a Linux box and facing some minor issues
with determining which groups users belong to.
I have created a PgSQL group called `administrators'. Now when I need
to check whether user X is a member of that group, I use the
contrib/array_iterator operator to do something
Uday Singh <[EMAIL PROTECTED]> writes:
> I am trying to figure out if I can get Postgres to bind to only the
> loop-back interface (127.0.0.1) as apposed to binding to all the available
> interfaces (0.0.0.0) available on the system.
I think you can do that with the virtual_host config parameter.
Hi guys,
I am trying to figure out if I can
get Postgres to bind to only the loop-back interface (127.0.0.1) as apposed to
binding to all the available interfaces (0.0.0.0) available on the system.
1. The first question is whether
this is feasible at all?
2. If yes, what is the confi
Laura Conrad <[EMAIL PROTECTED]> writes:
> pg_dumpall -p 8050 >/tmp/db.sql
> I then tried to restore (again as the postgres user), as documented in
> the pg_dumpall man page:
> psql -f /tmp/db.sql template1
> It does a few things, and then says:
> psql:/tmp/db.sql:16: \conne
You will not be able to get that many connections on a cygwin version of
PostgreSQL. I think cygwin's limit is something like 64.
P G wrote:
I need to increase the default max connection setting
from 32 to over 500. What other parameters should I
consider when adjusting this setting?
TIA.
_
(I previously posted this to the pgadmin-support list, no response,
hoping someone here could give me some guidance.)
Searching through the pgadmin-support archives, I didn't see this
error... Perhaps someone could assist me.
I am using version 1.4.12 of pgAdmin II for Windows on a Windows 2000
P
I have a database that was built under a Mandrake 7.2 postgres
installation. I am now running Debian (woody) on that machine, with
postgresql 7.2.1.
I still have the data directory from the old installation, so I
started a postmaster on a non-standard port, with a -D pointing to
that directory
I need to increase the default max connection setting
from 32 to over 500. What other parameters should I
consider when adjusting this setting?
TIA.
__
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
---
Hi,
I am trying to get postgres 7.3.2 to work with pam under Solaris 2.7.
The only option I gave to ./configure (apart from --prefix) was
--with-pam.
This is the matching line from my pg_hba.conf file:
host all all xxx.xx.xx.xx 255.255.255.255 pam other
and here are the relevant lines from /et
Sure, next time it happens. I'm back up again.
On Thu, 13 Feb 2003, Tom Lane wrote:
> Laurette Cisneros <[EMAIL PROTECTED]> writes:
> > Ok, it reproduced today on my development server.
>
> Boy, it sure looks like everything's just sitting idle waiting for
> client input, and hasn't noticed you
Laurette Cisneros <[EMAIL PROTECTED]> writes:
> Ok, it reproduced today on my development server.
Boy, it sure looks like everything's just sitting idle waiting for
client input, and hasn't noticed your shutdown request at all. You
sure you used "-m fast"? Could you attach to the postmaster and
Ok, it reproduced today on my development server.
Here's the info:
/usr/local/pgsql/bin/pg_ctl -D /u1/pgsql73_data -m fast -l
/u1/pgsql73_data/pgsql.log stop
waiting for postmaster to shut
down failed
pg_ctl: postmaster does not
Using 7.3.2 now.
I noticed a slew of messages in my pgsql log like this:
WARNING: COMMIT: no transaction in progress
I'm wodering if this is related to the fact that there is now an option in
the postgresql.conf file:
autocommit=true
Did 7.3.2 change the default behavior of the pgsql server in
Using 7.3.2
What does this mean?
Is this anything to worry about?
This type of message is occuring very regularly in the pgsql log file:
2003-01-31 12:04:52 [16181] WARNING: Closing pre-existing portal "PgSQL_008D8738"
2003-01-31 12:04:52 [16181] WARNING: PerformPortalClose: portal "pgsql_00
I'm doing some migration script from mysql database to an existing
postgresql database. Everytime I want to test it, I want to get the postgres
"destination" database to the same situation it was before the last script
was run.
I am doing a backup with pgdump and restoring by droping the databas
Hello!
I have a db cluster which contains databases with LATIN2 encoding and
some databases with UNICODE encoding. If I initalise the cluster with
--locale=sl_SI option, then special characters in LATIN2 databases are
sorted correctly, but special chars in UNICODE dbs end up in wrong
places; a
yes, i am thinking about installing and configuring postgresql in a contest
of shared db-server. I think postgresql has more funcionalities than mysql
( trigger, sql92, ...) but ...
mysql seems to be more configurable for shared db server and is implementing
more and more funcionalities (most beta
Is there a default timeout setting for connections to
the database?
TIA.
__
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
---(end of broadcast)---
TIP 4:
I need to increase the default max connection setting
from 32 to over 500. What other parameters should I
consider when adjusting this setting?
TIA.
__
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
-
I'm having a hard time thinking of how to do this on a windows box, you
might want to ask on the -cgwyn list. I would think what you need to do
is shutdown the db, install the second hard drive. initdb on the second
hard drive, copy your data files up, then fire back up the database.
Moving the log
> I think the big question is where there is any value in limiting the
> number of connections "per user". I haven't seen anyone ask for that
> before, so I haven't seen much demand for it.
This is important in a hosting environment where you have a shared
db-server. Then you can limit the connec
How do I find the date when a table was created or last modified?
hal
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
pg_password is gone. Few were using it, and now we encrypt the
passwords stored in pg_shadow. Were you sharing your /etc/password file
with PostgreSQL, or did you have another reason for using pg_password?
---
TooManySecre
I think the big question is where there is any value in limiting the
number of connections "per user". I haven't seen anyone ask for that
before, so I haven't seen much demand for it.
---
Robert Treat wrote:
> There is no e
On Thu, 2003-02-13 at 08:53, dima wrote:
> > I am trying to automate my backups using pg_dump. However, I am not able to
> > pass the password to the command. Has anybody sucessfully done automated
> > backup thru scripts?
> export PGPASSWORD=password && pg_dump ... && export PGPASSWORD=""
Presuma
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi.
One year ago, I was worked with postgresql 7.1. In this, my pg_hba.conf was
"finished-line" like this; password
Then, when I have one year whitout "touch" anything about postgres, I have
compiled postgresql, but I do not find the command "pg_p
Didn't see a reply to this, I suspect your trying to start a database
that hasn't had initdb run. Oddly, initdb doesn't seem to be mention in
the long install instructions...
See the following for more info:
http://www.gtsm.com/cgi/psearch?page=installation.html#INSTALL-SHORThttp://www.gtsm.com/cg
There is no way to do this, short of a lot of hand editing. If your
going to hand edit, I recommend trying to make two separate dump files,
one with data, one with schema. Others have tried to do this before,
check the archives in some of the other lists, perhaps someone has
posted a script somewhe
Generally no, as they need access to some of those tables in order to
run queries and such. :-(
Robert Treat
On Thu, 2003-02-13 at 07:21, Jose Antonio Martinez wrote:
> is it posible to hide catalog tables (pg_user,
> pg_database, ...) to users that are not superuser?
>
>
--
On Tue, 2003-02-11 at 09:26, Sidar Lopez Cruz wrote:
> have compare some body PostgreSQL against ms-sql server
We run better on *nix, they run better on m$. We're plan on changing
the latter.
http://techdocs.postgresql.org/redir.php?link=/techdocs/sqlserver2pgsql.php
http://techdocs.postgresql.
On Tue, 2003-02-11 at 17:15, Sidar Lopez Cruz wrote:
> Have postgreSQL an GUI Interface for Linux?
>
>
http://techdocs.postgresql.org/guides/GUITools
Robert Treat
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://a
Seems this should be added to the FAQ...
Robert Treat
On Wed, 2003-02-12 at 16:27, Bruce Momjian wrote:
>
> 7.3.2 has .pgpass where you can place the password.
>
> ---
>
> Panchal, Ritesh wrote:
> > Hi,
> > I am trying to
There is no equivilant setting in postgresql, though this doesn't seem
like a terribly hard feature to add. You might want to submit a proposal
on -hackers, or better yet, a patch. :-)
Robert Treat
On Wed, 2003-02-12 at 13:36, Jose Antonio Martinez wrote:
> In mysql there are two configuration pa
is it posible to hide catalog tables (pg_user,
pg_database, ...) to users that are not superuser?
___
Yahoo! Móviles
Personaliza tu móvil con tu logo y melodía favorito
en http://moviles.yahoo.es
---(end of broadcast)-
Hello Tom,
after running 2 at jobs at night (cluster on txtidx indexes and vacuum full) I
tried again this morning 'cause the same job on a similar table structure
went fine.
newsdb2=# update dpa_text set titleidx=txt2txtidx(volltext);
ERROR: referential integrity violation - key referenced
On Thursday 13 February 2003 06:08, Tom Lane wrote:
> Andreas Schmitz <[EMAIL PROTECTED]> writes:
> > I am still working on the newspaper archive project. I started indexing
> > the articles with tsearch. Along the long text parts I get a "ERROR:
> > deadlock detected" when I try to build the inde
I am trying to automate my backups using pg_dump. However, I am not able to
pass the password to the command. Has anybody sucessfully done automated
backup thru scripts?
export PGPASSWORD=password && pg_dump ... && export PGPASSWORD=""
---(end of broadcast)---
40 matches
Mail list logo