Jump to content

[Solved] postgresql odd tables created automagically


eric235u

Recommended Posts

hi all.

 

i notice that when you create a new database using cpanel it creates some odd looking tables. http://stevie.heliohost.org:2082/frontend/x3/psql/index.html my first thought was that my new site had been comprimised but it looks like maybe that's not the case. possible the admins have some type of automagically generated tables for test purposes? it seems quite strange behavior and i am not able to drop the tables. just thought i should mention this in case it is a larger problem.

 

how to reproduce.

1. create new database with cpanel. use the postgresql databases link.

2. via phppgadmin look at the newly created db.

3. in my case there were two tables created that i could not drop.

comic owned by dbescom and cadastro owned by doritos_postgres.

 

any tips on what is actually happening most welcome. thanks.

Link to comment
Share on other sites

Do you see one now named "djbob_test2"? Also, what is your database named?

 

hi, i do not see a table or database called djbob_test2. my db is called eric235u_test1.

 

fwiw i can read the data in one of the other tables. i hope that others can not read my data.

Link to comment
Share on other sites

Okay, the issue is fixed. However, I completely screwed up and dropped all the tables on your account. I hope it's salvageable, as there is nothing I can do to get it back.

 

Sorry :(

 

 

hi. no problem about dropping my tables. i do frequent backups (like everybody should). here's what i see.

 

1. when i create a new database it no longer creates the odd unrelated tables. this is good. :-)

 

2. in my main database, eric235u_test1, there still is one table. it is called 'cadastro'. and it has three rows of data in it that i can select from but i can not drop the table. the owner of the table is 'doritos_postgres'. as a work around i'll just drop the db and start fresh.

 

hey if you guys ever want another part time support assistant just let me know.

http://www.linkedin.com/in/echadbourne

https://savannah.nongnu.org/people/resume.php?user_id=74395

 

many thanks for your quick assistance!

 

 

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...