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
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;
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)
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 compare some body PostgreSQL against ms-sql
server
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
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 logsto another disk space in case of a disk
filled up?
Many
Thanks
Kevin
I'm having
difficulties to restore backup made on postgresql7.3 on machine running
7.2. Is there any way how to accomplish this?
Thanx
Martin
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
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
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
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:
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.
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
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
15 matches
Mail list logo