[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Upgrade problem



heksebua=# \dt defaults
           List of relations
 Schema |   Name   | Type  |   Owner
--------+----------+-------+-----------
 public | defaults | table | ledgersmb
(1 row)

heksebua=# \dt users
No matching relations found.
heksebua=# \dt users_conf
No matching relations found.

heksebua=# select * from defaults where setting_key = 'version';
 setting_key | value
-------------+-------
 version     | 1.2.0
(1 row)

~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~

Linda Ursin
Heksebua

Adresse:                      Tlf:     (+47) 402 40 767
Solvang                        www:     http://heksebua.com
7288 Soknedal              E-post:  ..hidden..

Org: NO 995 578 107


On Thu, Feb 16, 2012 at 1:11 PM, Chris Travers <..hidden..> wrote:


On Thu, Feb 16, 2012 at 3:49 AM, Linda Ursin <..hidden..> wrote:
heksebua=# \dt

Ok, in this database:

\dt defaults
\dt users
\dt users_conf

Then:

select * from defaults where setting_key = 'version';
 
 public | partscustomer        | table | ledgersmb
 public | partsgroup           | table | ledgersmb
 public | partstax             | table | ledgersmb
 public | partsvendor          | table | ledgersmb
 public | pricegroup           | table | ledgersmb
 public | project              | table | ledgersmb
 public | recurring            | table | ledgersmb
 public | recurringemail       | table | ledgersmb
 public | recurringprint       | table | ledgersmb
 public | shipto               | table | ledgersmb
 public | sic                  | table | ledgersmb
 public | status               | table | ledgersmb
 public | tax                  | table | ledgersmb
 public | taxcategory          | table | ledgersmb
 public | taxmodule            | table | ledgersmb
 public | transactions         | table | ledgersmb
 public | translation          | table | ledgersmb
 public | vendor               | table | ledgersmb
 public | vendortax            | table | ledgersmb
 public | warehouse            | table | ledgersmb
 public | yearend              | table | ledgersmb
(47 rows)

heksebua=# \dn
        List of schemas
        Name        |  Owner
--------------------+----------
 information_schema | postgres
 lsmb_13fail        | postgres
 pg_catalog         | postgres
 pg_toast           | postgres
 pg_toast_temp_1    | postgres
 public             | postgres
(6 rows)

~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~

Linda Ursin
Heksebua

Adresse:                      Tlf:     (+47) 402 40 767
Solvang                        www:     http://heksebua.com
7288 Soknedal              E-post:  ..hidden..

Org: NO 995 578 107


On Thu, Feb 16, 2012 at 12:45 PM, Chris Travers <..hidden..> wrote:


On Thu, Feb 16, 2012 at 3:38 AM, Linda Ursin <..hidden..> wrote:
postgres=# \dn
        List of schemas
        Name        |  Owner
--------------------+----------
 information_schema | postgres
 pg_catalog         | postgres
 pg_toast           | postgres
 pg_toast_temp_1    | postgres
 public             | postgres
(5 rows)

Try connecting to your ledgersmb database and repeat the \dt and the \dn tests.

you can do this with psql -U postgres dbname or once in psql \c dbname
(substitute dbname with your database name)

If unsure psql -U postgres -l

------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users



------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users



------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users


------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing 
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users