One way is to do this is by configuring the remote server to trust the host
that is going to be doing the back up. This can be done in the pg_hba.conf
file which is located in "/var/lib/pgsql/data" on my server.
If the Server that is going to be doing the back up has the IP address of say
192.16
Title: SQL date calculation problem
Hi all,
I using postgresql 7.1.3 on RH 7.2 server. I am having trouble with
TIMEDATE calculation using the pgplsql procedural language the logic
is has follows:
FOR r IN SELECT time_span FROM t WHERE name = ''NEW'' LOOP
NEW.end_date := r.time_span + n
Title: TIMEDATE calculation
Hi all,
I using postgresql 7.1.3 on RH 7.2 server. I am having trouble with
TIMEDATE calculation using the pgplsql procedural language the logic is
has follows:
FOR r IN SELECT time_span FROM t WHERE name = ''NEW'' LOOP
NEW.end_date := r.time_span + now();
END LOOP;
Title: Re: [ADMIN] Password recover
I had the same problem a while a go the way I fixed was like this:
Log in has root user on the server.
Swith to postgres user "su postgres"
Make a back up of your pg_hda.conf file. On RH this is in
/var/lib/pgsql/data
Alter the pg_hda.conf to trust al
Title: Re: [ADMIN] time stamp
Interesting point.
Original Message dated 21/06/02, 4:31:39
Author: Felipe Nascimento
<[EMAIL PROTECTED]>
Re: Re: [ADMIN] time stamp :
I used to manage a database without Time Zone. Now I
use PG, and this concept of using Time Zone in date data is new to me.
In postgres you the plsql equivalent is 'plpgsql' not 'plsql'.
>> Original Message <<
On 3/05/02, 21:17:38, "jquest jquest" <[EMAIL PROTECTED]> wrote
regarding [ADMIN] Trigger problem:
> Hi,
> I am new to postgresql and to this moment I am using oracle.
> I use
;Rollback' (AKA undo)
buttons, coding becomes more expensive and I am suspected to more
coding errors do to unnecessary complexity. Has any one any experience
with FCGI and Postgresql am I writing to the wrong mailing list?
Aaron Spiteri
I want to upgrade postgreql from version 6.5 to version 7.2.1 on a Debian
2.2 potatoe server has anyone had any experience with this.
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
I am having some trouble with a PL/SQL script I have been trying to
write. The idea is that a table is created called user_table, This
stores extra information about each user on the system. There is a link
in the user_table called usename which links up to pg_shadow.username. I
want to be
Hello all,
If any one knows of any Postgresql conferences coming up in Australia
could they please let me know the details.
Aaron.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
10 matches
Mail list logo