I executed the script inst/creer-base, the script run, because when I did :
$ psql auth
auth=# \dt
List of relations
Schema | name |Type| Owner
-
public | config | table| postgres
public | groupes
I executed the script inst/creer-base, the script run, because when I did :
$ psql auth
auth=# \dt
List of relations
Schema | name |Type| Owner
-
public | config | table| postgres
public
Hi,
My application uses several database tables on Postgres backend and either
a postgres or an ODBC front-end. I need to calculate the total hard disk
space occupied by the database for my application. I started out by
calculating the size of each record (row) in each table and multiplying
th
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Thu, 10 Jun 2004 [EMAIL PROTECTED] wrote:
> I would appreciate any pointers to finding out the correct size occupied by
> my database tables. Will the physical size of the "data" folder (as given
> by 'ls' command) give me the true size, or
"lise chhay" <[EMAIL PROTECTED]> writes:
> $ psql auth
> auth=# \encoding latin9
> auth=# select * from groupes
> auth=#
> "select * from groupes" didn't display any data.
I think you forgot to type a semicolon?
regards, tom lane
---(end of b
I need an informed opinion:
The performance boost from clustering is wonderful. But, some tables would have
to clustered several times a day, since there is usually some type of "status"
column that is updated pretty regularly. Clustering is an expensive operation.
If I pulled out that column into
Dear Group,
We are using Postgresql 7.3.4 on Redhat 8.0 with
Java 1.4.2. We are developing our applications in Java. We call stored
procedures from the java program. Order numbers are generated by many
departments in the Hospital. We manitain a single t
Functions can't have transactions inside of them
You need to start the transaction then call the function.
couple of questions though
why not use sequences ? Then you have no concurrency issues. They are
guaranteed to be incremented.
Also you can use select for update, instead of locking the en
lise chhay wrote:
>I executed the script inst/creer-base, the script run, because when I did :
>$ psql auth
>auth=# \dt
>List of relations
>Schema | name |Type| Owner
>-
>public | config | table| postgres
Title: RE: [ADMIN] PostgreSQL 7.4.2 on SunOS 4.1.4
Tom Lane writes:
[snip]
> > I have not regenerated the bison-generated parser source file - it is
> > the one that comes with PostgreSQL 7.4.2.
>
> Are you speaking specifically of
>
> src/backend/bootstrap/bootparse.c
> src/backen
Hi,
My statistics collector is not collecting any statistics and functions
such as pg_stat_get_tuples_fetched() return 0.
I have set run-time parameters thusly:
stats_command_string | on
stats_reset_on_server_start| on
stats_row_level| on
stats_start_collector
Gavin Thompson <[EMAIL PROTECTED]> writes:
> My statistics collector is not collecting any statistics and functions
> such as pg_stat_get_tuples_fetched() return 0.
I'd wonder about kernel packet filtering preventing the data from
getting through to the collector. Our CVS tip has a startup-time c
Hello all;
I am trying to connect to a postgreSQL server running version 7.3.2 on
freebsd (5.1). I'm having trouble getting the syntax right for this
subnet. I thought I had this working at home for a simple
192.168.0.0/24 network. This is the line in the pg_hba.conf
host all all 10.1
"Bender, Cheryl" <[EMAIL PROTECTED]> writes:
> I am trying to connect to a postgreSQL server running version 7.3.2 on
> freebsd (5.1). I'm having trouble getting the syntax right for this
> subnet. I thought I had this working at home for a simple
> 192.168.0.0/24 network. This is the line in t
Hi.
That is an article on www.linuxuser.co.uk , issue 34 entitled "A Guide
to filesystem encryption"
that may do what you want to do.
It uses a method called "Loop-AES" http://loop-aes.sourceforge.net .
Hope it works for you
Sergio
Silvana Di Martino wrote:
The new italian law about personal dat
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Matt Clark wrote:
|>What's wrong with using a LoopAES filesystem? It protects against
|>someone walking off with the server, or at least the hard disk, and
|>being able to see the data.
|
|
|Yes, but only if the password has to entered manually [1] at
Alle 09:51, venerdì 5 marzo 2004, Dave Ewart ha scritto:
> I guess there may similar legislation in Italy and elsewhere.
Actually, the Italian law is an implementation of a EU directive strictly
inspired to the existing UK law. It will affect all EU in a few years.
See you
-
Hi,
we are using Postgres with a J2EE application (JBoss) and get
intermittent "out of memory" errors on the Postgres database. We are
running on a fairly large Linux server (Dual 3GHz, 2GB Ram) with the
following parameters:
shared_buffers = 8192
sort_mem = 8192
effective_cache_size = 23488102
I get this error when I try to analyze a column containing md5 hashes.
The data type of the column is: bytea. The database encoding is UNICODE.
Does anybody know a workaround for this?
Thanks.
$ vacuumdb --analyze --table 'files(md5hash)'
ERROR: Invalid UNICODE character sequence found (0xdb51)
v
Marcello Perathoner <[EMAIL PROTECTED]> writes:
> I get this error when I try to analyze a column containing md5 hashes.
> The data type of the column is: bytea. The database encoding is UNICODE.
> Does anybody know a workaround for this?
> PostgreSQL 7.3.3 on i686-redhat-linux-gnu, compiled by
Hi,
Thanks for the response. However, the README.dbsize says that "When
computing the size of a table, it does not include TOAST or index disk
space." So dbsize would not be giving me the total diskspace occupied by my
tables, right ? I need to know the full disk space so i can do some hard
di
21 matches
Mail list logo
