Hi!
I am now in the process of upgrading a couple of pg installation to 7.2. I
am a little in doubt if I should or not use the --enable-locale when
./configuring.
Even though I am a Norwegian, I prefer to have the messages from the data
base in english as that makes it much simpler to ask
Hi,
I am using PostgreSQL under cygwin/win2k.
which is the best way to schedule a backup?
under Linux, you can cron a pg_dump job (with a su to manage the
user/password), but i don't know how to handle this under cygwin?
any idea?
thanks
JC
Hi,
I use Postgresql 7.0.2 in my data logging
application system, I have to vacuum data base
every 8 hours because of many UPDATE requests. The
data base is going well except that a big pg_log file,
anyway I can accept it.
Recently, I got a new computer to porting my
application system. I
Hi,
to a larger way,
what is the best way to schedule tasks such as dump, vacuum, analyze under
cygwin?
as I notice before, under Linux (and generic UNIX systems), you can use
cron to do that, but under cygwin?
JC
_
Jean-Christophe
Hi. Sorry for that duplicated e-mail, but I think we have any problem
with the e-mail server.
I've a new server to put the database production. The characterictics of
the new server are:
4 cpu's INTEL 1Ghz.
4 Gb. RAM
My database is about 125-130 Mb of size, and I think this configuration
for
I use at on NT to run .bat files
Example for vacuum analyse:
I first use at to run va.bat
va.bat:
c:\cygwin\bin\bash --login -i /va.sh
va.sh:
vacuumdb -a -z /dev/null 21 /dev/null
Hope this helps,
- Stuart
-Original Message-
From: Jean-Christophe FABRE
[mailto:[EMAIL
Hello!
I run postgreSQL-7.2 on RedHat Linux 7.2, kernel 2.4. I want to import
and export dbf-tables in and from postgres. I found pg2xbase library that requires
xbase library. After installation, the conversion does not
work (segmentation fault, exports empty tables, distortion of numeric
Eric Scroger [EMAIL PROTECTED] writes:
gmake[2]: Entering directory
`/usr/share/src/pgsql/postgresql-6.4.2/src/backend/bootstrap'
d bootparse.y
gmake[2]: d: Command not found
gmake[2]: [bootparse.c] Error 127 (ignored)
Looks like the configure script has chosen d instead of bison or yacc
Morten Sickel writes:
Even though I am a Norwegian, I prefer to have the messages from the data
base in english as that makes it much simpler to ask questions here or to
searc for help on the web. on the other hand, I need to store character
string containing letters outside the 7bit ASCII
I received the following error from a VACUUM ANALYZE:
NOTICE: FlushRelationBuffers(place, 454): block 231 is referenced
(private 0, global 4)
FATAL 1: VACUUM (vc_repair_frag): FlushRelationBuffers returned -2
and psql lost the connection right after that. This was repeatable,
after the
Bob Smith [EMAIL PROTECTED] writes:
PostgreSQL 7.0.2
Time to update ...
I'm rather surprised that restarting the postmaster didn't make the
error go away, but it's unlikely that anyone will care to investigate
--- unless you can reproduce the problem in 7.1.3 or later.
How i could know the database name from directory name
(/usr/local/pgsql/data/base/)
Hernan Nuñez | VIA NET.WORKS Argentina
NICAR-P37184 |
[EMAIL PROTECTED] | local touch global reach
System Administrator |
Tecnología y Operaciones | http://www.vianetworks.com.ar
+ ICQ: 36528552 |
Hi,
Don't know enough about postgresql to be sure about this, but here goes:
If postgresql does bitwise operations, then you can use that instead of
defining new operators. Just construct a number for all the columns that
need to be true and do a bitwise 'and' with the stored value. (eg. (7
On Fri, 15 Mar 2002, Dmitry Tkach wrote:
[EMAIL PROTECTED] wrote:
If postgresql does bitwise operations, then you can use that instead of
defining new operators. Just construct a number for all the columns that
need to be true and do a bitwise 'and' with the stored value. (eg. (7
On Friday, March 15, 2002, at 09:53 , Tom Lane wrote:
Bob Smith [EMAIL PROTECTED] writes:
PostgreSQL 7.0.2
Time to update ...
I know, I know... But I'm about two weeks from bringing a whole new
server on-line with the latest version of Postgres, so I don't want to
hassle with upgrading
I tried that program quite a while back and it didn't work at all...not
even close.
I export the dbf tables to tab-delimited text files and COPY them into a
Pg table.
--Jeremy
On Wednesday, March 15, 102, at 06:46 AM, Ladislav Jirsa wrote:
Hello!
I run postgreSQL-7.2 on RedHat Linux 7.2,
Bob Smith [EMAIL PROTECTED] writes:
I'm rather surprised that restarting the postmaster didn't make the
error go away, but it's unlikely that anyone will care to investigate
--- unless you can reproduce the problem in 7.1.3 or later.
So this isn't an error that would be caused by some sort
On Fri, 15 Mar 2002, Dmitry Tkach wrote:
...
Yes, and know... (Yes, it will give th ecorrect answer, and NO it will
not use the index).
The thing is, that it will only use a (btree) index for one of the
'comparison' operators
(=, , =, , =), that compare the value in the table with the
On Friday, March 15, 2002, at 03:07 , Tom Lane wrote:
It's not clear to me why a restart (which would naturally clear shared
memory) didn't fix the problem.
Er, um, (humble look), I just studied my syslog, and in fact the
postmaster _didn't_ restart. I tried to restart it using the Red Hat
19 matches
Mail list logo