pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedProblem
13+ messages / 11 participants
[nested] [flat]
* Problem
@ 2002-04-29 06:31 Ram <ram@anantinfotech.com>
0 siblings, 1 reply; 13+ messages in thread
From: Ram @ 2002-04-29 06:31 UTC (permalink / raw)
To: pgsql-bugs
Sir,
I dont know whether this is a right place to ask this question,but I
hope you guys will still help me out.
I'm in a serious problem,we are using Postgres having 2-3
databases,today when i started the server I couldnot find a single
database,also it is not allowing me to create a new one.Its showing the
following error
# createdb test;
psql: FATAL 1: Database "template1" does not exist in the system
catalog.
createdb: database creation failed
What could be the reason ?
Please help me out.
Thanx in Advance.
Ram
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: Problem
@ 2002-07-02 19:03 Tom Lane <tgl@sss.pgh.pa.us>
parent: Ram <ram@anantinfotech.com>
0 siblings, 0 replies; 13+ messages in thread
From: Tom Lane @ 2002-07-02 19:03 UTC (permalink / raw)
To: Ram <ram@anantinfotech.com>; +Cc: pgsql-bugs
Ram <ram@anantinfotech.com> writes:
> # createdb test;
> psql: FATAL 1: Database "template1" does not exist in the system
> catalog.
What PG version is this? Can you get into any of your other databases?
If so, what do you get from "SELECT * FROM pg_database"?
regards, tom lane
^ permalink raw reply [nested|flat] 13+ messages in thread
* Problem
@ 2002-09-11 07:37 Prasanna <prasannaphatak@vsnl.net>
0 siblings, 1 reply; 13+ messages in thread
From: Prasanna @ 2002-09-11 07:37 UTC (permalink / raw)
To: pgsql-bugs
Hello,
I’m a standalone user of Linux 7.3. I’m facing problem to start sql
command
Interpreter i.e. psql. See I’ve first of all created a database using
initdb dbms
Command it gets created. And it also creates directory dbms which
contains
Many files and directories. That directory is /home/Prasanna/dbms.
Now I want to start the server so I can start it by giving command
/usr/bin/postmaster –D dbms
so it gets started. Now if I gave command like psql –D dbms
Then it gives error like
Fatal 1: database name ‘dbms’ is not present in the system catalog.
Now what should I do? This fatal error appears on the postmaster server.
I’ve tried two nights for this psql but not getting success. May be I’m
wrong.
Will you please tell me how to start the psql with my database created
by
Initdb. It will be very helpful to me.
Thank You,
Regards
________________________________________________
Prasanna Prabhakar Phatak
20/21, "Prabhalaxmi", Patwardhan Baug, Erandwane Pune 4
Ph. +91 020 5466022
email. prasannaphatak@indiatimes.com, ppp_pras@yahoo.com
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: [BUGS] Problem
@ 2002-09-16 15:12 Stephan Szabo <sszabo@megazone23.bigpanda.com>
parent: Prasanna <prasannaphatak@vsnl.net>
0 siblings, 0 replies; 13+ messages in thread
From: Stephan Szabo @ 2002-09-16 15:12 UTC (permalink / raw)
To: Prasanna <prasannaphatak@vsnl.net>; +Cc: pgsql-admin@postgresql.org
-bugs is the wrong place, redirected to -admin.
On Wed, 11 Sep 2002, Prasanna wrote:
> Im a standalone user of Linux 7.3. Im facing problem to start sql
> command
> Interpreter i.e. psql. See Ive first of all created a database using
> initdb dbms
> Command it gets created. And it also creates directory dbms which
> contains
> Many files and directories. That directory is /home/Prasanna/dbms.
> Now I want to start the server so I can start it by giving command
> /usr/bin/postmaster D dbms
> so it gets started. Now if I gave command like psql D dbms
> Then it gives error like
>
> Fatal 1: database name dbms is not present in the system catalog.
>
> Now what should I do? This fatal error appears on the postmaster server.
> Ive tried two nights for this psql but not getting success. May be Im
> wrong.
> Will you please tell me how to start the psql with my database created
> by
> Initdb. It will be very helpful to me.
The location of the data directory is not a database name, databases are
stored inside that location. Try psql template1 or make a database
with createdb and connect to that (template1 is one of the template
databases for new databases so stuff you do there can pollute other
databases you create).
^ permalink raw reply [nested|flat] 13+ messages in thread
* problem
@ 2004-05-14 08:17 Tomasz Lisica <tomaszl@zeto.olsztyn.pl>
0 siblings, 0 replies; 13+ messages in thread
From: Tomasz Lisica @ 2004-05-14 08:17 UTC (permalink / raw)
To: pgsql-bugs
Hi,
i installed Postrgersql 7.5 Win version and postmaster
gives me the following error:
unknown option -- t
WindowsXP Prof
Regards,
tom
tomaszl@zeto.olsztyn.pl
^ permalink raw reply [nested|flat] 13+ messages in thread
* problem
@ 2005-08-01 13:26 Vincenzo Montemurro <v.montemurro@convergere.com>
0 siblings, 0 replies; 13+ messages in thread
From: Vincenzo Montemurro @ 2005-08-01 13:26 UTC (permalink / raw)
To: pgsql-bugs
I all , kindly I have had an problem with the db postgresql 7.2 (arranges optimal) but job on a auentiicazione table and now this table is delete. The manager asks nfoomatiion on this happened to me. I would not want to give the impression of a human error bcause that job single on this table, being of ninth having delete null. Kindly you could help understand, in this problem is happened and cokme to obviate? Thanks
Tank Vincenzo
^ permalink raw reply [nested|flat] 13+ messages in thread
* problem
@ 2008-04-22 22:19 Khobotko Oleg <oleg@1pr.ru>
0 siblings, 1 reply; 13+ messages in thread
From: Khobotko Oleg @ 2008-04-22 22:19 UTC (permalink / raw)
To: pgsql-bugs
Hello, help me please,
I don't know how, but i got 2 postgres users.
How can I delete the first one ????
thx alot for your answers.
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
select passwd,ctid,xmin,xmax,cmin,cmax from pg_shadow where usesysid =1;
passwd | ctid | xmin | xmax | cmin
| cmax
-------------------------------------+-------+------+----------+----------+-----
-
| (0,1) | 1 | 16754522 | 16754522
| 0
md510db8c04d26d32185270721fcf32155 | (0,2) | 2 | 0 | 0
| 0
(2 rows)
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
select * from pg_shadow where usesysid=1;
usename | usesysid | usecreatedb | usesuper | usecatupd |
passwd
| valuntil | useconfig
----------+----------+-------------+----------+-----------+---------------------
----------------+----------+-----------
postgres | 1 | t | t | t
|
| |
postgres | 1 | t | t | t |
md510db8c04d231142d5
270721fcf740ed5 | infinity |
(2 rows)
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Tom Lane пишет:
"spol@mail.ru" <spol@mail.ru> writes:
> I have two "postgres" user. How to delete the first one ???
>
Let's see the system columns (ctid,xmin,xmax,cmin,cmax) for those
two rows?
regards, tom lane
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: problem
@ 2008-04-25 10:06 Zdenek Kotala <Zdenek.Kotala@Sun.COM>
parent: Khobotko Oleg <oleg@1pr.ru>
0 siblings, 0 replies; 13+ messages in thread
From: Zdenek Kotala @ 2008-04-25 10:06 UTC (permalink / raw)
To: Khobotko Oleg <oleg@1pr.ru>; +Cc: pgsql-bugs
The first record ctid=(0,1) is obsolete, you can delete it. It is probably race
condition in VACUUM and catalog modification. Did you added or modified any user
account (e.g. password change) in related time? Please, can you let us know
exact version of PostgreSQL?
Zdenek
Khobotko Oleg napsal(a):
> Hello, help me please,
> I don't know how, but i got 2 postgres users.
> How can I delete the first one ????
> thx alot for your answers.
> ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
>
> select passwd,ctid,xmin,xmax,cmin,cmax from pg_shadow where usesysid =1;
> passwd | ctid | xmin | xmax | cmin
> | cmax
> -------------------------------------+-------+------+----------+----------+-----
> -
> | (0,1) | 1 | 16754522 | 16754522
> | 0
> md510db8c04d26d32185270721fcf32155 | (0,2) | 2 | 0 | 0
> | 0
> (2 rows)
> //////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
>
> select * from pg_shadow where usesysid=1;
> usename | usesysid | usecreatedb | usesuper | usecatupd |
> passwd
> | valuntil | useconfig
> ----------+----------+-------------+----------+-----------+---------------------
> ----------------+----------+-----------
> postgres | 1 | t | t | t
> |
> | |
> postgres | 1 | t | t | t |
> md510db8c04d231142d5
> 270721fcf740ed5 | infinity |
> (2 rows)
> ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
>
>
> Tom Lane пишет:
> "spol@mail.ru" <spol@mail.ru> writes:
>
>> I have two "postgres" user. How to delete the first one ???
>>
>
> Let's see the system columns (ctid,xmin,xmax,cmin,cmax) for those
> two rows?
>
> regards, tom lane
>
^ permalink raw reply [nested|flat] 13+ messages in thread
* problem
@ 2020-04-24 20:58 reda kodi <kodi_reda@hotmail.com>
0 siblings, 2 replies; 13+ messages in thread
From: reda kodi @ 2020-04-24 20:58 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>; security@postgresql.org <security@postgresql.org>
please i need this rpm for conto's 6
https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/pgdg-redhat-repo-42.0-9.noarc...;
link doesn't work please help me when i instal new rpm i hav this problem
Erreur SQL :
ERROR: column "spclocation" does not exist
LINE 1: ...pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocatio...
^
Dans l'instruction :
SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocation,
(SELECT description FROM pg_catalog.pg_shdescription pd WHERE pg_tablespace.oid=pd.objoid) AS spccomment
FROM pg_catalog.pg_tablespace WHERE spcname NOT LIKE $$pg\_%$$ ORDER BY spcname
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: problem
@ 2020-04-24 21:28 Bruce Momjian <bruce@momjian.us>
parent: reda kodi <kodi_reda@hotmail.com>
1 sibling, 1 reply; 13+ messages in thread
From: Bruce Momjian @ 2020-04-24 21:28 UTC (permalink / raw)
To: reda kodi <kodi_reda@hotmail.com>; +Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
On Fri, Apr 24, 2020 at 08:58:44PM +0000, reda kodi wrote:
> please i need this rpm for conto's 6
> https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/
> pgdg-redhat-repo-42.0-9.noarch.rpm;
>
> link doesn't work please help me when i instal new rpm i hav this problem
>
>
> Erreur SQL :
>
> ERROR: column "spclocation" does not exist
> LINE 1: ...pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocatio...
> ^
>
> Dans l'instruction :
>
> SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocation,
> (SELECT description FROM pg_catalog.pg_shdescription pd WHERE pg_tablespace.oid=pd.objoid) AS spccomment
> FROM pg_catalog.pg_tablespace WHERE spcname NOT LIKE $$pg\_%$$ ORDER BY spcname
PG 12 had this change:
Remove the <structfield>spclocation</structfield> field from <link
linkend="catalog-pg-tablespace"><structname>pg_tablespace</structname></link>
(Magnus Hagander)
I suggest you read all major release notes from your old PG version to
your new one. You did not tell us what is generating this query.
Also, this has nothing to do with security, so you should post to only
one email list.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EnterpriseDB https://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: problem
@ 2020-04-24 21:29 Bruce Momjian <bruce@momjian.us>
parent: Bruce Momjian <bruce@momjian.us>
0 siblings, 0 replies; 13+ messages in thread
From: Bruce Momjian @ 2020-04-24 21:29 UTC (permalink / raw)
To: reda kodi <kodi_reda@hotmail.com>; +Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
On Fri, Apr 24, 2020 at 05:28:05PM -0400, Bruce Momjian wrote:
> On Fri, Apr 24, 2020 at 08:58:44PM +0000, reda kodi wrote:
> > please i need this rpm for conto's 6
> > https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/
> > pgdg-redhat-repo-42.0-9.noarch.rpm;
> >
> > link doesn't work please help me when i instal new rpm i hav this problem
> >
> >
> > Erreur SQL :
> >
> > ERROR: column "spclocation" does not exist
> > LINE 1: ...pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocatio...
> > ^
> >
> > Dans l'instruction :
> >
> > SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocation,
> > (SELECT description FROM pg_catalog.pg_shdescription pd WHERE pg_tablespace.oid=pd.objoid) AS spccomment
> > FROM pg_catalog.pg_tablespace WHERE spcname NOT LIKE $$pg\_%$$ ORDER BY spcname
>
> PG 12 had this change:
Sorry, PG 9.2 had this change:
>
> Remove the <structfield>spclocation</structfield> field from <link
> linkend="catalog-pg-tablespace"><structname>pg_tablespace</structname></link>
> (Magnus Hagander)
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EnterpriseDB https://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: problem
@ 2020-04-29 16:08 Alvaro Herrera <alvherre@2ndquadrant.com>
parent: reda kodi <kodi_reda@hotmail.com>
1 sibling, 1 reply; 13+ messages in thread
From: Alvaro Herrera @ 2020-04-29 16:08 UTC (permalink / raw)
To: reda kodi <kodi_reda@hotmail.com>; +Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>; security@postgresql.org <security@postgresql.org>
On 2020-Apr-24, reda kodi wrote:
> please i need this rpm for conto's 6
> https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/pgdg-redhat-repo-42.0-9.noarc...;
>
> link doesn't work please help me when i instal new rpm i hav this problem
Hello,
This address is for reporting security issues in PostgreSQL, not for
general support questions.
Please see https://www.postgresql.org/support/ and in particular the
pgsql-general mailing list for venues for general support questions.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: problem
@ 2020-04-29 16:11 Alvaro Herrera <alvherre@2ndquadrant.com>
parent: Alvaro Herrera <alvherre@2ndquadrant.com>
0 siblings, 0 replies; 13+ messages in thread
From: Alvaro Herrera @ 2020-04-29 16:11 UTC (permalink / raw)
To: reda kodi <kodi_reda@hotmail.com>; +Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
On 2020-Apr-29, Alvaro Herrera wrote:
> On 2020-Apr-24, reda kodi wrote:
>
> > please i need this rpm for conto's 6
> > https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/pgdg-redhat-repo-42.0-9.noarc...;
> >
> > link doesn't work please help me when i instal new rpm i hav this problem
>
> Hello,
>
> This address is for reporting security issues in PostgreSQL, not for
> general support questions.
Apologies, I forgot to remove the CC to pgsql-bugs. The above was meant
to have the security@postgresql.org CC only.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
^ permalink raw reply [nested|flat] 13+ messages in thread
end of thread, other threads:[~2020-04-29 16:11 UTC | newest]
Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-04-29 06:31 Problem Ram <ram@anantinfotech.com>
2002-07-02 19:03 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-09-11 07:37 Problem Prasanna <prasannaphatak@vsnl.net>
2002-09-16 15:12 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
2004-05-14 08:17 problem Tomasz Lisica <tomaszl@zeto.olsztyn.pl>
2005-08-01 13:26 problem Vincenzo Montemurro <v.montemurro@convergere.com>
2008-04-22 22:19 problem Khobotko Oleg <oleg@1pr.ru>
2008-04-25 10:06 ` Re: problem Zdenek Kotala <Zdenek.Kotala@Sun.COM>
2020-04-24 20:58 problem reda kodi <kodi_reda@hotmail.com>
2020-04-24 21:28 ` Re: problem Bruce Momjian <bruce@momjian.us>
2020-04-24 21:29 ` Re: problem Bruce Momjian <bruce@momjian.us>
2020-04-29 16:08 ` Re: problem Alvaro Herrera <alvherre@2ndquadrant.com>
2020-04-29 16:11 ` Re: problem Alvaro Herrera <alvherre@2ndquadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox