On Tue, 20 Oct 1998, Peter T Mount wrote:
> > Message:Connection failed: java.net.ConnectException: Connection refused
>
> This seems to be the most common problem ;-)
>
> You are not running the backend with the -i arg, which turns on tcp/ip.
Thank you. Two characters more and everything work
On Wed, 19 Aug 1998, Marc Howard Zuckman wrote:
>
> On Wed, 19 Aug 1998, Przemyslaw Bak wrote:
>
> > Hi all,
> >
> > I have following script to backup database:
> > - cut --
> > #!/bin/sh
> >
> > PSQL=/usr/local/pgsql/bin/ps
Hi all,
I have following script to backup database:
- cut --
#!/bin/sh
PSQL=/usr/local/pgsql/bin/psql
DUMP=/usr/local/pgsql/bin/pg_dump
PREFIX=`date +%j`
BACKUP_DIR=/usr/local/pgsql/data/base/.BACKUP
Databases=`$PSQL -tq -d template1 -c "select datname from pg_database"`
renice
Hi,
I sent a few e-mail's to the discussion list but I havent't
got any response. Could you tell me if you received any
of my e-mail's (I asked about inner and outer join).
Regards
przemol
Hello
could you explain me (Postgres 6.3.2):
/home/przemol> psql store3
store3=> create user pos;
ERROR: defineUser: user "pos" has already been created
store3=> drop user pos;
NOTICE: Dropping database store3
ERROR: destroydb cannot be executed on an open database
store3=>
I don't understand
Hi all,
Tell me first if it is correct group for that kind of questions.
If it is not tell me which group.
So question:
what does "resetting connection" mean while loading huge
number of data into postgres. I have postgres 6.1
And second question:
while migrating from 6.1 to 6.3.2 do I have to
Hi,
every night my script (using perl) will load about 50.000 rows of
data into Postgres. I know two ways:
In first version of my script I used method by inserting, eg:
-- cut --
#!/bin/perl
use Pg;
open (MyData, "...");
while () {
chop;
...
&insert_cust_sales ($NDate, $C
