On Thursday, December 15, 2011 7:57:40 am Carlos Mennens wrote:
> So after reading
> http://www.postgresql.org/docs/9.1/interactive/backup-dump.html,
That was not the link I posted. In fact I have never actually been to that
page:) This is the link I posted:
http://www.postgresql.org/docs/9.1/in
On Thu, Dec 15, 2011 at 11:09 AM, Raymond O'Donnell wrote:
> The point here is that with the plain-text dump (the default output from
> pg_dump), you can feed that directly to psql; but you have no control
> over what is restored, or in what order, without editing the dump file
> directly.
>
> If,
On 15/12/2011 15:57, Carlos Mennens wrote:
> So after reading
> http://www.postgresql.org/docs/9.1/interactive/backup-dump.html,
>
> I'm not sure why the manual shows you in "24.1. SQL Dump" & then
> directly after in 24.1.1, they explain how to restore with psql as you
> advised me not to. I got
On Thu, Dec 15, 2011 at 10:28 AM, Adrian Klaver wrote:
> The reason I pointed to the manual links is that there is a lot of good
> information in there. It deserves more than a skim:). Realistically, to get
> the
> most out of the dump/restore process you need to know the options available on
> b
On Thursday, December 15, 2011 6:55:46 am Carlos Mennens wrote:
> On Thu, Dec 15, 2011 at 9:37 AM, Adrian Klaver
wrote:
> > You know the fine manual covers this?:
> > http://www.postgresql.org/docs/9.1/interactive/app-pgdump.html
>
> I've honestly skimmed the manual and it's very easy to use and
On Thu, Dec 15, 2011 at 9:37 AM, Adrian Klaver wrote:
> You know the fine manual covers this?:
> http://www.postgresql.org/docs/9.1/interactive/app-pgdump.html
I've honestly skimmed the manual and it's very easy to use and good
but it covers so many aspects and sometimes I need a specific answer
On Thursday, December 15, 2011 5:33:17 am Carlos Mennens wrote:
> I performed a pg_dump from my new 9.1.2 server but my question now is
> importing the data. So I had 9.1.2 perform the dump and it's now on
> the new server but what are (if any) the steps to restore or install
> them into my new 9.
Hi!
> Is there a way in psql client I can search my database tables for any
> BYTEA columns?
>
What about just grepping your dump file for 'bytea'? :)
Bèrto
--
==
If Pac-Man had affected us as kids, we'd all be running around in a
darkened room munching pills and l
On Mon, Dec 12, 2011 at 12:23 PM, Andreas Kretschmer
wrote:
> - use the pg_dumpall from the new version to make the dump, for instance
> pg_dumpall -h ... | psql (something like this, on the new
> host)
I performed a pg_dump from my new 9.1.2 server but my question now is
importing the data. S
On Mon, Dec 12, 2011 at 12:23 PM, Andreas Kretschmer
wrote:
> - you should use 9.1.2, not 9.1.1 ;-)
I don't think it's available yet in Debian repositories. I can only
use whatever packages they've compiled in their repositories.
> - use the pg_dumpall from the new version to make the dump, for
Le 12 décembre 2011 18:12, Carlos Mennens a écrit :
> I've finally received my new virtual database server (Debian Linux) &
> this weekend I'll be rolling my new PostgreSQL server online. My
> question is I've never migrated production data from 8.4.8 to 9.1.1. I
> would like to find out from the
Carlos Mennens wrote:
> I've finally received my new virtual database server (Debian Linux) &
> this weekend I'll be rolling my new PostgreSQL server online. My
> question is I've never migrated production data from 8.4.8 to 9.1.1. I
> would like to find out from the community what exactly is the
12 matches
Mail list logo
