Re: [Personalbackup-users] Errors (if they are) when creating tables in database

[kku <kk...@el...>]

Hi,

It is indeed not so nice that you see errors, but it is normal behaviour. 

We are making sure that nothing exists anymore in the database, we 
accomplish this by deleting all the views, tables and sequences (those 
are the errors you see).
But if this is the first time you create the database...they will 
ofcourse not exist and postgres will throw these errors.
So it is just to make sure that everything is "clean" before we create 
any object in the database.

So here you can disregard the errors, they are normal.

Regards,
LinuxTuxie

Raf wrote:

> Kind members
>
> when creating database's tables with command:
> psql -W -U pbuser personalbackup < database.sql
>
> I receive the following output:
>
> ERROR:  view "overview" does not exist
> ERROR:  view "backuplog_today" does not exist
> ERROR:  table "folders" does not exist
> ERROR:  table "shares" does not exist
> ERROR:  table "machines" does not exist
> ERROR:  table "users" does not exist
> ERROR:  table "backuplog" does not exist
> ERROR:  sequence "s_users" does not exist
> ERROR:  sequence "s_machines" does not exist
> ERROR:  sequence "s_shares" does not exist
> ERROR:  sequence "s_backup" does not exist
> ERROR:  sequence "s_folders" does not exist
> CREATE SEQUENCE
> CREATE SEQUENCE
> CREATE SEQUENCE
> CREATE SEQUENCE
> CREATE SEQUENCE
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
> "users_pkey"
> for table "users"
> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
> "users_username_key" for table "users"
> CREATE TABLE
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "machines_pkey" for table "machines"
> NOTICE:  CREATE TABLE / UNIQUE will create implicit index
> "machines_user_id_key" for table "machines"
> CREATE TABLE
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
> "shares_pkey"
> for table "shares"
> CREATE TABLE
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "folders_pkey" for table "folders"
> CREATE TABLE
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "backuplog_pkey" for table "backuplog"
> CREATE TABLE
> CREATE VIEW
> CREATE VIEW
> CREATE INDEX
> CREATE INDEX
> CREATE INDEX
> CREATE INDEX
> GRANT
> GRANT
> GRANT
> GRANT
> GRANT
> GRANT
> GRANT
> GRANT
> GRANT
> GRANT
> GRANT
> GRANT
> INSERT 17603 1
>
> Are the "ERROR:" entries just errors?
>
> Regards
>
> Raf
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log 
> files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
> _______________________________________________
> Personalbackup-users mailing list
> Per...@li...
> https://lists.sourceforge.net/lists/listinfo/personalbackup-users
>