Andreas Schmitz <[EMAIL PROTECTED]> writes:
> I am still working on the newspaper archive project. I started indexing the
> articles with tsearch. Along the long text parts I get a "ERROR: deadlock
> detected" when I try to build the index "update dpa_text set
> titleidx=txt2txtidx(volltext);".
Hi all,
> 7.3.2 has .pgpass where you can place the password.
That's a nice feature - haven't read up much on the 7.3 series as yet. It will
certainly remove my reliance on kludgy expect scripts to automate backups and
refreshes...
> Panchal, Ritesh wrote:
> > Hi,
> > I am trying to automate my
7.3.2 has .pgpass where you can place the password.
---
Panchal, Ritesh wrote:
> Hi,
> I am trying to automate my backups using pg_dump. However, I am not able to
> pass the password to the command. Has anybody sucessfully d
On 10 Feb 2003, Stephane Charette wrote:
> "The PostgreSQL team makes only small changes between minor releases,
> so upgrading from 7.2 to 7.2.1 does not require a dump and restore.
This says that you don't need to dump/restore when you are just upgrading
7.2 => 7.2.4, or 7.3.1 => 7.3.2. Minor r
See if ncurses/ncurses-devel are installed. I've had compilation with
readline support fail when these are missing.
Cheers,
Steve
On Tuesday 11 February 2003 1:08 pm, Rui Vilela wrote:
> Hello.
>
> I'm trying to compile pgsql 7.3.2 on Mandrake 9
> I got the libreadline and libreadline-devel RPMS
I'm having
difficulties to restore backup made on postgresql 7.3 on machine running
7.2. Is there any way how to accomplish this?
Thanx
Martin
Hello,
My name is rong xie. I am a Student at
TU-Munich.
I have a question to Postgresql an Linux.
e.g:
for IBM DB2: I can write a test.sql
file.
--test.sql
connect to database1;
set schema xie;
select * from table1;
insert table1 value('rong','xie',22);
select * from table1;
terminate
On Tue, 2003-02-11 at 23:11, Tom Lane wrote:
> Robert Treat <[EMAIL PROTECTED]> writes:
> > On Tue, 2003-02-11 at 17:27, Patrick S. Riedel wrote:
> >> I have a client with a v7.0.2-2c1 database stored on media. The
> >> database files were stored raw, not dumped. Their current pgsql version
> >>
Hi,
I am running:Intel P4, 512Mb Memory, 60Gb Hard DriveWindows2000 Pro, Service Pack
2PostgreSQL 7.3
cygwin dll 1.3.12-2ipc
1.11-1
Can anyone tell me
how to extend the database and logs to another disk space in case of a disk
filled up?
Many
Thanks
Kevin
In mysql there are two configuration parameters for
limiting connections:
max_user_connections
max_connections
the first limits the number of concurrent connexions
from a same user, is there an equivalent in
postgresql?
Postgresql seems to limit only the total number of
connexi
have compare some body PostgreSQL against ms-sql
server
Hello.I'm trying to compile pgsql 7.3.2 on Mandrake 9I got
the libreadline and libreadline-devel RPMS installed.On compile it gives
me an error, it cannot find readlinereadline is on /usr/lib, and i writed on
ld.so.confAnyone got a clue to solution ?thanks on advance.Rui
Vilela
Have postgreSQL an GUI Interface for
Linux?
While reading FAQ at
http://www.ca.postgresql.org/docs/faq-english.html#3.10, the following
advice is given:
"The PostgreSQL team makes only small changes between minor releases,
so upgrading from 7.2 to 7.2.1 does not require a dump and restore.
However, major releases (e.g. from 7.2 to 7.3) ofte
Hi,
I am trying to automate my backups using pg_dump. However, I am not able to
pass the password to the command. Has anybody sucessfully done automated
backup thru scripts?
Thank you for your comments and suggestions.
Ritesh.
---(end of broadcast)---
In mysql there are two configuration parameters for
limiting connections:
max_user_connections
max_connections
the first limits the number of concurrent connexions
from a same user, is there an equivalent in
postgresql?
Postgresql seems to limit only the total number of
connexi
Sure.
I will attempt this on our development server which only occasionally has
this problem. If that won't reproduce it, I will attempt this on our
production server but that must be scheduled at a slow time - maybe Monday.
I'll send this info. once I've collected it.
Thanks for the help,
L.
find your postgresql.conf file, look in there to make sure tcpip_socket
= true.
the directory that file is in should be the same as the $PGDATA that
your getting asked for, so you'll be able to do
pg_ctl -D /path/to/database status
Robert Treat
On Wed, 2003-02-12 at 09:30, vivek K. wrote:
He
Hi *,
I am still working on the newspaper archive project. I started indexing the
articles with tsearch. Along the long text parts I get a "ERROR: deadlock
detected" when I try to build the index "update dpa_text set
titleidx=txt2txtidx(volltext);". The table has a count of 356437 datarows. I
Hello All,I am getting this error when i am using sql-ledger application. it is giving this error : Error : could not connect to server: Connection refused I have given these values : Host :192.168.168.56 User Name:SQL-ledger Password : SQL-ledger and connect to: Template1
where Template1 is the D
Laurette Cisneros <[EMAIL PROTECTED]> writes:
> When I do a shutdown:
> $pgpath/bin/pg_ctl -D $datadir -m fast stop
> the server will not completely shutdown.
Hm. -m fast tells the postmaster to send SIGTERM to all the existing
backends, and then quit when all the backends have quit. So your
pr
21 matches
Mail list logo
