Thread: Where do I find the init-script

On Sunday 08 February 2004 07:34, nednieuws | charles wrote:
> I've been asked to send the init-script along with the dump. Where can I
> find it?

In /etc/init.d/ on linux (or /etc/rc.d/init.d/)
Apparently, on freebsd it sits in /usr/local/etc/rc.d/

HTH
--
  Richard Huxton
  Archonet Ltd

Oh, is that it. I thought they were talking about a script to init the db :-).

They said: If you send the init script along with the dump, it's easier to restore the db.

> -----Oorspronkelijk bericht-----
> Van: Richard Huxton [mailto:dev@archonet.com]
> Verzonden: maandag 9 februari 2004 11:13
> Aan: nednieuws | charles; pgsql-general@postgresql.org
> Onderwerp: Re: [GENERAL] Where do I find the init-script
>
>
> On Sunday 08 February 2004 07:34, nednieuws | charles wrote:
> > I've been asked to send the init-script along with the
> dump. Where can
> > I find it?
>
> In /etc/init.d/ on linux (or /etc/rc.d/init.d/)
> Apparently, on freebsd it sits in /usr/local/etc/rc.d/
>
> HTH
> --
>   Richard Huxton
>   Archonet Ltd
>

> I'm guessing they mean the SQL to recreate the database.
> Normally pg_dump will
> dump both the schema-creationg SQL and the data for the
> tables. You can
> restrict this with --data-only or --schema-only.

That's what I do now: I dump the schema along with the data.

> Difficult to say what "they" mean - what is the context for this?

That's always with the problem with "them" :)

I guess they're having problems with the uid's not being available on their system or something like that. I told them
toread up on the help for pg_restore so we'll leave it at that until they come back with something more useful. Unless
someoneelse on the list knows what they mean. 

Sorry for the confusion, I just hoped that someone would know immediately what "they" meant.

--
Regards, Charles.

On Monday 09 February 2004 16:36, nednieuws | charles wrote:
> Oh, is that it. I thought they were talking about a script to init the db
> :-).
>
> They said: If you send the init script along with the dump, it's easier to
> restore the db.

Hmm - that's probably not what they want.

I'm guessing they mean the SQL to recreate the database. Normally pg_dump will
dump both the schema-creationg SQL and the data for the tables. You can
restrict this with --data-only or --schema-only.

Alternatively, pg_restore can restore only the schema or data (if you want).

Difficult to say what "they" mean - what is the context for this?
--
  Richard Huxton
  Archonet Ltd