Patrick Meylemans <[EMAIL PROTECTED]> wrote:
>The problem is detected but the reason is still not clear. It seems that
if
>one is connecting via a ODBC link from a winbox to a postgresql database
>the link first tries to connect via username Admin, see syslog :
>Oct 25 07:47:52 backbone logger:
Apparently it doesn't need one. On a whim I left the value of
"InstallDir" unassigned and continued on. I opened an OpenOffice
spreadsheet and added a data source... and it worked!
On Fri, 2002-10-25 at 14:17, John Burski wrote:
> I'm attempting to enable ODBC support for PostgreSQL 7.2.2 run
Hi,
I upgrade my postgreSQL to 7.2.3 release and every thing works fine, but
when i run the pg_ctl to start the postmaster i got two FATAL1. The
postmaster start and the databases works. Any idea about this errors ??
Thanks in advance !!
/usr/local/bin/pg_ctl start -w -D /usr/local/db/pgsql/dat
Hi,
I am looking for SQL statements that query a database for it's physical
size, number of tables, etc.
Regards
Nyon
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL
I'm attempting to enable ODBC support for PostgreSQL 7.2.2 running on
Red Hat 8.0. I'm also using OpenOffice.org.
I've followed the instructions given in the documentation supplied with
the RPMs and all has gone well -- so far.
Right now I'm hung up in the configuration file. The last line of
Hernan Nunez <[EMAIL PROTECTED]> writes:
> /usr/local/bin/pg_ctl start -w -D /usr/local/db/pgsql/data -l /var/log/pgsql
> waiting for postmaster to start...
> Oct 25 13:26:51 ns6j postgres[4370]: [1] FATAL 1: The database system is
> starting up
> Oct 25 13:26:51 ns6j postgres[4370]: [1] FATAL 1:
SOLVED!!
I tried a tip of a earlier post
- I wiped the new disk clean of all postgres packages.
- I moved the old postgres lib dir to /var/lib/postgresql
- did a apt-get install postgresql which installed postgres and all
packages needed.
During the installation process a message appeared the pac
seems like:
there's read/write, write, write access on the file.
I think the others might want to be able to read the file instead of writing
to it.
"Andrey Romanchenko" <[EMAIL PROTECTED]> schreef in bericht
news:a4t5vu$1jt2$1@;jupiter.hub.org...
> hi all!
>
> when I attempt to start postgresql
>
Hi,
According to some messages found in mailinglists,
smp-support for pgsql 7.2.1 has been improved, but I
could not find any 'official' documentation confirming
this.
Anyone has experience with smp and postgresql 7.2.1
(neg/pos) or can redirect me to some url documenting
this smp-support ?
Thx
Hello All
Consider a function:
create function f(varchar(10), decimal(10,1)) returns integer as 'select 1;'
language sql;
I need to retreive full set of info about argument and return types (for
variable length too).
How I can get it from system catalog ?
For tables columns I can gen an info from p
Hi!
I’m new in Postgres,
Is there a way to start postgres
as user root, yes this isn’t the normal way, but I will use it only for
my own,
Or is there a other way to
write with a stored procedure a file, to a directory where user postgres haven’t
access, becourse I will create a config
"Patrick Meylemans" <[EMAIL PROTECTED]> wrote in message
news:5.1.1.6.0.20021024143111.00aef110@;server04.site04.wtcm.be...
> How can I trace the IP adres of the client trying to connect as Admin to
> our database ?
This is a total guess, but maybe it will help until someone who knows the
answer i
Unless I am mistaken (which actually happens quite often) DBI is the
base modue that perl uses.. the extension of that DBI::Pg (which is
called in the script) is postgres specific. That is what I am using and
I am new to postgres but have been working with perl for 3-4 years and I
have found it ve
On Thu, 24 Oct 2002, Patrick Meylemans wrote:
> Dear,
>
> I'm receiving the following messages in the /var/log/message file :
>
> -> logger: verify_password: user 'Admin' not found in password file.
>
> We are running on RedHat7.0
> Postgresql7.1.3
>
> How can I trace the IP adres of the clien
I'd say: pgAdmin or pgAccess
"W. Luijk" <[EMAIL PROTECTED]> schreef in bericht
news:a5qa9v$142r$1@;jupiter.hub.org...
> I installed pg on a Redhat 7 box but dont know which tool
> i can us to admininstrate (visual) the databases.
> Can anyone help me?
>
>
>
---(end of br
Actually there are two PostgreSQL Perl interfaces the DBI based one
and Pg. It has been a while since I have used Perl (and it has been
even longer since I used the Pg interface), but I can tell you that
most people use the DBI version. The two interfaces are very similar,
but the Pg interface i
During our load testing we saw the errors
below. I believe that the "Sorry, too many clients already" is because we
exceeding the max connections to the database. The "Socket command type
'unknown" error I do not understand.
Our installation is postgres 7.2.1 on Solaris 8 sun
server. T
anyone here know what's the hash
functions used in pgsql?
-- Rafael
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Tue, Oct 22, 2002 at 06:00:57PM -0700, David Bear wrote:
> \pset recordsep "^"
> (and other chars along with the caret) but it seems the postgress is not
> using that character. My thinking was to strip all cr/lf, the replace the
> caret with a newline. Then we could bring the data into so
On Thu, Oct 24, 2002 at 03:56:44AM -0700, John Doe wrote:
> Hi,
>
> According to some messages found in mailinglists,
> smp-support for pgsql 7.2.1 has been improved, but I
> could not find any 'official' documentation confirming
> this.
It was a bugfix. There was a spinlock problem in versions
"Zuev Dmitry" <[EMAIL PROTECTED]> writes:
> Consider a function:
> create function f(varchar(10), decimal(10,1)) returns integer as 'select 1;'
There is no distinction between such a function and a function declared
create function f(varchar, decimal)
Function arguments do not have length
"JOE" <[EMAIL PROTECTED]> writes:
> During our load testing we saw the errors below. I believe that the "Sorry=
> , too many clients already" is because we exceeding the max connections to =
> the database.
Check.
> The "Socket command type ' unknown" error I do not understand.
The most likely
> Next your going to ask what will stop root from stopping your
> PostgreSQL, compiling a second copy with authentication disabled and
> using your data directory as it's source :)
He he somebody can blow up ur home with C4, but this don't stop you from
locking ur door !?!
-
On Tue, Oct 22, 2002 at 05:05:38PM +0200, Igor Georgiev wrote:
> or my nightmare a cygwin on Win 98 everybody can can access everything
Or =my= nightmare: Anything important on any Windows platform.
-crl
--
Chad R. Larson (CRL22)[EMAIL PROTECTED]
Eldorado Computing, Inc. 602-604
On Tue, 2002-10-22 at 12:12, Igor Georgiev wrote:
> > > edit *pg_hba.conf *
> > > # Allow any user on the local system to connect to any
> > > # database under any username, but only via an IP connection:
> > > host all 127.0.0.1 255.255.255.255tr
On Fri, 25 Oct 2002, Igor Georgiev wrote:
>
> > Next your going to ask what will stop root from stopping your
> > PostgreSQL, compiling a second copy with authentication disabled and
> > using your data directory as it's source :)
>
> He he somebody can blow up ur home with C4, but this don't stop
26 matches
Mail list logo