pg_dump is fine, in fact better. For a file system backup, you have to
stop the postmaster, backup, then restart it.
---
Ganesan Kanavathy wrote:
> Please help me with question. So far no replies.
>
> Regards,
> ganesh
>
Please help me with question. So far no replies.
Regards,
ganesh
-Original Message-
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ganesan Kanavathy
Sent: Friday, October 17, 2003 5:14 PM
To: [EMAIL PROTECTED]
Subject: [ADMIN] File system level
backup
De
Please help me with question. So far no replies.
Regards,
ganesh
-Original Message-
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ganesan Kanavathy
Sent: Friday, October 17, 2003 5:14 PM
To: [EMAIL PROTECTED]
Subject: [ADMIN] File system level
backup
De
Hi, I have a big trouble.
I made an application in VB and used as the reporter tool "Crystal Reports".
The access to my DB is authenticated every time the user does a query
by setting "password" in the pg_hba.conf file, so every time the user has to
query the data my program sends the user
Rhaoni Chiu Pereira kirjutas E, 20.10.2003 kell 17:13:
> Hi List,
>
>I got a P4 1.7Ghz , 512MB RAM , HD 7200 RPM, on RED HAT 9 running PostgreSQL
> 7.3.2-3 Database.
>I have a Delphi aplication that updates the Oracle database using .dbf
> file's information ( converting the data from t
> [EMAIL PROTECTED]:database $
>
=> \set PROMPT1 '[EMAIL PROTECTED]:%/ $' -- Refer psql manual for details
regards,
bhuvaneswaran
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomai
Rhaoni,
> My problem is that I must substitute this Oracle for a PostgreSQL
> database and this same Delphi aplication takes 45 min to update Jan/2003.
> All delphi routines are converted and optmized to work with PgSQL.
Obviously not.
How about posting the update queries?
--
Josh
On Tue, 21 Oct 2003, dotaku wrote:
> scott.marlowe wrote:
>
> >On Mon, 20 Oct 2003, dotaku wrote:
> >
> >
> >
> >>Hi all..
> >>
> >>i've got a problem with the memory that postgresql 7.3.2 used in RedHat 9.
> >>When the memory usage reached 80% or more of the total memory in the
> >>system..
>
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Tue, Oct 21, 2003 at 09:31:49PM +0800, dotaku wrote:
> Thanks...but can I flush a postgreql server unused memory after stopping
> it. The problem that i had is that, even after stopping all postgresql
> services...the used memory is still more than 80% of the total RAM..
It sounds like you'r
> Thanks...but can I flush a postgreql server unused memory after stopping
> it. The problem that i had is that, even after stopping all postgresql
> services...the used memory is still more than 80% of the total RAM..
>
> any idea how to flush it. I've read somewhere about kflushd and
> bdflushd.
scott.marlowe wrote:
On Mon, 20 Oct 2003, dotaku wrote:
Hi all..
i've got a problem with the memory that postgresql 7.3.2 used in RedHat 9.
When the memory usage reached 80% or more of the total memory in the
system..
the memory just keep stuck there..The thing did not reduce bt itself...
T
Dear all,
How are the connection requestion handled in postgres. Is it different with different
operating systems. And how can I know the number of open connections in windows.
-
Warm Regards
Shÿam Peri
II Floor, Punja Building,
M.G.Road,
Ballalbagh,
Mangalore-575003
Ph : 91-824-2451001/5
Dear all,
How are the connection requestion handled in postgres. Is it different with different
operating systems. And how can I know the number of open connections in windows.
-
Warm Regards
Shÿam Peri
II Floor, Punja Building,
M.G.Road,
Ballalbagh,
Mangalore-575003
Ph : 91-824-2451001/5
16 matches
Mail list logo
