Hi all,
we are facing with a struggle problem with PostgreSql database
production.
A client system based on pgsql is down because the database raise an
error message like " no left space on device". We have deleted some log
files on this machine and after a system restart the db (and the system)
w
On Tue, 17 Mar 2009 09:50:55 +0100, "Lori, Giancarlo"
wrote:
> Hi all,
> we are facing with a struggle problem with PostgreSql database
> production.
> A client system based on pgsql is down because the database raise an
> error message like " no left space on device". We have deleted some log
>
I am getting correct results with following query i.e. binary objects as
they are inserted.
select docimages.* from docimages where docimages.accobjecttype=9 ORDER BY
docimages.docimagename;
but when I created a function as follows, binary objects are not shown,
rather a number represting the lar
c k writes:
> I am getting correct results with following query i.e. binary objects as
> they are inserted.
> select docimages.* from docimages where docimages.accobjecttype=9 ORDER BY
> docimages.docimagename;
> but when I created a function as follows, binary objects are not shown,
There is n
Lori, Giancarlo wrote:
> A client system based on pgsql is down because the database raise an
> error message like " no left space on device". We have deleted some log
> files on this machine and after a system restart the db (and the system)
> was up&running. After two days the database has crash
Yes, the problem is with PGAdmin and ODBC connection to MS access.
The function (given is first mail) is giving same results i.e. only IDs not
the actual data from PGAdmin and ODBC.
But for following query PGAdmin gives again only IDs, but MS Access through
ODBC gives the actual binary data.
selec
On Tue, Mar 17, 2009 at 12:01:01PM +0100, ad...@informatyka.gdansk.pl wrote:
> On Tue, 17 Mar 2009 09:50:55 +0100, "Lori, Giancarlo"
> wrote:
> > the postmaster process run, but any command pg_dump, etc I try to
> > execute failed. The system respond that there are not database in the
> > system.
On Tue, 2009-03-17 at 09:50 +0100, Lori, Giancarlo wrote:
> we are facing with a struggle problem with PostgreSql database
> production.
>
> A client system based on pgsql is down because the database raise an
> error message like “ no left space on device”. We have deleted some
> log files on
Thanks to all, I have solved, I have been able to restart the Postgres db, and
then after a pg-dump I have created a new one.
Thanks again
-Messaggio originale-
Da: Simon Riggs [mailto:si...@2ndquadrant.com]
Inviato: martedì 17 marzo 2009 15.10
A: Lori, Giancarlo
Cc: pgsql-admin@postgres
People,
I have three databases in different machines: a pgsql server version 8.2.4,
a pgsql server version 8.1.4 and another pgsql client version 8.3.5.
Is there a problem to make vacuum with client newer than server? For
example: To use vacuumdb of client version 8.3.5 to make vacuum in server
8.
On Tue, Mar 17, 2009 at 03:27:42PM +0100, Lori, Giancarlo wrote:
> Thanks to all, I have solved, I have been able to restart the Postgres db,
> and then after a pg-dump I have created a new one.
> Thanks again
I'd like to learn from your experience. Perhaps you would be willing to
expand on the
Hello, all.
Are there any FREE tools like Maestro SQL for postgres that i can run under
many various systems (windows, mac, linux, freebsd). One of the most
important future for me is browsing database structure as a scheme with
tables and relations beetwin them :)
Thanks beforehand.
--
Best re
Hi,
Michail Karataev a écrit :
> [...]
> Are there any FREE tools like Maestro SQL for postgres that i can run under
> many various systems (windows, mac, linux, freebsd). One of the most
> important future for me is browsing database structure as a scheme with
> tables and relations beetwin them
Guillaume Lelarge wrote:
Hi,
Michail Karataev a écrit :
[...]
Are there any FREE tools like Maestro SQL for postgres that i can run under
many various systems (windows, mac, linux, freebsd). One of the most
important future for me is browsing database structure as a scheme with
tables and re
14 matches
Mail list logo
