Hello,
Here I'm implementing a session management, which has a connections table
partitioned between
active and archived connections. A connection represents a connection
between a user and a chatroom.
I use partitioning for performance reasons.
The active table contains all the data for the a
eral
mailing list"
e.com> cc:
Sent by:
st"
> e.com> cc:
>
> Sent by: Subject: [GENERAL] MOVE
>
> [EMAIL PROTECTED]
On Fri, Jan 14, 2005 at 08:49:24PM +0100, PFC wrote:
> the auto-expiration cron
> job, I must also expire ALL his open chatroom connections.
> INSERT INTO archive (...) SELECT ... FROM active WHERE user_id = ...;
> DELETE FROM active WHERE user_id = ...;
>
> Now, if the user inserts a connection b
Martijn van Oosterhout writes:
> Why not just do it in a single transaction? I don't think you need to
> use SERIALIZABLE at all, I think normal read-committed mode will do
> what you want, no?
> BEGIN;
> INSERT INTO archive (...) SELECT ... FROM active WHERE user_id = ...;
> DELETE FROM active W
BEGIN;
INSERT INTO archive (...) SELECT ... FROM active WHERE user_id = ...;
DELETE FROM active WHERE user_id = ...;
COMMIT;
The DELETE can only delete the rows returned by the select, that's the
whole point of transactions...
Well, in the case of having a unique index on user_id, and if no-one
Use an after inset trigger.
Well I did the reverse, an after delete trigger on the live table which
inserts the deleted row in the history table, and it works very well.
Thanks.
---(end of broadcast)---
TIP 9: the planner will ignore your desire
Title: iterate over refcursor
hi
i need
to use the MOVE function on a cursor, for extracting special
rows.
the
function is written in pl/pgSQL
CREATE
OR REPLACE FUNCTION TEST() RETURNS void AS
$$DECLARE
childCursor CURSOR FOR select
* from ... childRecord
adoc.xdb_c
-Message d'origine-
> De : Michael Fuhr [mailto:[EMAIL PROTECTED]
> Envoy? : mardi 8 mars 2005 18:29
> ? : Tom Lane
> Cc : FERREIRA William (COFRAMI); pgsql-general@postgresql.org
> Objet : Re: [GENERAL] Move cursor
>
>
> On Tue, Mar 08, 2005 at 12:16:28PM -0500,
On Tue, Mar 08, 2005 at 04:23:37PM +0100, FERREIRA William (COFRAMI) wrote:
> i need to use the MOVE function on a cursor, for extracting special rows.
> the function is written in pl/pgSQL
I don't think PL/pgSQL implements cursors fully. In particular,
I don't see MOVE in the PL/pgSQL parser; I
Michael Fuhr <[EMAIL PROTECTED]> writes:
> I don't think PL/pgSQL implements cursors fully.
Its cursor facility is certainly far weaker than what's presently in the
main SQL language. I think this is at least partly historical accident
(ie we upgraded the main language and forgot about plpgsql).
On Tue, Mar 08, 2005 at 12:16:28PM -0500, Tom Lane wrote:
> Michael Fuhr <[EMAIL PROTECTED]> writes:
> > I don't think PL/pgSQL implements cursors fully.
>
> Its cursor facility is certainly far weaker than what's presently in the
> main SQL language. I think this is at least partly historical ac
Title: RE: [GENERAL] Move cursor
does i hope that CURSOR will be fully implemented soon ?
(or maybe you know an alternative for my problem ? :) )
-Message d'origine-
De : Michael Fuhr [mailto:[EMAIL PROTECTED]]
Envoyé : mardi 8 mars 2005 18:29
À : Tom Lane
Cc : FERREIRA Wi
Hi all,
Is there a way to move a cursor in plpgsql in the same way as in
regular sql? The function below would like to move the cursor back to
the start each time the cursor runs out of rows, creating pairs of
integers that are randomly put together.
The "motivation" for this is to randomly ass
hello,
my postgresql installation from redhat package:
$ rpm -q postgresql
postgresql-7.4.17-1.RHEL4.1
is located in /var partition, unfortunalty it is nearly full
$ df -H .
Filesystem Size Used Avail Use% Mounted on
/dev/sda12 11G 8.2G 1.7G 84% /var
How can I te
Op 19 Aug 2003 (15:35), schreef The Hermit Hacker <[EMAIL PROTECTED]>:
> On Tue, 19 Aug 2003, Jules Alberts wrote:
>
> > Hello everyone,
> >
> > This is not a troll and I certainly don't want to start a holy war but
> > wouldn't it be a good idea to move the postgresql lists from the
> > mailing l
On Wed, 20 Aug 2003, Jules Alberts wrote:
> Op 19 Aug 2003 (15:35), schreef The Hermit Hacker <[EMAIL PROTECTED]>:
> > On Tue, 19 Aug 2003, Jules Alberts wrote:
> >
> > > Hello everyone,
> > >
> > > This is not a troll and I certainly don't want to start a holy war but
> > > wouldn't it be a good
On Tuesday 19 Aug 2003 15:43 in <[EMAIL PROTECTED]>, Chris M
([EMAIL PROTECTED]) wrote:
> I use outlook express to visit news.postgresql.org now.
> It works well.
Thank you for top-posting and full-quoting, just to prove my point. ... :-)
--
Regards,
Dave [RLU#314465]
On Tuesday 19 Aug 2003 09:06 in
<[EMAIL PROTECTED]>, Jules Alberts
([EMAIL PROTECTED]) wrote:
> This is not a troll and I certainly don't want to start a holy war but
> wouldn't it be a good idea to move the postgresql lists from the
> mailing list approach to usenet?
I don't know about anybody e
> -Original Message-
> From: David W Noon [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 19, 2003 4:20 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] move to usenet?
>
> I agree that many messages are not formatted according to Usenet
> conventions, but I
From: David W Noon [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 19, 2003 4:20 AM
To: [EMAIL PROTECTED]
Subject: Re: [GENERAL] move to usenet?
I agree that many messages are not formatted according to Usenet
conventions, but I normally attribute that to Windows users who know
nothing abou
On Wed, 20 Aug 2003 14:44:28 -0700 David Olbersen <[EMAIL PROTECTED]> wrote:
> What is the point of bottom posting anymore? I thought it had to do with
> turn-around time so that you could re-read whatever it is you wrote a
> "long time ago". I highly doubt you would know, but is there an easy way
> > On Tue, 19 Aug 2003, Jules Alberts wrote:
> >
> > > This is not a troll and I certainly don't want to start a holy war but
> > > wouldn't it be a good idea to move the postgresql lists from the
> > > mailing list approach to usenet? IMHO it's more open and easier to work
> > > with. As it is
In response to "Jules Alberts":
> This is not a troll and I certainly don't want to start a holy war but
> wouldn't it be a good idea to move the postgresql lists from the
> mailing list approach to usenet? IMHO it's more open and easier to
> work with. As it is now, there are some postgreql usenet
Oh the irony.
"Chris M" <[EMAIL PROTECTED]> writes:
> I use outlook express to visit news.postgresql.org now.
> It works well.
>
> "David W Noon" <[EMAIL PROTECTED]>
> news:[EMAIL PROTECTED]
> > On Tuesday 19 Aug 2003 09:06 in
> > <[EMAIL PROTECTED]>, Jules Alberts
> > ([EMAIL PROTECTED]) wrote
Dennis Gearon wrote:
> I prefer NOT to have to scroll down to the bottom of an email anyway. I
> think discussion list emails like ours need to be like your medical
> records, the most important, recent stuff is at the top.
I do often top-post, and I didn't realize it was an issue until this
wee
Hee Hee, but I _**LIKE**_ top quoting.
Greg Stark wrote:
Oh the irony.
"Chris M" <[EMAIL PROTECTED]> writes:
I use outlook express to visit news.postgresql.org now.
It works well.
"David W Noon" <[EMAIL PROTECTED]>
news:[EMAIL PROTECTED]
On Tuesday 19 Aug 2003 09:06 in
<[EMAIL PROTECTE
On Tue, 2003-08-26 at 08:40, Dennis Gearon wrote:
> Hee Hee, but I _**LIKE**_ top quoting.
That's good. Top-quoting is good.
Top posting, on the other hand, is bad. It's also what you did.
Stephen
--
Stephen Robert Norris <[EMAIL PROTECTED]>
CommSecure Australia Pty Ltd
-
Robert L Mathews wrote:
> At 8/26/03 12:56 AM, Bruce Momjian <[EMAIL PROTECTED]> wrote:
>
> >I do often top-post, and I didn't realize it was an issue until this
> >week. I usually top-post when I need to make a comment on the entire
> >email, like "Is there a TODO here?", "patch applied", or som
> Hi all,
>
> Is there a way to move a cursor in plpgsql in the same way as in
> regular sql? The function below would like to move the cursor back to
> the start each time the cursor runs out of rows, creating pairs of
> integers that are randomly put together.
>
> The "motivation" for this is
> Is there a way to move a cursor in plpgsql in the same way as in
> regular sql? ...
Wouldn't it be easier to list the parts in a random order (simply ORDER
BY RANDOM()) and then use modulo by number of actors (but there's no
ROWNUM so a loop is needed anyway). Something like...
I think you a
jehan.procaccia wrote:
my postgresql installation from redhat package:
$ rpm -q postgresql
postgresql-7.4.17-1.RHEL4.1
is located in /var partition, unfortunalty it is nearly full
$ df -H .
Filesystem Size Used Avail Use% Mounted on
/dev/sda12 11G 8.2G 1.7G 84% /v
Richard Huxton wrote:
jehan.procaccia wrote:
my postgresql installation from redhat package:
$ rpm -q postgresql
postgresql-7.4.17-1.RHEL4.1
is located in /var partition, unfortunalty it is nearly full
$ df -H .
Filesystem Size Used Avail Use% Mounted on
/dev/sda12 11
Please forgive me if this question is being asked in the wrong area (and
please suggest the proper one so I can ask there :-) ), but I'm in search of
assistance in moving a database from a Solaris system over to a Windows
system.
Solaris 5.8, postgreSQL 8.01, to Windows Server 2003, postgreSQL 8.0
Hi,I would like to know how can i move from 1 database to another one ?basically i want to run a *.sql script in which i connect under a particular database (for example : template1 or postgres) and my *.sql script should create a new database (for example : test) and after execute several SQL comm
Hi,
What file should I be working with?
Thanks in advance / Jennifer
Dear Postgresql experts,
According to the documentation for MOVE, it returns the number of rows
that it has moved over. It seems to me that this is true for MOVE
FORWARD n, but not for MOVE RELATIVE n or MOVE ABSOLUTE n when it always
returns 1:
db=> declare c scroll cursor for select * from p
esday, August 01, 2007 3:35 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Move database from Solaris to Windows
On Aug 1, 2007, at 11:44 AM, Barry C Dowell wrote:
> Please forgive me if this question is being asked in the wrong area
> (and please suggest the proper one so I can a
On Aug 1, 2007, at 2:34 PM, Steve Atkins wrote:
On Aug 1, 2007, at 11:44 AM, Barry C Dowell wrote:
Please forgive me if this question is being asked in the wrong
area (and
please suggest the proper one so I can ask there :-) ), but I'm in
search of
assistance in moving a database from a So
On Aug 1, 2007, at 11:44 AM, Barry C Dowell wrote:
Please forgive me if this question is being asked in the wrong area
(and
please suggest the proper one so I can ask there :-) ), but I'm in
search of
assistance in moving a database from a Solaris system over to a
Windows
system.
Solaris
ral@postgresql.org
Subject: Re: [GENERAL] Move database from Solaris to Windows
On Aug 1, 2007, at 2:34 PM, Steve Atkins wrote:
>
> On Aug 1, 2007, at 11:44 AM, Barry C Dowell wrote:
>
>> Please forgive me if this question is being asked in the wrong area
>> (and please sugge
On 8/2/07, Barry C Dowell <[EMAIL PROTECTED]> wrote:
> Ok, if you can forgive the possible stupid answer and help pull me a long a
> bit more, in answer to this:
>
> >> Yes, dump/restore is pretty much the standard to move dbs across
> architectures so we'll need more to work with. One thing to ch
ipate more.
Bcd
-Original Message-
From: Barry C Dowell [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 01, 2007 4:40 PM
To: 'pgsql-general@postgresql.org'
Subject: RE: [GENERAL] Move database from Solaris to Windows
Ok, if you can forgive the possible stupid answer and help p
Hi all,
short of issuing single commands for each table is there a way to move
the an entire schema to a new tablespace, indices and all?
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an i
On May 25, 2006, at 1:52 PM, P.M wrote:
I would like to know how can i move from 1 database to another one ?
basically i want to run a *.sql script in which i connect under a
particular database (for example : template1 or postgres) and my
*.sql script should create a new database (for examp
On Thu, May 25, 2006 at 05:41:34PM -0500, Jim Nasby wrote:
> On May 25, 2006, at 1:52 PM, P.M wrote:
> >I would like to know how can i move from 1 database to another one ?
> >
> >basically i want to run a *.sql script in which i connect under a
> >particular database (for example : template1 or
On fim, 2006-05-25 at 11:52 -0700, P.M wrote:
> I would like to know how can i move from 1 database to another one ?
>
> basically i want to run a *.sql script in which i connect under a
> particular database (for example : template1 or postgres) and my *.sql
> script should create a new database
Thanks.it works well.Ragnar <[EMAIL PROTECTED]> wrote: On fim, 2006-05-25 at 11:52 -0700, P.M wrote:> I would like to know how can i move from 1 database to another one ?> > basically i want to run a *.sql script in which i connect under a> particular database (for example : template1 or postgres)
Hi,
we have encountered huge memory problems (segfault on 8.4.2, out of
memory on 8.4.3) with our xml functions when moving from 8.3 to 8.4, as
mentioned here:
http://archives.postgresql.org/pgsql-general/2010-03/msg00563.php
We think about moving from contrib/xml2 to the core xml support.
B
Just a little background:
We're running Red Hat Satellite Server and it's used to provision our
servers (both physical and virtual). It works great and we have no issues
with it *except* It will only provision Red Hat.
Why this question:
We've been directed by our management to examine the
Hi,
I'm getting a new notebook and want to confirm that my idea on how to move my
Postgres installation will work This is a development/test installation and not
a production system, so it doesn't need to be 100% fail safe.
Both systems are Windows XP 32bit.
My plan was to install the same PG
Jennifer Trey wrote:
> Hi,
> What file should I be working with?
Just shut down the server and move the directory whever you want and
restart the server. There are no file contents that need changing. Of
course should adjust your scripts or PGDATA environment variable.
--
Bruce Momjian
Ook.. thats what I wanted to know. I figured there has to be a place to
change the pointer to the new location of the data.
Thank you / Jennifer
On Thu, Jun 4, 2009 at 6:11 PM, Bruce Momjian wrote:
> Jennifer Trey wrote:
> > Hi,
> > What file should I be working with?
>
> Just shut down the serv
Probably you do not have any script to start PostgreSQL, but it is started
as a service.
The data directory is a parameter of the service within services.msc, there
is
... pg_ctl.exe ... -D "":\your\directory"
Read up on pg_ctl --help how to change this information
(pg_ctl --register)
Best wish
On Thu, Jun 04, 2009 at 11:11:29AM -0400, Bruce Momjian wrote:
> Jennifer Trey wrote:
> > Hi,
> > What file should I be working with?
>
> Just shut down the server and move the directory whever you want and
> restart the server. There are no file contents that need changing.
> Of course should ad
David Fetter wrote:
On Thu, Jun 04, 2009 at 11:11:29AM -0400, Bruce Momjian wrote:
Jennifer Trey wrote:
Hi,
What file should I be working with?
Just shut down the server and move the directory whever you want and
restart the server. There are no file contents that need changing.
Of course sho
On 2009-06-05, David Fetter wrote:
> On Thu, Jun 04, 2009 at 11:11:29AM -0400, Bruce Momjian wrote:
>> Jennifer Trey wrote:
>> > Hi,
>> > What file should I be working with?
>>
>> Just shut down the server and move the directory whever you want and
>> restart the server. There are no file conten
I'm storing vector map attribute data in postgres tables and somehow
managed to create two databases (of similar names) rather than one. I want
to combine the two.
For tables that exist in the one database I want to eliminate, I thought
to use pg_dump to create .sql files, then use pg_resto
Phil Endecott <[EMAIL PROTECTED]> writes:
> According to the documentation for MOVE, it returns the number of rows
> that it has moved over.
That's a documentation bug. CVS tip has the correct explanation:
The count is the number of rows that a FETCH command with the same
parame
Hello, I have to move all the data in my actual server to the new one.
I have several databases in postgresql, and I'd like to know the best way to
move them.
I thoung that maybe copying all the data directory... but I'm not sure, and I
don't know where it's stored.
I'd apreciate your help.
Than
On 10/9/07, Rhys Stewart <[EMAIL PROTECTED]> wrote:
> Hi all,
> short of issuing single commands for each table is there a way to move
> the an entire schema to a new tablespace, indices and all?
I'm pretty sure you're gonna have to write a short pl/pgsql script to do that.
--
Frank jansen wrote:
> Hi,
>
> we have encountered huge memory problems (segfault on 8.4.2, out of
> memory on 8.4.3) with our xml functions when moving from 8.3 to 8.4, as
> mentioned here:
> http://archives.postgresql.org/pgsql-general/2010-03/msg00563.php
>
> We think about moving from contr
Am 15.03.2010 22:10, schrieb Bruce Momjian:
Frank jansen wrote:
Hi,
we have encountered huge memory problems (segfault on 8.4.2, out of
memory on 8.4.3) with our xml functions when moving from 8.3 to 8.4, as
mentioned here:
http://archives.postgresql.org/pgsql-general/2010-03/msg00563.php
Frank jansen writes:
> Am 15.03.2010 22:10, schrieb Bruce Momjian:
>> We have fixed the serious bugs in /contrib/xml2 with the minor releases
>> that came out today, 2010-03-15.
>>
> As already said: "out of memory on 8.4.3" (the script consumes up
> machines memory till it dies)
You were alrea
On Mon, 2011-03-14 at 14:43 -0400, gene.po...@macys.com wrote:
> We're running Red Hat Satellite Server and it's used to provision our
> servers (both physical and virtual). It works great and we have no
> issues with it *except* It will only provision Red Hat.
>
> Why this question:
>
> We
On Mon, Mar 14, 2011 at 02:43:17PM -0400, gene.po...@macys.com wrote:
> Is there a recent tutorial, white paper, how to on move/migrate from
> Oracle to PostgreSQL? I can get the Oracle schema DDL by pointing our
> Data Modeling software at the Red Hat Satellite server and extracting the
> DDL
Gene,
* gene.po...@macys.com (gene.po...@macys.com) wrote:
> Is there a recent tutorial, white paper, how to on move/migrate from
> Oracle to PostgreSQL?
It's typically "not hard", but it depends on what you're doing w/
Oracle. Specifically, things like stored procedures (PL/SQL) may
require
On 03/14/11 11:43 AM, gene.po...@macys.com wrote:
Is there a recent tutorial, white paper, how to on move/migrate from
Oracle to PostgreSQL? I can get the Oracle schema DDL by pointing our
Data Modeling software at the Red Hat Satellite server and extracting
the DDL. It will take that Oracle
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= writes:
> On Mon, 2011-03-14 at 14:43 -0400, gene.po...@macys.com wrote:
>> [ wants to port Red Hat Satellite to Postgres ]
> Please see
> http://spacewalk.redhat.com/
Yeah. I'm on the fringes of that port effort, and it is *not* trivial;
Satellite is umpteen
Thomas Kellerer wrote:
> I'm getting a new notebook and want to confirm that my idea
> on how to move my Postgres installation will work This is a
> development/test installation and not a production system, so
> it doesn't need to be 100% fail safe.
>
> Both systems are Windows XP 32bit.
>
>
Albe Laurenz, 24.03.2009 10:34:
Thomas Kellerer wrote:
I'm getting a new notebook and want to confirm that my idea
on how to move my Postgres installation will work This is a
development/test installation and not a production system, so
it doesn't need to be 100% fail safe.
Both systems are
I can't avoid it any longer and have to move an old RT2 installation to
a new machine. (I'll upgrade to RT3 on that machine.)
The plan calls for a pg_dump using my workstation using CREATE the
database and INSERTS (-C -D) . Then use psql to run the script created
above to build the database
Hi Rich,
Il 29/03/12 21:10, Rich Shepard ha scritto:
For tables that exist in the one database I want to eliminate, I
thought
to use pg_dump to create .sql files, then use pg_restore to add the
table to
the other database. Did this for one table (with 4201 rows), but
'pg_restore
-d databas
On 3/29/2012 2:10 PM, Rich Shepard wrote:
I'm storing vector map attribute data in postgres tables and somehow
managed to create two databases (of similar names) rather than one. I want
to combine the two.
For tables that exist in the one database I want to eliminate, I thought
to use pg_dump to
On Thu, 29 Mar 2012, Gabriele Bartolini wrote:
I suggest that you look at the -l and -L options in pg_restore, which
allow you to select which dump entries to restore (selective restore).
Gabriele,
After sending the message I realized the proper syntax is 'psql -d
database -f table.sql'. Th
On Thu, 29 Mar 2012, Andy Colson wrote:
How many tables are we talking about. If its a few tables, I'd rename them:
alter table lake rename to lake_old;
... etc
then dump it out and restore into the proper db.
Andy,
This will work just fine. Thanks for the insight.
Rich
--
Sent via pgsq
On Thu, 2012-03-29 at 14:49 -0500, Andy Colson wrote:
> On 3/29/2012 2:10 PM, Rich Shepard wrote:
> > I'm storing vector map attribute data in postgres tables and somehow
> > managed to create two databases (of similar names) rather than one. I want
> > to combine the two.
> >
> > For tables that e
I need to convert my database to UTF8. Is there a way to do a SELECT ...
INSERT from the old database table to the new one? Would the INSERT
correct data errors between the two data types? I only have 10 tables and
the biggest has < 8000 rows.
Running Version 8.1.4 on Redhat 9
*** *** *** ***
> Hello, I have to move all the data in my actual server to the new one.
> I have several databases in postgresql, and I'd like to know the best way
> to
> move them.
> I thoung that maybe copying all the data directory... but I'm not sure,
> and I
> don't know where it's stored.
> I'd apreciate yo
Nicholas Barr writes:
It is much much safer to use pg_dump/pg_restore and know that your data is
consistent.
http://www.postgresql.org/docs/8.2/static/backup-dump.html
In particular look at the section
23.1.2. Using pg_dumpall
That will copy your entire data set including users.
-
On Jun 25, 2007, at 10:44 , Nicholas Barr wrote:
Only copy the data directory if both servers are offline and not
running
and if both servers use the same version of postgres.
... and have the same architecture. As you note, copying the data
directory is *not* the recommended way to do th
In article <[EMAIL PROTECTED]>,
Nicholas Barr <[EMAIL PROTECTED]> wrote:
% Only copy the data directory if both servers are offline and not running
% and if both servers use the same version of postgres. This method is not
% recommended AFAIK.
It _is_ recommended for setting up a warm-standby ser
Hi,
I am working right now in an strategy to improve the performance on my
server. The situation is this:
I have a very large database that it is only update once a month, but
when is updated I have to process a lot of things on the data to
create caches, aditional tables, etc.
The processing o
On Tue, 2009-04-14 at 09:58 -0700, Roderick A. Anderson wrote:
> I can't avoid it any longer and have to move an old RT2 installation to
> a new machine. (I'll upgrade to RT3 on that machine.)
>
> The plan calls for a pg_dump using my workstation using CREATE the
> database and INSERTS (-C -D)
"Joshua D. Drake" writes:
> On Tue, 2009-04-14 at 09:58 -0700, Roderick A. Anderson wrote:
>> The plan calls for a pg_dump using my workstation using CREATE the
>> database and INSERTS (-C -D) . Then use psql to run the script created
>> above to build the database on the new system.
> You wan
Roderick A. Anderson wrote:
I can't avoid it any longer and have to move an old RT2 installation
to a new machine. (I'll upgrade to RT3 on that machine.)
The plan calls for a pg_dump using my workstation using CREATE the
database and INSERTS (-C -D) . Then use psql to run the script
created
John R Pierce wrote:
Roderick A. Anderson wrote:
make sure pg_hba.conf on the old machine allows you to connect from the
new machine's IP address as the user postgres (this may require setting
a database password for the postgres user on the old machine if the
'host' authentication method
Joshua D. Drake wrote:
On Tue, 2009-04-14 at 09:58 -0700, Roderick A. Anderson wrote:
I can't avoid it any longer and have to move an old RT2 installation to
a new machine. (I'll upgrade to RT3 on that machine.)
The plan calls for a pg_dump using my workstation using CREATE the
database and
Tom Lane wrote:
"Joshua D. Drake" writes:
On Tue, 2009-04-14 at 09:58 -0700, Roderick A. Anderson wrote:
The plan calls for a pg_dump using my workstation using CREATE the
database and INSERTS (-C -D) . Then use psql to run the script created
above to build the database on the new system.
2007/2/8, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
I need to convert my database to UTF8. Is there a way to do a SELECT ...
INSERT from the old database table to the new one? Would the INSERT correct
data errors between the two data types? I only have 10 tables and the
biggest has < 8000 rows.
U
On 2/8/07, Clodoaldo <[EMAIL PROTECTED]> wrote:
Use pg_dump to dump the db and use iconv on the generated file:
iconv -f ASCII -t UTF-8 mydb.dump -o mydb_utf8.dump
Wouldn't it be adequate to set the client encoding to SQL_ASCII in the dump
file (if that was infact the encoding on the origina
On Thu, Feb 08, 2007 at 08:22:40PM -0500, Chad Wagner wrote:
> On 2/8/07, Clodoaldo <[EMAIL PROTECTED]> wrote:
> >Use pg_dump to dump the db and use iconv on the generated file:
> >
> >iconv -f ASCII -t UTF-8 mydb.dump -o mydb_utf8.dump
Converting the data from ASCII to UTF-8 doesn't make much sen
On Wed, 2006-08-16 at 20:04 +0200, Javier de la Torre wrote:
> I am working right now in an strategy to improve the performance on my
> server. The situation is this:
>
> I have a very large database that it is only update once a month, but
> when is updated I have to process a lot of things on th
Yes!
Thanks. It pointed me out to File system level backup. And there I
found a very important hint... you have to restore the whole database
cluster. I suppose this means that I have to transfer all databases in
my postgresql...
What is actually a pity because there is a db on the production si
On Wed, 2006-08-16 at 20:37 +0200, Javier de la Torre wrote:
> Yes!
>
> Thanks. It pointed me out to File system level backup. And there I
> found a very important hint... you have to restore the whole database
> cluster. I suppose this means that I have to transfer all databases in
> my postgresq
Hi all,
Is this possible? I have a db that has been living in the default
tablespace, and I am trying to separate out the transaction logs (and
log archiving) and the data. It seems that tablespaces are the way to
go... but the database exists and I need to separate them out. Any
pointers?
Cheers
A
Hi All,
We want to replicate /move data form db2 to postgres is there any software /
solutions / approach available to do this?
Thanks
Deepak
Anton Melser a écrit :
Is this possible? I have a db that has been living in the default
tablespace, and I am trying to separate out the transaction logs (and
log archiving) and the data. It seems that tablespaces are the way to
go... but the database exists and I need to separate them out. Any
p
On Fri, Jun 4, 2010 at 2:13 PM, DM wrote:
> We want to replicate /move data form db2 to postgres is there any software /
> solutions / approach available to do this?
Here is a link on the postgresql wiki.
Hopefully it has some useful information.
http://wiki.postgresql.org/wiki/Converting_from
Thanks Robert,
Is there any tools available.
Thanks
Deepak
On Fri, Jun 4, 2010 at 2:19 PM, Richard Broersma wrote:
> On Fri, Jun 4, 2010 at 2:13 PM, DM wrote:
> > We want to replicate /move data form db2 to postgres is there any
> software /
> > solutions / approach available to do this?
>
>
1 - 100 of 112 matches
Mail list logo