"Jay Hodges" <[EMAIL PROTECTED]> writes:
> Now that my database is becoming quite large, it has outgrown the /var/ par=
> ition and I would like to move at least one database to /usr partition, or =
> to a NFS.
> can this be done easily, and if so, what would be the procedure to move the=
> files
I have a problem. I installed PostgreSQL, RH
6.1 and it put the database files in /var/lib/pgsql, there also exists
/usr/lib/pgsql that is not being used.
Now that my database is becoming quite large, it
has outgrown the /var/ parition and I would like to move at least one database
to /us
[EMAIL PROTECTED] writes:
>Dear Mike,
>
>I am trying to create the user but it was giving folllowing errors
>
>[postgres@ns data]$ su siddharta
>su: user siddharta does not exist
>
>This is how I created the user
>
>[postgres@ns data]$ createuser siddharta
>Enter
[EMAIL PROTECTED] writes:
>Dear Mike,
>
>I am trying to create the user but it was giving folllowing errors
>
>[postgres@ns data]$ su siddharta
>su: user siddharta does not exist
>
>This is how I created the user
>
>[postgres@ns data]$ createuser siddharta
>Enter
Peter,
I agree with Tom that it isn't the best solution to have to store a
user/pass in a cron script, but sometimes things have to be done for a
greater purpose. I still have to fiddle with how local ident would work
in my own situation, but the current solution I have is the followi
"Peter Schuller" <[EMAIL PROTECTED]> writes:
> I do have a question though. Contrary to Grant, I can't use a trust policy,
> even on the local machine. As a result, I need to use password
> authentication. However, pg_dumpall seems to generally screw up.
pg_dumpall is very unfriendly to password
Dear Mike,
I am trying to create the user but it was giving folllowing errors
[postgres@ns data]$ su siddharta
su: user siddharta does not exist
This is how I created the user
[postgres@ns data]$ createuser siddharta
Enter user's postgres ID -> 567
Is user
Peter Schuller <[EMAIL PROTECTED]> wrote:
>Contrary to Grant, I can't use a trust policy, even on the local machine.
>As a result, I need to use password authentication. However, pg_dumpall
>seems to generally screw up.
>Is there something obvious I'm doing wrong?
No. pg_dumpall wasn't written w
Try the copytruncate directive in the logrotate configuration file. (See 'man
logrotate'). This should allow it to work without restarting postgresql. But as the
man file says, there is a small chance of losing some log entries.
On Wed, Mar 07, 2001 at 10:37:30AM -0500, root wrote:
> Be sure
Hello,
> From what I understand (and I'm still fairly new to Postgres) you won't get
> a perfect copy while Postmaster is running, but there is a way to backup the
> entire database while it's running: pg_dumpall.
Ah, perfekt! And thanks to Grant for that bash script :)
I do have a question tho
10 matches
Mail list logo
