> Hi Fred/Matt,
> I'm still stuck-up at the same issue
> (/apps/systran/perl/lib/sun4-solaris/auto/DBD/Pg/Pg.so' for module
> DBD::Pg: ld.so.1: /usr/local/bin/perl: fatal: libgcc_s.so.1: open
> failed: No such file or directory at
> /usr/local/perl5.6.1/lib/sun4-solaris/DynaLoader.pm line 206.
>
I use a separate command like lsof to map processes to tcp/unix ports on the client
and server machines.
--- On Mon 11/24, Rich Cullingford < [EMAIL PROTECTED] > wrote:
From: Rich Cullingford [mailto: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Mon, 24 Nov 2003 11:55:07 -0500
Subject: [ADMI
Hi Fred/Matt,
I'm still stuck-up at the same issue
(/apps/systran/perl/lib/sun4-solaris/auto/DBD/Pg/Pg.so' for module
DBD::Pg: ld.so.1: /usr/local/bin/perl: fatal: libgcc_s.so.1: open
failed: No such file or directory at
/usr/local/perl5.6.1/lib/sun4-solaris/DynaLoader.pm line 206.
at (eval 1
Ivan wrote:
> I use the MySQL database on the web for the forum and for a news system. I
> would like to know what are the advantages of pgsql over MySQL. I am
> entering in the world of databases so i don't know much as I am 16 years
> old.
When you use PostgreSQL and experiment with it a little,
A few thoughts: what command are you using to produce the 7.2 dump? what is
the exact version of the 7.2 server?
Try and see if you can get a good dump using the 7.4 pg_dump against the 7.2
database.
Robert Treat
On Monday 24 November 2003 08:43, Gerwin Philippo wrote:
> Oops, last message w
Rich Cullingford wrote:
> All,
> This is a pretty obvious question, but I can't find an answer in the
> standard docs/archive: if I have an installation in which there are a
> number of long-running client processes interacting (one-on-one) with
> backend processes, how do I find the associations?
First you must have java support enabled (--with-java)
when you configure postgres for compiling. This will enable java support
build the correct JDBC drivers based on your Java SDK version. Besides
reading http://jdbc.postgresql.org/ as
Peter pointed out, you may want to also look at
Shravan writes:
>I am a very new user of postgreSQL. It was an easy task of setting up
> the server and database.But the problem I am having is to communicate
> with the db using a Java application program. Can anybody tell me how to
> connect to the db using JAVA.
http://jdbc.postgresql.org/
I'm testing 7.4, and tried to read a pg_dump file created in 7.2 into a 7.4
database.
I get a lot of error messages when creating views from tables because the
tables are not created yet.
Looking into the dump file, the order in which objects are created looks
funny: first some views, then the tabl
Hi All,
We are using Postgres 7.2.2 and unixODBC-2.0.3 ODBC driver. Postmaster
process and ODBC clients run on different Linux machines. Everything
works fine but the worrysome part is that our clients keep reporting
that DB is inaccessible and within seconds they get connected again.
This hap
Oops, last message was not entirely correct: Unfortunately the 7.2 version
is also unable to read back the dumps it made. The dumps created look
completely impossible to run to me:
line100: create view "vw1" as select field1 from table1;
line200: create table1 (field1 integer);
If the server wen
[EMAIL PROTECTED] ("Ivan") wrote:
> As I am new in the world of PostgreSQL I would like to know what are
> the advantages of using it.
That cannot be evaluated in the absence of some set of metrics
indicating your preferences and needs, and which would allow comparing
PostgreSQL to some other opti
Hi All:
I am trying to restore a database on a different machine (7.2.3 on Sol9 to 7.2.4 RH8),
and i get the following error, that i haven't seen before:
-bash-2.05b$ pg_restore -d access -Ft -a access.dump.tar
pg_restore: [tar archiver] could not open TOC file for input: File too large
Segmen
In article <[EMAIL PROTECTED]>,
Sam Barnett-Cormack <[EMAIL PROTECTED]> wrote:
>Is pg7.4 not available through the apt system at all?
It sure is.
http://www.mail-archive.com/[EMAIL PROTECTED]/msg71008.html
Mike.
---(end of broadcast)---
TIP 4: Do
Hi all,
I am a very new user of
postgreSQL. It was an easy task of setting up the server and database.But
the problem I am having is to communicate with the db using a Java
application program. Can anybody tell me how to connect to the db using
JAVA.
Thanks in advance,
Shravan
Title: Message
Hi All:
I am trying to restore a database on a
different machine (7.2.3 on Sol9 to 7.2.4 RH8), and i get the following error,
that i haven't seen before:
-bash-2.05b$ pg_restore -d access -Ft -a
access.dump.tarpg_restore: [tar archiver] could not open TOC file for input:
F
All,
This is a pretty obvious question, but I can't find an answer in the
standard docs/archive: if I have an installation in which there are a
number of long-running client processes interacting (one-on-one) with
backend processes, how do I find the associations? I can see the client
PIDs in a
Ivan wrote:
I use the MySQL database on the web for the forum and for a news system. I
would like to know what are the advantages of pgsql over MySQL. I am
entering in the world of databases so i don't know much as I am 16 years
old.
For a forum & news system, there's probably zero difference/adva
Hi everybody,
I have a problem with dump / restore commands on PostgreSQL:
pg_dump doesn't care about objects dependencies:
- I create a view V1 on a table and then another view V2 on the
same table
- I modify V1 to use V2
pg_dump doesn't detect that V1 is using V2. So the command
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
William ZHANG írta:
| ""Ivan"" <[EMAIL PROTECTED]> Writes news:[EMAIL PROTECTED]
|
|>As I am new in the world of PostgreSQL I would like to know what are the
|>advantages of using it.
|
IMHO:
Stored procedures
Triggers
Views
Rules
With them you can embe
Hi,
trying to load the xml-package (maked in /contrib/xml/) I get the error
message "stat failed on file '$libdir/pgxml_dom': file etc not found .."
I think, this means no system-path, but the pg-libdir-path, configured in
installation of pg. How can I extend the pg-libdir-path pointing also to
t
I use the MySQL database on the web for the forum and for a news system. I
would like to know what are the advantages of pgsql over MySQL. I am
entering in the world of databases so i don't know much as I am 16 years
old.
>
>--- Ivan <[EMAIL PROTECTED]> wrote:
>> Over MySQL as I used it until now.
Well, I'm using MySQL on the web for a forum and a news sistem. I just
started to work with relational databases (i'm 16 years old).
>
>--- Ivan <[EMAIL PROTECTED]> wrote:
>> Over MySQL as I used it until now.
>
>What are your issues with mySql?
>
>
>
>
>
>
>
>__
>Do
""Ivan"" <[EMAIL PROTECTED]> Writes news:[EMAIL PROTECTED]
> As I am new in the world of PostgreSQL I would like to know what are the
> advantages of using it.
PostgreSQL is a open source ORDBMS, with many great features.
Sugguest you read its document for details.
>
> Bye,
> Ivan
>
> --
> Treba
--- Ivan <[EMAIL PROTECTED]> wrote:
> Over MySQL as I used it until now.
What are your issues with mySql?
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
---(end of broadcast)---
>Ivan wrote:
>
>>As I am new in the world of PostgreSQL I would like to know what are the
>>advantages of using it.
>>
>>
>Over what?
>
>
Over MySQL as I used it until now.
--
Trebate bolji pristup internetu?
Nazovite IskonInternet na 0800 1000 ili pogledajte
http://www.iskon.biz/individualni/us
26 matches
Mail list logo
