Le jeudi 30 décembre 2010 à 12:05 -0500, Andrew Sullivan a écrit :
[about Abiword]
> It's intended as a word processor rather than a text
> editor, isn't it?
It works with text files too. It's not a problem.
--
Vincent Veyron
http://marica.fr/
Progiciel de gestion des dossiers de contentieux e
On Thu, Dec 30, 2010 at 06:02:54PM +0100, Vincent Veyron wrote:
>
> I'm partial to Emacs, but I'm surprised nobody mentionned Abiword :
>
> http://www.abisource.com/
I think Abiword would be a very bad editor for any kind of database
work, no? It's intended as a word processor rather than a tex
Le mercredi 29 décembre 2010 à 11:09 -0800, Tim Bruce - Postgres a
écrit :
> On Wed, December 29, 2010 10:59, John R Pierce wrote:
> I'd also like to throw in Context for Windows as an Editor. It's also
> free and has syntax highlighting for almost everything imaginable (on
> Windows and *ix).
On Wed, December 29, 2010 10:59, John R Pierce wrote:
> On 12/29/10 4:34 AM, Leif Biberg Kristensen wrote:
>> Back when I used Windows, my favorite editor was EditPlus
>> (http://www.editplus.com/). It isn't free, but well worth the 35 bucks.
>
> other good choices are Notepad++ (free) and my perso
On Wednesday 29 December 2010 10:52:50 am Bob Pawley wrote:
> -Original Message-
> From: Adrian Klaver
> Sent: Wednesday, December 29, 2010 8:08 AM
> To: pgsql-general@postgresql.org
> Cc: Leif Biberg Kristensen
> Subject: Re: [GENERAL] Restore problem
>
> On Wedn
On 12/29/10 4:34 AM, Leif Biberg Kristensen wrote:
Back when I used Windows, my favorite editor was EditPlus
(http://www.editplus.com/). It isn't free, but well worth the 35 bucks.
other good choices are Notepad++ (free) and my personal favorite,
UltraEdit ($$).
UEdit has some nice stuff lik
-Original Message-
From: Adrian Klaver
Sent: Wednesday, December 29, 2010 8:08 AM
To: pgsql-general@postgresql.org
Cc: Leif Biberg Kristensen
Subject: Re: [GENERAL] Restore problem
On Wednesday 29 December 2010 4:34:39 am Leif Biberg Kristensen wrote:
On Wednesday 29. December 2010
-Original Message-
From: Alban Hertroys
Sent: Wednesday, December 29, 2010 4:03 AM
To: Bob Pawley
Cc: Adrian Klaver ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On 29 Dec 2010, at 4:40, Bob Pawley wrote:
It seems that this has affected just the triggers
On Wednesday 29 December 2010 4:34:39 am Leif Biberg Kristensen wrote:
> On Wednesday 29. December 2010 13.18.40 Alban Hertroys wrote:
> > Learning Vim is probably time well-spent, but until you do it's
>
> probably not that good a tool for fixing your problem.
>
> > Although Vim is indeed a very p
On Tuesday 28 December 2010 8:45:14 pm Bob Pawley wrote:
> -Original Message-
> From: Alan Hodgson
> Sent: Tuesday, December 28, 2010 8:12 PM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Restore problem
>
> On December 28, 2010, Adrian Klaver wrote:
&g
On Wednesday 29 December 2010 3:58:35 am Alban Hertroys wrote:
> On 29 Dec 2010, at 4:29, Adrian Klaver wrote:
> >>> What program are you using to look at the plain text file?
> >>>
> >>>
> >>> Notepad
> >>>
> >>> Bob
> >>
> >> Open the file in Wordpad and see if it looks better.
> >>
> >> It looks
On Wednesday 29. December 2010 13.18.40 Alban Hertroys wrote:
> Learning Vim is probably time well-spent, but until you do it's
probably not that good a tool for fixing your problem.
>
> Although Vim is indeed a very powerful editor, it's not particularly
easy to use. Unlike your usual editors
On 29 Dec 2010, at 7:54, Alan Hodgson wrote:
>> I'll look at that - I'm also looking at something called Vim
>> http://www.vim.org/download.php
>
> vim is an excellent open source text editor. Which may fix your problem if
> it's related to line endings.
Learning Vim is probably time well-spen
On 29 Dec 2010, at 4:40, Bob Pawley wrote:
> It seems that this has affected just the triggers - although that is quite
> massive I will just plug away at it until it's done
(Gosh, those lines were hard to find!)
How did you create those functions? With notepad, or from within pgadmin? If
you
On 29 Dec 2010, at 4:29, Adrian Klaver wrote:
>>> What program are you using to look at the plain text file?
>>>
>>>
>>> Notepad
>>>
>>> Bob
>>>
>>
>> Open the file in Wordpad and see if it looks better.
>>
>> It looks the same.
>>
>> Bob
>
> Well there goes that theory. Notepad is almost u
On 2010-12-29, Bob Pawley wrote:
> Yes I was just looking at it.
>
> It seems that it was dumped in that form.
>
> Any thoughts on how that could happen?? Not that it will help in this
> instance.
could be EOL problem. LF vs CRLF
but I expect that would be merely cosmetic.
--
Sent via pgsql-g
On December 28, 2010, "Bob Pawley" wrote:
> It's often a good idea to maintain function definitions outside the
> database,
> under version control, and apply them to the database from there.
>
> I would appreciate a more detailed explanation of this.
Treat them like source code.
>
> Bob
>
>
On Tue, Dec 28, 2010 at 8:05 PM, Bob Pawley wrote:
> What program are you using to look at the plain text file?
>
>
> Notepad
Did you at some point open the backup file with notepad, make a change
and then save it? If so notepad may have permanently mangled the
backup. If so, do you have an ori
-Original Message-
From: Alan Hodgson
Sent: Tuesday, December 28, 2010 8:12 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On December 28, 2010, Adrian Klaver wrote:
On 12/28/2010 07:40 PM, Bob Pawley wrote:
>> Open the file in Wordpad and see
On December 28, 2010, Adrian Klaver wrote:
> On 12/28/2010 07:40 PM, Bob Pawley wrote:
> >> Open the file in Wordpad and see if it looks better.
> >>
> >> I downloaded an sql editor and it looks the same in it as well.
> >>
> >> At least the editor will make it easier to fix the problem. However
On 12/28/2010 07:40 PM, Bob Pawley wrote:
Open the file in Wordpad and see if it looks better.
I downloaded an sql editor and it looks the same in it as well.
At least the editor will make it easier to fix the problem. However I
would like to know what happened so I can avoid it in the future
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 7:33 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On 12/28/2010 07:27 PM, Bob Pawley wrote:
-Original Message- From: Adrian Klaver
Sent: Tuesday, December
On 12/28/2010 07:27 PM, Bob Pawley wrote:
-Original Message- From: Adrian Klaver
Sent: Tuesday, December 28, 2010 7:06 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On 12/28/2010 07:05 PM, Bob Pawley wrote:
-Original Message- From
On 12/28/2010 07:16 PM, Bob Pawley wrote:
-Original Message- From: Adrian Klaver
Sent: Tuesday, December 28, 2010 7:06 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On 12/28/2010 07:05 PM, Bob Pawley wrote:
-Original Message- From
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 7:06 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On 12/28/2010 07:05 PM, Bob Pawley wrote:
-Original Message- From: Adrian Klaver
Sent: Tuesday, December
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 7:06 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On 12/28/2010 07:05 PM, Bob Pawley wrote:
-Original Message- From: Adrian Klaver
Sent: Tuesday, December
On 12/28/2010 07:05 PM, Bob Pawley wrote:
-Original Message- From: Adrian Klaver
Sent: Tuesday, December 28, 2010 6:51 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On Tuesday 28 December 2010 6:41:51 pm Bob Pawley wrote:
> &g
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 6:51 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On Tuesday 28 December 2010 6:41:51 pm Bob Pawley wrote:
> > Bob
>
> --
> Adrian Klaver
> adria
On Tuesday 28 December 2010 6:41:51 pm Bob Pawley wrote:
> > > Bob
> >
> > --
> > Adrian Klaver
> > adrian.kla...@gmail.com
> >
> > This is the plain text dump file through pg_admin dump. But the plain
> > text dump fie through psql restored in the same way.
>
> I am not following. psql cannot cre
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 6:09 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On Tuesday 28 December 2010 5:58:51 pm Bob Pawley wrote:
-Original Message-
From: Adrian Klaver
Sent
@postgresql.org
Subject: Re: [GENERAL] Restore problem
On Tuesday 28 December 2010 5:58:51 pm Bob Pawley wrote:
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 4:21 PM
To: pgsql-general@postgresql.org
Cc: Bob Pawley
Subject: Re: [GENERAL] Restore problem
On Tuesday 28 December
On Tuesday 28 December 2010 5:58:51 pm Bob Pawley wrote:
> -Original Message-
> From: Adrian Klaver
> Sent: Tuesday, December 28, 2010 4:21 PM
> To: pgsql-general@postgresql.org
> Cc: Bob Pawley
> Subject: Re: [GENERAL] Restore problem
>
> On Tuesday 28 December 20
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 4:21 PM
To: pgsql-general@postgresql.org
Cc: Bob Pawley
Subject: Re: [GENERAL] Restore problem
On Tuesday 28 December 2010 3:06:40 pm Bob Pawley wrote:
Hi
I have restored a database using psql to windows version
On Tuesday 28 December 2010 3:06:40 pm Bob Pawley wrote:
> Hi
>
> I have restored a database using psql to windows version 8.4.
>
> During the restore the trigger code became jumbled.
>
> I now have a great number of lines that have moved so that they are now
> included in lines the have been comm
On Tue, Dec 28, 2010 at 6:06 PM, Bob Pawley wrote:
> Hi
>
> I have restored a database using psql to windows version 8.4.
>
> During the restore the trigger code became jumbled.
>
> I now have a great number of lines that have moved so that they are now
> included in lines the have been commen
Hi
I have restored a database using psql to windows version 8.4.
During the restore the trigger code became jumbled.
I now have a great number of lines that have moved so that they are now
included in lines the have been commented out – not to mention that the code
is hard to read.
Is there
If I run the admin tool from my postgres account, that works fine since
postgres is the owner.
> Cc: pgsql-general@postgresql.org
> Subject: Re: Fwd: [GENERAL] Restore problem from 8.4 backup to 9.0
>
>> Thanks for the fast reply. I must have still been connected to the old
Where would I type 'show hba_file'? I'm on Mac. Also I downloaded the
distribution from postgresql.org. If I run an initdb and I already restored a
database, will it put the pg_hba.conf file in the 'data' folder?
> Subject: Re: Fwd: [GENERAL] Restore pr
Adam Wizon writes:
> Thanks for the fast reply. I must have still been connected to the older
> database somehow. I cleaned up my installation and restored the database.
> No error messages this time. I need to change the pg_hba.conf file. I read
> the documentation and its supposed to be
Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Restore problem from 8.4 backup to 9.0
>
> Adam Wizon writes:
>> I installed v9.0 on my Mac Pro. Dumped the 8.4 database using 'pg_dump -Fc
>> -d dbname --username=xyz > backup_file_name' using the pg_dump from
Adam Wizon writes:
> I installed v9.0 on my Mac Pro. Dumped the 8.4 database using 'pg_dump -Fc
> -d dbname --username=xyz > backup_file_name' using the pg_dump from the 8.4
> installation. I restored the database using 'pg_restore -d dbname
> backup_file_name' using the 9.0 restore and afte
I installed v9.0 on my Mac Pro. Dumped the 8.4 database using 'pg_dump -Fc -d
dbname --username=xyz > backup_file_name' using the pg_dump from the 8.4
installation. I restored the database using 'pg_restore -d dbname
backup_file_name' using the 9.0 restore and after creating a new database
u
On Saturday 03 January 2009 10:43:09 am Kenneth Lundin wrote:
> Tom,
>
> Well, it's not really "I" that change the password, it happens in the
> backup dump file created automatically by pg_dumpall.
>
> The thing is as an administrator, you want to be able to take a backup at
> certain points in ti
Tom,
Well, it's not really "I" that change the password, it happens in the backup
dump file created automatically by pg_dumpall.
The thing is as an administrator, you want to be able to take a backup at
certain points in time and then later flawlessly be able to restore that
backup and end up in
"Kenneth Lundin" writes:
> How do I avoid this scenario?
Don't change the postgres user's password in the middle of a dump/restore?
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.p
Hi All,
I have a backup/restore problem I need help with.
I do a simple dump of the whole cluster using pg_dumpall, with role
definitions and tutti.
When performing restores, I start with a fresh empty database directory that
i create using the createdb utility and specify the super-user to be n
On 12/10/07, Keith Turner <[EMAIL PROTECTED]> wrote:
> We are running 8.1 on Windows 2003 server and have had a server crash
> over the weekend. A virus is suspected - we maintain an app server on
> someone else's network, though we do have anti-virus running, the
> symptoms were worrying - so we
On 12/10/07, Keith Turner <[EMAIL PROTECTED]> wrote:
> We are running 8.1 on Windows 2003 server and have had a server crash
> over the weekend. A virus is suspected - we maintain an app server on
> someone else's network, though we do have anti-virus running, the
> symptoms were worrying - so we
am Mon, dem 10.12.2007, um 12:30:14 -0800 mailte Keith Turner folgendes:
> Hi first post here, I hope you can help.
>
> We are running 8.1 on Windows 2003 server and have had a server crash
> over the weekend. A virus is suspected - we maintain an app server on
Please don't hijack other threads,
Hi first post here, I hope you can help.
We are running 8.1 on Windows 2003 server and have had a server crash
over the weekend. A virus is suspected - we maintain an app server on
someone else's network, though we do have anti-virus running, the
symptoms were worrying - so we had to wipe and rein
I forgot to add that I used the command
for restore:
psql –f
Thanks
Mousa
From: Shaya Mousa
(Nokia-ES/Boston)
Sent: Tuesday, October 26, 2004
11:42 AM
To: '[EMAIL PROTECTED]'
Subject: Restore problem
I have created a backup file using pg_dumpall.
When I try to r
51 matches
Mail list logo
