[EMAIL PROTECTED] ("Simon Riggs") wrote:
> Proactive, planned maintenance is more manageable than sudden,
> grinding failure when you're at home in bed. Make sure your manager
> is part of the call-out plan, thats usually a good way to make them
> care about maintenance.
And regular maintenance al
> S. C.
>
> We have a postgres 7.4 database which never vacuum for 4 months. I try to
> vacuum one time. But my manager can't bear the low performance of
> website. So
> I had to kill the vacuum before it finished. Is it ok for a postgres 7.4
> database never do vacuuming?
>
> We have 10,000 trans
Maybe you already know this but the solution is to create a new
table with varchar(200) copy to it the data from the old one.
Then drop the old one and recreate with varchar(200) then copy
the data back from the tmp table.
Again you probably know all this ,just trying to help...
On Wed, 8 Sep 200
=?ISO-8859-1?Q?M=E1rio_Gamito?= <[EMAIL PROTECTED]> writes:
> Well, postgres then died and now, refuses to start.
> /var/log/pgsql is 0 bytes size :(
You may be using a start script that sends the postmaster's stderr to
/dev/null :-(. You can tweak the script, or change postgresql.conf
to log to
On Wed, 2004-09-08 at 11:02, MÃrio Gamito wrote:
> Hi,
>
> I had this postgres running smoothly.
>
> Then, i've imported the contents of a plain text file, by the book.
> postgres said "COPY".
> Everything seemed ok.
>
> Well, postgres then died and now, refuses to start.
> /var/log/pgsql is 0 b
On Wed, 2004-09-08 at 10:45, Warren Little wrote:
> Hello,
> Does pg7.4.x support resizing a varchar column
> ie varchar(30) -> varchar(200)
No, but some folks have done it by hacking the catalogs. not
recommended, make a backup, etc...
> If not does the feature in 8.0 relating to changing colu
Andrei,
> I have a database, where in the tables I have around 100 constrains (link
> to other tables) that don't have a name "" or they have a name
> like "$1" "$2". Now, I have a module which bases on the same structure, but
> I get some query errors from a "" constraint. I really don't know
> e
Hi,
I had this postgres running smoothly.
Then, i've imported the contents of a plain text file, by the book.
postgres said "COPY".
Everything seemed ok.
Well, postgres then died and now, refuses to start.
/var/log/pgsql is 0 bytes size :(
Any hint how to solve this situation ?
Any help would be ap
Hello,
Does pg7.4.x support resizing a varchar column
ie varchar(30) -> varchar(200)
If not does the feature in 8.0 relating to changing column types support this?
thx
--
Warren Little
Senior Vice President
Secondary Markets and IT Manager
Security Lending Wholesale, LC
www.securitylen
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (k b) wrote:
> Hello.
>
> I have a slightly off topic question.
> Is it possible to set up replication between a mysql
> 3.23.56 server and a postgresql 7.2.4 server without
> any extra software in between?
>
> i am primarily interested
I think it is impossible, unless you use an extra software.because the logfile format
of mysql is different from postgresql's.
- Original Message -
From: "k b" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 08, 2004 8:25 PM
Subject: [ADMIN] replication between mysq
Hello.
I have a slightly off topic question.
Is it possible to set up replication between a mysql
3.23.56 server and a postgresql 7.2.4 server without
any extra software in between?
i am primarily interested in replication from the
mysql server to the postgresql server, but two way
replication mi
12 matches
Mail list logo
