Where do I find the init-script

Started by nednieuws | charlesabout 22 years ago5 messagesgeneral
Jump to latest
#1nednieuws | charles
charles@nednieuws.com

I've been asked to send the init-script along with the dump. Where can I find it?

--
Regards, Charles.

#2Richard Huxton
dev@archonet.com
In reply to: nednieuws | charles (#1)
Re: 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

#3nednieuws | charles
charles@nednieuws.com
In reply to: Richard Huxton (#2)
Re: Where do I find the init-script

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-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

#4Richard Huxton
dev@archonet.com
In reply to: nednieuws | charles (#3)
Re: Where do I find the init-script

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

#5nednieuws | charles
charles@nednieuws.com
In reply to: Richard Huxton (#4)
Re: Where do I find the init-script

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.