Perhaps it's my "test for DB ready" that's the problem?
This is the typical glitch I get ...
+ mkdir -p /persist/pgdata
+ chmod 700 /persist/pgdata
+ initdb -Atrust -Upmx -L/persist/pgsql/8.0.9/share >/dev/null
+ cp -p /persist/etc/p*g*.conf /persist/pgdata
+ chmod u+w /persist/home/mischa/pgdata/
Comment below:
Joshua D. Drake wrote:
> On Sat, 2008-11-15 at 12:29 -0800, Mischa Sandberg wrote:
>> Quoting "H. Hall" <[EMAIL PROTECTED]>:
>>> Mischa Sandberg wrote:
>>>
I've been trying to work out a reliable script to determine,
after pg_ctl start, that the server is done atte
"Anony Mous" <[EMAIL PROTECTED]> writes:
> I have a moderate size database under RH9 / pgsql 7.3 (I think... that's the
> PG_VERSION in the postgres user data directory.) Under 100 mb for the whole
> thing.
> I'm trying to move the DB to postgresql 8.3 under the current ubuntu in a
> 4-core, 4gb m
An interesting suggestion, but the problem with storing the logfiles in
a table for us would be that uncompressed, the log file for a day is
about 10 gigs. This would mean that an unacceptable amount of excess
data would accumulate in the database. It would be feasible however to
write a script
Arrrghhh, it was was actually 10 (not that it really makes any
difference), should have actually waited for file to unzip before posting!!!
Ben Webber wrote:
Sorry, meant 2 gigs, not 10.
An interesting suggestion, but the problem with storing the logfiles in
a table for us would be that uncomp
Sorry, meant 2 gigs, not 10.
An interesting suggestion, but the problem with storing the logfiles in
a table for us would be that uncompressed, the log file for a day is
about 10 gigs. This would mean that an unacceptable amount of excess
data would accumulate in the database. It would be feasibl
Ben Webber wrote:
> Hi,
>
> I wrote a shell script to find the duration and the related statement in the
> log file and place them one after the other if the duration is over a
> specified time like this:-
>
> 2008-10-31 02:00:49 GMT [23683] [mp_live] LOG: statement: CLUSTER;
> 2008-10-31 02:04:
I have a moderate size database under RH9 / pgsql 7.3 (I think... that's the
PG_VERSION in the postgres user data directory.) Under 100 mb for the whole
thing.
I'm trying to move the DB to postgresql 8.3 under the current ubuntu in a
4-core, 4gb machine. postgresql appears to be installed and work
Hi,
I wrote a shell script to find the duration and the related statement in the
log file and place them one after the other if the duration is over a specified
time like this:-
2008-10-31 02:00:49 GMT [23683] [mp_live] LOG: statement: CLUSTER;
2008-10-31 02:04:42 GMT [23683] [mp_live] LOG: d
On Oct 10, 7:40 pm, [EMAIL PROTECTED] (Alvaro Herrera) wrote:
> Jagadeesh escribió:
>
> > HI,
>
> > how can I invoke editor like vim from postgres? This helps me in
> > editing large and complex queries.
>
> Use \e, and make sure EDITOR is set to the editor of your preference.
>
> --
> Alvaro Herre
is there any way to delete records based on condition? something
similar to truncate cascade;
I tried delete where id=12 cascade;
but didn't work. I am not thinking of changing the constraint to 'on
delete'
Thanks
Jagadeesh
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
T
Hello,
we're going to switch from mysql (ver. 5.0.26) to PostgreSQL (OS:
opensuse 10.3).
The mysql database includes several instances, and we only want to
migrate the bugzilla instance to Postgres (yes, it's the bugzilla
backend...).
What are the preferred steps to perform this migration ? ("cost
12 matches
Mail list logo
