Vitaliyi wrote:
%openssl x509 -noout -dates -issuer -subject -in postgresql.crt
notBefore=May 16 13:55:49 2008 GMT
notAfter=Jun 15 13:55:49 2008 GMT
issuer= /C=UK/ST=Some-State/L=Kiev/O=0x2A/CN=80.93.122.34/[EMAIL PROTECTED]
subject= /C=UK/ST=Some-State/L=Kiev/O=Internet Widgits Pty
Title: Agro-Annuaire.com
Si vous ne
parvenez pas visualiser correctement cette newsletter,
cliquez ici
Hi
I have written a number of C-Function which compile and link against the GNU
Scientific Library libraries 'libgsl' and 'libgslcblas' when using a hand
written Makefile, but I would like to use PGXS.
My functions compile fine using PGXS, but don't link against the GSL libraries.
How do I
[EMAIL PROTECTED] writes:
My functions compile fine using PGXS, but don't link against the GSL
libraries.
How do I specify the GSL libraries as external libraries to link against in
the
PGXS Makfile? I have tried the following which don't work:
PG_CPPFLAGS = -lgsl -lgslcblas
PG_LIBS =
Hello,
I would like to ask an opinion on vacuuming general. Imagine situation
that you have single table with 5 fields (one varchar). This table has
during the day
- cca 620 000 inserts
- 0 updates
- cca 620 000 deletes
The table is vacuumed daily, but somehow after several months I got to
size
Hello,
I would like to ask an opinion on vacuuming general. Imagine situation
that you have single table with 5 fields (one varchar). This table has
during the day
- cca 620 000 inserts
- 0 updates
- cca 620 000 deletes
The table is vacuumed daily, but somehow after several months I got
Apart from reinterating what someone else: you're not vacuuming
anywhere near often often. Normal vacuum takes no locks.
On Mon, May 19, 2008 at 04:50:18PM +0200, Bohdan Linda wrote:
3) There were suggestions (in archives) doing dump and then restore on
dropped database, but still requires
On Mon, May 19, 2008 at 04:59:42PM +0200, Harald Armin Massa wrote:
do not vacuum DAILY. set up autovacuum to run AT LEAST every minute.
autovacuum will flag the deleted rows as to be reusable by next
insert. Make sure to use 8.3.latest, it's much more easy to setup
autovacuum then before.
Hi
I can't seem to make the ident sameuser authentication method
work on Mac OS X Leopard (or ident with a specified mapping). It
seems Apple removed identd from the system, I can't find it and
nothing is listening on port 113. Any ideia how to make this work on
Leopard?
Yours
On Mon, May 19, 2008 at 04:59:42PM +0200, Harald Armin Massa wrote:
On Mon, May 19, 2008 at 04:50:18PM +0200, Bohdan Linda wrote:
I would like to ask an opinion on vacuuming general. Imagine situation
that you have single table with 5 fields (one varchar). This table has
during the day
Tom
Thanks for the reply. My GSL libraries, 'libgsl' and 'libgslcblas', are in the
/usr/lib directory as GSL and the GSL development files were installed via
Fedora 8 RPM's. I'm a relative newbie to programming, so I thought the -L
switch is only required to add a non-standard library location to
On Mon, May 19, 2008 at 06:21:18PM +0100, Sam Mason wrote:
for t in foo bar baz
do ( while echo VACUUM $t; false ; do true ; done | psql )
done
oops, that false shouldn't be there! like like this:
for t in foo bar baz
do ( while echo VACUUM $t; ; do true ; done | psql )
On Mon, May 19, 2008 at 8:50 AM, Bohdan Linda [EMAIL PROTECTED] wrote:
Hello,
I would like to ask an opinion on vacuuming general. Imagine situation
that you have single table with 5 fields (one varchar). This table has
during the day
- cca 620 000 inserts
- 0 updates
- cca 620 000
On Mon, May 19, 2008 at 06:23:03PM +0100, [EMAIL PROTECTED] wrote:
Thanks for the reply. My GSL libraries, 'libgsl' and 'libgslcblas', are in the
I saw that and then in your previous message:
PG_CPPFLAGS = -lgsl -lgslcblas
PG_LIBS = -lgsl -gslcblas
SHLIB_LINK = -lgsl -gslcblas
Miguel Arroz [EMAIL PROTECTED] writes:
I can't seem to make the ident sameuser authentication method
work on Mac OS X Leopard (or ident with a specified mapping). It
seems Apple removed identd from the system, I can't find it and
nothing is listening on port 113. Any ideia how to make
On Mon, 19 May 2008, Miguel Arroz wrote:
I can't seem to make the ident sameuser authentication method work on
Mac OS X Leopard (or ident with a specified mapping).
Then don't use ident? In your situation I would switch the pg_hba.conf
from ident sameuser to use something sensible like md5
thanks for the help guys, i've solved the problem using PL/PgSQL. once
i had created the language it was really rather simple.
thanks again
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Hi, i need help for a query. I have three fields, year, month and day
into table and need join and update another field named date on same
table.
My problem is not that make update query.
With this query have the value of the update:
select year || '-' || month || '-' || day || ' 01:00:00' as
Wow...so does no one use phppgadmin on servers that they are connected
to via the internet? Or if you do, how do you go about securing it so
that no one snoops your password?
Thanks
On May 16, 12:34 am, [EMAIL PROTECTED] [EMAIL PROTECTED]
wrote:
Hi...
This is as much an apache question as
On Sun, 2008-05-18 at 23:33 -0700, [EMAIL PROTECTED] wrote:
Wow...so does no one use phppgadmin on servers that they are connected
to via the internet? Or if you do, how do you go about securing it so
that no one snoops your password?
Thanks
On May 16, 12:34 am, [EMAIL PROTECTED]
I can't imagine you have to do much of anything to it. Once apache is
set up to handle https:// requests, the rest should just happen.
On Mon, May 19, 2008 at 12:33 AM, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Wow...so does no one use phppgadmin on servers that they are connected
to via the
Is there a good reason to NOT store the year month and day as a date
instead of this way?
I can think of a lot of very good reasons to store it as a date, not a
lot of reasons to store them broken apart.
On Mon, May 19, 2008 at 4:51 AM, jrivero [EMAIL PROTECTED] wrote:
Hi, i need help for a
On Mon, May 19, 2008 at 4:51 AM, jrivero [EMAIL PROTECTED] wrote:
Hi, i need help for a query. I have three fields, year, month and day
into table and need join and update another field named date on same
table.
My problem is not that make update query.
With this query have the value of the
On Mon, May 19, 2008 at 03:36:39PM -0600, Scott Marlowe wrote:
On Mon, May 19, 2008 at 4:51 AM, jrivero [EMAIL PROTECTED] wrote:
My problem is not that make update query.
update table set date=(select year || '-' || month || '-' || day || '
01:00:00' as newdate from table)
Cast the
Hello
I have some similar situation like Yours,we're using at the moment PG
8.2.0. At the moment we do manually vacuum (one or more times to
minimize 'dead' data/tuples),and if necessary we do 'full' vacuum. On
heavy-updated PG,one surely must think of this procedures because they
are
I am trying to automatically create a database right after installing
postgres. I launch the silent install (Windows) from my own executable
and once it is done I need to create a database, tables, etc. I am
trying to find a way to do this without having to explicitly enter the
password in at the
Hi everyone,
I am having problems logging into psql as a non-'postgres' user.
/home/djoo[5:38pm]$ %psql kermit -U postgres
psql: FATAL: Ident authentication failed for user postgres
Below is a portion of the pg_hba.conf file, which I believe is
configured so that a password is not
On Tue, May 20, 2008 at 5:34 AM, Sam Mason [EMAIL PROTECTED] wrote:
On Mon, May 19, 2008 at 03:36:39PM -0600, Scott Marlowe wrote:
On Mon, May 19, 2008 at 4:51 AM, jrivero [EMAIL PROTECTED] wrote:
My problem is not that make update query.
update table set date=(select year || '-' ||
Sorry for top-posting -- challenged reader, but less challenged than running
8.2.0 -- upgrade to latest release -- 8.2.7! There were many fixes after the
initial release and you're risking some bad mojo.
Greg Williamson
Senior DBA
DigitalGlobe
Confidentiality Notice: This e-mail message,
Nathan Thatcher wrote:
I am trying to automatically create a database right after installing
postgres. I launch the silent install (Windows) from my own executable
and once it is done I need to create a database, tables, etc. I am
trying to find a way to do this without having to explicitly
Dan Joo wrote:
Hi everyone,
I am having problems logging into psql as a non-‘postgres’ user.
*/home/djoo[5:38pm]$ %psql kermit -U postgres*
*psql: FATAL: Ident authentication failed for user postgres*
Sure there isn't a line like this:
local all postgres
On Mon, May 19, 2008 at 5:44 PM, Dragan Zubac [EMAIL PROTECTED] wrote:
Hello
I have some similar situation like Yours,we're using at the moment PG 8.2.0.
As Gregory above mentioned, update NOW to 8.2.7. It only takes minutes to do.
At the moment we do manually vacuum (one or more times to
On May 14, 2008, at 6:18 PM, Greg Smith wrote:
Also, how long should pages stay in the cache? (Assuming I have
way more
memory than the total size of all the tables/indexes.) Is there any
time-based expiration (in addition to LRU-based, which in my case
should
never be resorted to)?
Dan,
Always cc the mailing list so others can provide other suggestions where
necessary.
Dan Joo wrote:
Thanks, Chris, but yes, I am sure that there is no such line. (see below)
[EMAIL PROTECTED] data]# cat pg_hba.conf | grep -v '^#'
local all all
This is copy from a forum where i described my problem w postgresql.
Can anyone help me?
after postgresql install my pc freezes/slows critically
by zaxpoker on Fri May 16, 2008 4:30 am
hey!
I installed postgresql on my pc, I could do everything according to the
installation guide everything
On Mon, 19 May 2008, Decibel! wrote:
Hrm... don't seqscans use a separate set of buffers in 8.3? While technically
those won't be evicted until needed, you're unlikely to find stuff hanging
around there for terribly long...
Not quite a separate set, and I have been remiss that I only skim
Got it about cc'ing.
Actually, I restarted postgres using:
/etc/init.d/postgresql restart
Any other suggestions?
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Mon 5/19/2008 8:34 PM
To: Dan Joo; pgsql-general@postgresql.org
Subject: Re: [GENERAL] psql:
37 matches
Mail list logo