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 quest
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 ins
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 FABR
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 the
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 2>&1 -Original Message-
> From: Jean-Christophe FABRE
> [mailto:[EMAIL PROTECTED]]
> Sent: 15 March 2002
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 field
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 o
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 ASCI
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 fir
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 | D
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 &
st
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.
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 upgr
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.
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 som
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
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 Ha
19 matches
Mail list logo