Hi,
> Why would you want to do that?
>
> Why not do it an easier way and dump the database and restore it into
> your new database?
>
> There's got to be a lot of stuff to consider when doing something as
> radical as renaming a database.
He is not talking about renaming his database, he is talki
Hello,
You really don't want to do this. 7.3.x is much more stable,
offers better support for various things and handles load much better.
If you need a 7.3.x host look at (plug) www.commandprompt.com
or even phHoster.com
J
Ian Barwick wrote:
On Tuesday 15 July 2003 09:51, Stefan Armbruster wr
I've encountered this a few times with 7.2 and 7.3.
If I do pg_dump of some large (> 100Mb - the bigger the more likely)
database, and it gets interrupted for some reason (e.g. the target disk
fills up), the source database become corrupt. I start getting errors
like:
open of /var/lib/pgsql/data/
Ron Johnson <[EMAIL PROTECTED]> writes:
> $ pg_dump -Ft -v test1 | gzip > test1.pdmp.tar.gz
> pg_dump: saving database definition
> pg_dump: reading namespaces
> pg_dump: reading user-defined types
> [snip]
> pg_dump: dumping contents of table t_lane_tx2
> pg_dump: dumping contents of table t_lane_
On Wed, Aug 06, 2003 at 03:06:12PM +0100, Jan Oksfeldt Jonasen wrote:
> At 01:40 PM 8/6/2003, Peter Eisentraut wrote:
> >You need to double-quote the names or they will be converted to lower
> >case.
> >
>
> Thank you both. The reason why the initial table creation have quoted
> columns names is
> > If you could replicate/rsync pg_xlog to another machine, you could get
it
> > correctly in case of failover.
>
> Argh.. I forgot.. Simple option is to sync the pg_xlog while doing
failover. It
> might add some 10 odd sec to failover process but should be bullet proof..
>
> I don't know if PG i
Hi All,
I updated postgre from 7.2.4 to 7.3.2 in my RHLinux7.3 system and updated
current pghba.conf and postgresql.conf files as per my need. But If I try to
connect through PHP which was connecting earlier with 7.2.4 is giving the
following error
Fatal error: Call to undefined function: pg_conn
On Wed, 6 Aug 2003, Peter Eisentraut wrote:
> scott.marlowe writes:
>
> > Do we need official permission to call the language plPHP by the way?
>
> Can someone explain to me why language handler modules for PostgreSQL are
> always called "PL/Language"? Consider if someone wrote a language binding
Don't know the answer to your question, but I thought I would just pipe
in and say that if this is an SMP (has multiple processors) Linux box
you don't want to use ext3!!!
I used ext3 on my SMP box here at work and now I can't have children (I
guess it would help if I got a wife first)!!
But i
We recently started using daemontools to manage the herd of postmasters (see
the recent thread regarding running multiple postmasters on a single
machine), and its working quite well.
We still have to figure out how to mimic the
"pg_ctl stop -m fast|immediate" modes,
svc -d /service/ mimics "pg_c
Hi,
v7.3.3
$ pg_dump -Ft -v test1 | gzip > test1.pdmp.tar.gz
pg_dump: saving database definition
pg_dump: reading namespaces
pg_dump: reading user-defined types
[snip]
pg_dump: dumping contents of table t_lane_tx2
pg_dump: dumping contents of table t_lane_tx
pg_dump: [tar archiver] could not writ
Bad form to reply to my own posting i know but -
I notice that the integer dictionary can accept MAXLEN for the longest
number that is considered a valid integer. Can i set MAXLEN for the en
dictionary to be the longest word i want indexed?
I think i'd need to create a new dictionary...?
>
On Wed, Aug 06, 2003 at 11:28:23 -0300,
Kolus Maximiliano <[EMAIL PROTECTED]> wrote:
>
> I'm about to install postgres on a box that has daemontools on it
> and I would like to use it. Is there anybody here already running postgres
> from daemontools? Is it advisable? Do you have any probl
You are correct Tom, vtquotehistory is a view of tquotehistory, and I am
trying to log in this example. Sorry I didn't point that out. The view is a
straight view with no WHERE clause or criteria of any kind. The UPDATE does
cause the OLD record to become updated to whatever changes have been set a
On 6 Aug 2003 at 14:34, Jan Oksfeldt Jonasen wrote:
> Hi,
> I'm a very new user of the PostgreSQL database, but I've quickly
> encountered what I consider an pretty odd error. Let it be said, this is
> using the PeerDirect PostgreSQL Beta 4 using Win2K SP3, so it's bound to
> have certain issue
On Tue, Aug 05, 2003 at 21:00:53 -0300,
The Hermit Hacker <[EMAIL PROTECTED]> wrote:
>
> Just a quick note to everyone that v7.4 is now official in Beta Freeze,
> with the first Bundle available for download, testing and bug reports ...
http://developer.postgresql.org/beta.php doesn't point to
I am trying to setup tsearch2 on postgresql 7.3.4 on a Redhat9 system,
installed from rpms.
There seemed to be some files required for installation of tsearch
missing so I downloaded the src bundle too.
Tsearch2 then compiled ok but now the command:
psql mydb < tsearch2.sql
fails with a messa
mmm... I don't understand. The query brings a resultset just like the one you asked.
When you say that 'there's no guarantee that A field is sorted or unique...', what do you mean? The query doesn't care about the "A" field, it just needs "UID" to be a candidate key.
And I still don't und
18 matches
Mail list logo
