Can't compile a contrib util: dbsize (probably simply though)

#1 November 23rd, 2005, 01:08 AM

Hello pgsql-general,

When I am running "make" I get the following:
[color=blue]
> gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -I. -I~/postgresql-7.4.2/src/include -D_GNU_SOURCE -c -o dbsize.o dbsize.c
> dbsize.c:1: postgres.h: No such file or directory
> dbsize.c:7: access/heapam.h: No such file or directory
> dbsize.c:8: catalog/catalog.h: No such file or directory
> dbsize.c:9: catalog/namespace.h: No such file or directory
> dbsize.c:10: commands/dbcommands.h: No such file or directory
> dbsize.c:11: fmgr.h: No such file or directory
> dbsize.c:12: storage/fd.h: No such file or directory
> dbsize.c:13: utils/builtins.h: No such file or directory
> make: *** [dbsize.o] Error 1[/color]

I don't understand why it can't find these files.. They are indeed in
"~/postgresql-7.4.2/src/include" just as the -I points =(.

Tips will be much appreciated.

Regards,
Vitaly Belman

ICQ: 1912453
AIM: VitalyB1984
MSN: tmdagent@hotmail.com
Yahoo!: VitalyBe

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

#2 November 23rd, 2005, 01:08 AM

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I'd say you need to install the postgresql-devel package if you're on a rpm
based system.

On Thursday 10 June 2004 02:20 pm, Vitaly Belman wrote:[color=blue]
> Hello pgsql-general,
>
> When I am running "make" I get the following:[color=green]
> > gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes
> > -Wmissing-declarations -fpic -I. -I~/postgresql-7.4.2/src/include
> > -D_GNU_SOURCE -c -o dbsize.o dbsize.c dbsize.c:1: postgres.h: No such
> > file or directory
> > dbsize.c:7: access/heapam.h: No such file or directory
> > dbsize.c:8: catalog/catalog.h: No such file or directory
> > dbsize.c:9: catalog/namespace.h: No such file or directory
> > dbsize.c:10: commands/dbcommands.h: No such file or directory
> > dbsize.c:11: fmgr.h: No such file or directory
> > dbsize.c:12: storage/fd.h: No such file or directory
> > dbsize.c:13: utils/builtins.h: No such file or directory
> > make: *** [dbsize.o] Error 1[/color]
>
> I don't understand why it can't find these files.. They are indeed in
> "~/postgresql-7.4.2/src/include" just as the -I points =(.
>
> Tips will be much appreciated.
>
> Regards,
> Vitaly Belman
>
> ICQ: 1912453
> AIM: VitalyB1984
> MSN: tmdagent@hotmail.com
> Yahoo!: VitalyBe
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)[/color]

- --
UC

- --
Open Source Solutions 4U, LLC 2570 Fleetwood Drive
Phone: +1 650 872 2425 San Bruno, CA 94066
Cell: +1 650 302 2405 United States
Fax: +1 650 872 2417
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFAyNT5jqGXBvRToM4RAncQAJ4myr6GNUScZR10QWS2pj DsdO1EYACgyZZn
k+sqawEng6cPYzRd7xizYgg=
=3I45
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

#3 November 23rd, 2005, 01:08 AM

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I'd say you need to install the postgresql-devel package if you're on a rpm
based system.

On Thursday 10 June 2004 02:20 pm, Vitaly Belman wrote:[color=blue]
> Hello pgsql-general,
>
> When I am running "make" I get the following:[color=green]
> > gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes
> > -Wmissing-declarations -fpic -I. -I~/postgresql-7.4.2/src/include
> > -D_GNU_SOURCE -c -o dbsize.o dbsize.c dbsize.c:1: postgres.h: No such
> > file or directory
> > dbsize.c:7: access/heapam.h: No such file or directory
> > dbsize.c:8: catalog/catalog.h: No such file or directory
> > dbsize.c:9: catalog/namespace.h: No such file or directory
> > dbsize.c:10: commands/dbcommands.h: No such file or directory
> > dbsize.c:11: fmgr.h: No such file or directory
> > dbsize.c:12: storage/fd.h: No such file or directory
> > dbsize.c:13: utils/builtins.h: No such file or directory
> > make: *** [dbsize.o] Error 1[/color]
>
> I don't understand why it can't find these files.. They are indeed in
> "~/postgresql-7.4.2/src/include" just as the -I points =(.
>
> Tips will be much appreciated.
>
> Regards,
> Vitaly Belman
>
> ICQ: 1912453
> AIM: VitalyB1984
> MSN: tmdagent@hotmail.com
> Yahoo!: VitalyBe
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)[/color]

- --
UC

- --
Open Source Solutions 4U, LLC 2570 Fleetwood Drive
Phone: +1 650 872 2425 San Bruno, CA 94066
Cell: +1 650 302 2405 United States
Fax: +1 650 872 2417
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFAyNT5jqGXBvRToM4RAncQAJ4myr6GNUScZR10QWS2pj DsdO1EYACgyZZn
k+sqawEng6cPYzRd7xizYgg=
=3I45
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

#4 November 23rd, 2005, 01:08 AM

On Fri, Jun 11, 2004 at 12:20:00AM +0300, Vitaly Belman wrote:[color=blue]
> Hello pgsql-general,
>
> When I am running "make" I get the following:
> [color=green]
> > gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -I. -I~/postgresql-7.4.2/src/include -D_GNU_SOURCE -c -o dbsize.o dbsize.c[/color][/color]

Make doesn't expand ~ for you, that's a shell thing. Replace it with
$(HOME). This is assumeing you edited the makefile to add that
directory.

Hope this helps,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/[color=blue]
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.[/color]

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD4DBQFAyNaRY5Twig3Ge+YRAvYkAKDV7lUOi1Mj0FJdUCgN3K 8txDF7igCYmOjS
GMhICAChsyZrcGe0FiB5gg==
=0aoW
-----END PGP SIGNATURE-----

#5 November 23rd, 2005, 01:08 AM

On Fri, Jun 11, 2004 at 12:20:00AM +0300, Vitaly Belman wrote:[color=blue]
> Hello pgsql-general,
>
> When I am running "make" I get the following:
> [color=green]
> > gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -I. -I~/postgresql-7.4.2/src/include -D_GNU_SOURCE -c -o dbsize.o dbsize.c[/color][/color]

Make doesn't expand ~ for you, that's a shell thing. Replace it with
$(HOME). This is assumeing you edited the makefile to add that
directory.

Hope this helps,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/[color=blue]
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.[/color]

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD4DBQFAyNaRY5Twig3Ge+YRAvYkAKDV7lUOi1Mj0FJdUCgN3K 8txDF7igCYmOjS
GMhICAChsyZrcGe0FiB5gg==
=0aoW
-----END PGP SIGNATURE-----

#6 November 23rd, 2005, 01:08 AM

Vitaly Belman <vitalib@012.net.il> writes:[color=blue][color=green]
>> gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -I. -I~/postgresql-7.4.2/src/include -D_GNU_SOURCE -c -o dbsize.o dbsize.c
>> dbsize.c:1: postgres.h: No such file or directory[/color][/color]
[color=blue]
> I don't understand why it can't find these files.. They are indeed in
> "~/postgresql-7.4.2/src/include" just as the -I points =(.[/color]

The shell isn't gonna expand ~ for you when it's within a word like
that. I think you were lucky that configure succeeded at all with
such a setting...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

#7 November 23rd, 2005, 01:08 AM

Vitaly Belman <vitalib@012.net.il> writes:[color=blue][color=green]
>> gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes -Wmissing-declarations -fpic -I. -I~/postgresql-7.4.2/src/include -D_GNU_SOURCE -c -o dbsize.o dbsize.c
>> dbsize.c:1: postgres.h: No such file or directory[/color][/color]
[color=blue]
> I don't understand why it can't find these files.. They are indeed in
> "~/postgresql-7.4.2/src/include" just as the -I points =(.[/color]

The shell isn't gonna expand ~ for you when it's within a word like
that. I think you were lucky that configure succeeded at all with
such a setting...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

#8 November 23rd, 2005, 01:08 AM

Hello Tom,

Thanks, that worked.

Regards,
Vitaly Belman

ICQ: 1912453
AIM: VitalyB1984
MSN: tmdagent@hotmail.com
Yahoo!: VitalyBe

Friday, June 11, 2004, 12:55:53 AM, you wrote:

TL> Vitaly Belman <vitalib@012.net.il> writes:[color=blue][color=green][color=darkred]
>>> gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes
>>> -Wmissing-declarations -fpic -I. -I~/postgresql-7.4.2/src/include
>>> -D_GNU_SOURCE -c -o dbsize.o dbsize.c
>>> dbsize.c:1: postgres.h: No such file or directory[/color][/color][/color]
[color=blue][color=green]
>> I don't understand why it can't find these files.. They are indeed in
>> "~/postgresql-7.4.2/src/include" just as the -I points =(.[/color][/color]

TL> The shell isn't gonna expand ~ for you when it's within a word like
TL> that. I think you were lucky that configure succeeded at all with
TL> such a setting...

TL> regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

#9 November 23rd, 2005, 01:08 AM

Hello Tom,

Thanks, that worked.

Regards,
Vitaly Belman

ICQ: 1912453
AIM: VitalyB1984
MSN: tmdagent@hotmail.com
Yahoo!: VitalyBe

Friday, June 11, 2004, 12:55:53 AM, you wrote:

TL> Vitaly Belman <vitalib@012.net.il> writes:[color=blue][color=green][color=darkred]
>>> gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes
>>> -Wmissing-declarations -fpic -I. -I~/postgresql-7.4.2/src/include
>>> -D_GNU_SOURCE -c -o dbsize.o dbsize.c
>>> dbsize.c:1: postgres.h: No such file or directory[/color][/color][/color]
[color=blue][color=green]
>> I don't understand why it can't find these files.. They are indeed in
>> "~/postgresql-7.4.2/src/include" just as the -I points =(.[/color][/color]

TL> The shell isn't gonna expand ~ for you when it's within a word like
TL> that. I think you were lucky that configure succeeded at all with
TL> such a setting...

TL> regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

What is Bytes?

Popular Articles