Where do I find the init-script
I've been asked to send the init-script along with the dump. Where can I find it?
--
Regards, Charles.
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.
Show quoted text
-----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-scriptOn 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
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
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 to read up on the help for pg_restore so we'll leave it at that until they come back with something more useful. Unless someone else on the list knows what they mean.
Sorry for the confusion, I just hoped that someone would know immediately what "they" meant.
--
Regards, Charles.